Track Bookings


TEST

Nothing to track!

Bepaal target-resources


SQL(): select distinct `visit`.`group_id` AS `group_id`,`visit`.`event_id` AS `event_id`, `event`.`shrt_description` AS `shrt_description`,`visit`.`start_date` AS `start_date`,`visit`.`start_time` AS `start_time`, `groep`.`booking_id` AS `booking_id`,`res`.`id` AS `resource_id`,`res`.`type` AS `resource_type`, `visit`.`resource_type` as `type`, `visit`.`language` AS `language`, `res`.`id` AS `res_id`,`visit`.`resource_requested` AS `resource_requested`,`visit`.`target_id` AS `target_id`, `res`.`firstname` AS `firstname`,`res`.`email` AS `email`,`res`.`phone` AS `phone`,`res`.`wp_username` AS `wp_username`, `groep`.`group_naam` AS `groepnaam`,`groep`.`group_size_nl` AS `group_size_nl`,`groep`.`group_size_en` AS `group_size_en`, `groep`.`group_size_fr` AS `group_size_fr`, `visit`.`opmerkingen` AS `opmerking`, `visit`.`id` as `visit_id` from `mm_visit_visit` as `visit` CROSS join (`mm_visit_resource` as `res`, `mm_visit_group` as `groep`, `mm_visit_event` as `event`, `mm_visit_cap` as `cap` ) on (`visit`.`resource_type` = `res`.`type` and `groep`.`booking_id` = `visit`.`booking_id`and `visit`.`event_id` = `event`.`event_id` and `res`.`id` = `cap`.`gids_id` and `cap`.`expertise` = `visit`.`language` ) where resource_requested = '0' and start_date > current_timestamp() and start_date < (CURRENT_TIMESTAMP() + 10000000000) order by `visit`.`booking_id`,`res`.`id`,`res`.`type`

Mail target-gidsen

Aantal targets: ; SQL: SELECT DISTINCT id, start_date, start_time, booking_id, resource_id, resource_type, firstname, wp_username, taal, event_id, shrt_description, email, mail_send, aantal, groepnaam FROM mm_visit_targets as target WHERE target.mail_send = 0 AND start_date > current_timestamp() AND start_date < (CURRENT_TIMESTAMP() + 10000000000) ORDER BY email, start_date, start_time, taal

Mails verzonden: 0

TEST

Please login! Inloggen aub!

Geen toewijzing mails!
Sorry, but you do not have permission to view this content.

Jammer, maar U heeft geen toestemming om deze inhoud te bekijken.