> moriaapp@0.1.0 start
> next start -p 3001

▲ Next.js 16.2.3
- Local:         http://localhost:3001
- Network:       http://136.243.206.115:3001
✓ Ready in 102ms
Executing (default): SELECT count(*) AS `count` FROM `Guides` AS `Guide`;
Executing (default): SELECT count(*) AS `count` FROM `Cities` AS `City`;
Executing (default): SELECT count(*) AS `count` FROM `Institutions` AS `Institution`;
Executing (default): SELECT `startTime`, `endTime` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` ORDER BY `Guide`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'pending' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'rejected' ORDER BY `HourReport`.`updatedAt` DESC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` WHERE `HourReport`.`createdAt` >= '2026-05-20 16:46:58' ORDER BY `HourReport`.`createdAt` DESC LIMIT 20;
Executing (default): SELECT `guideId` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` WHERE `Guide`.`createdAt` >= '2026-04-27 16:46:58' ORDER BY `Guide`.`createdAt` DESC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`name`, `Institution`.`createdAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` WHERE `Institution`.`createdAt` >= '2026-04-27 16:46:58' ORDER BY `Institution`.`createdAt` DESC;
Executing (default): SELECT `id`, `name`, `phone`, `loginToken`, `loginTokenExpiry` FROM `Guides` AS `Guide` ORDER BY `Guide`.`name` ASC;
Executing (default): SELECT `guideId` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `loginToken`, `loginTokenExpiry` FROM `Guides` AS `Guide` WHERE `Guide`.`id` IN (18);
=== SMS019 REQUEST ===
URL: https://019sms.co.il/api
Body:
<?xml version='1.0' encoding='UTF-8'?>
<sms>
  <user>
    <username>AmitSms</username>
  </user>
  <source>Kosherosher</source>
  <destinations>
    <phone>0544782838</phone>
  </destinations>
  <message>שלום עמית בדיקה,
את צריכה למלא את שעות העבודה לחודש מאי.
לדיווח שעות לחצי כאן:
https://moria.amitnet.info/api/guide/auth?token=MTg6MTc4NjM2NzcwMjo0NmFlYjlhNzViMWZiNTNlZGNkYzA0ZWE0YjAxZmU0NzQ0OGY1MmIyOTRkNjNiMDc1YTBlMjhiNzVjNmQ5Y2Jm&redirect=/guide/dashboard/hours

בכושר ובאושר</message>
</sms>
=====================
[sms019] response: <?xml version="1.0" encoding="utf-8"?>
<sms><status>0</status><message>SMS will be sent</message><shipment_id>3557201221</shipment_id></sms>

Executing (default): SELECT `id`, `key`, `value`, `createdAt`, `updatedAt` FROM `Settings` AS `Setting` WHERE `Setting`.`key` = 'sms_sent_total';
Executing (default): UPDATE `Settings` SET `value`=?,`updatedAt`=? WHERE `key` = ?
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '18';
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 18 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 18 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): INSERT INTO `HourReports` (`id`,`guideId`,`institutionId`,`date`,`startTime`,`endTime`,`notes`,`status`,`kilometers`,`createdAt`,`updatedAt`) VALUES (DEFAULT,?,?,?,?,?,?,?,?,?,?);
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`id` = 10;
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '18';
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 18 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 18 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '18';
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 18 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 18 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): INSERT INTO `HourReports` (`id`,`guideId`,`institutionId`,`date`,`startTime`,`endTime`,`notes`,`status`,`kilometers`,`createdAt`,`updatedAt`) VALUES (DEFAULT,?,?,?,?,?,?,?,?,?,?);
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`id` = 11;
Executing (default): SELECT `id`, `name`, `phone`, `loginToken`, `loginTokenExpiry` FROM `Guides` AS `Guide` ORDER BY `Guide`.`name` ASC;
Executing (default): SELECT `guideId` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Guide`.`phone` AS `Guide.phone`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `id`, `name`, `phone`, `loginToken`, `loginTokenExpiry` FROM `Guides` AS `Guide` ORDER BY `Guide`.`name` ASC;
Executing (default): SELECT `guideId` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `loginToken`, `loginTokenExpiry` FROM `Guides` AS `Guide` WHERE `Guide`.`id` IN (18);
=== SMS019 REQUEST ===
URL: https://019sms.co.il/api
Body:
<?xml version='1.0' encoding='UTF-8'?>
<sms>
  <user>
    <username>AmitSms</username>
  </user>
  <source>Kosherosher</source>
  <destinations>
    <phone>0544782838</phone>
  </destinations>
  <message>שלום עמית בדיקה,
את צריכה למלא את שעות העבודה לחודש מאי.
לדיווח שעות לחצי כאן:
https://moria.amitnet.info/api/guide/auth?token=MTg6MTc4NjM2NzcwMjo0NmFlYjlhNzViMWZiNTNlZGNkYzA0ZWE0YjAxZmU0NzQ0OGY1MmIyOTRkNjNiMDc1YTBlMjhiNzVjNmQ5Y2Jm&redirect=/guide/dashboard/hours

בכושר ובאושר</message>
</sms>
=====================
[sms019] response: <?xml version="1.0" encoding="utf-8"?>
<sms><status>0</status><message>SMS will be sent</message><shipment_id>3557207975</shipment_id></sms>

Executing (default): SELECT `id`, `key`, `value`, `createdAt`, `updatedAt` FROM `Settings` AS `Setting` WHERE `Setting`.`key` = 'sms_sent_total';
Executing (default): UPDATE `Settings` SET `value`=?,`updatedAt`=? WHERE `key` = ?
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '18';
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 18 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 18 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): INSERT INTO `HourReports` (`id`,`guideId`,`institutionId`,`date`,`startTime`,`endTime`,`notes`,`status`,`kilometers`,`createdAt`,`updatedAt`) VALUES (DEFAULT,?,?,?,?,?,?,?,?,?,?);
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`id` = 12;
Executing (default): SELECT `id`, `username`, `password`, `createdAt`, `updatedAt` FROM `Users` AS `User` WHERE `User`.`username` = 'admin';
Executing (default): SELECT count(*) AS `count` FROM `Guides` AS `Guide`;
Executing (default): SELECT count(*) AS `count` FROM `Cities` AS `City`;
Executing (default): SELECT count(*) AS `count` FROM `Institutions` AS `Institution`;
Executing (default): SELECT `startTime`, `endTime` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` ORDER BY `Guide`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'pending' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'rejected' ORDER BY `HourReport`.`updatedAt` DESC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` WHERE `HourReport`.`createdAt` >= '2026-05-20 18:39:00' ORDER BY `HourReport`.`createdAt` DESC LIMIT 20;
Executing (default): SELECT `guideId` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` WHERE `Guide`.`createdAt` >= '2026-04-27 18:39:00' ORDER BY `Guide`.`createdAt` DESC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`name`, `Institution`.`createdAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` WHERE `Institution`.`createdAt` >= '2026-04-27 18:39:00' ORDER BY `Institution`.`createdAt` DESC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Guide`.`phone` AS `Guide.phone`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT count(*) AS `count` FROM `Guides` AS `Guide`;
Executing (default): SELECT count(*) AS `count` FROM `Cities` AS `City`;
Executing (default): SELECT count(*) AS `count` FROM `Institutions` AS `Institution`;
Executing (default): SELECT `startTime`, `endTime` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` ORDER BY `Guide`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'pending' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'rejected' ORDER BY `HourReport`.`updatedAt` DESC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` WHERE `HourReport`.`createdAt` >= '2026-05-20 19:32:30' ORDER BY `HourReport`.`createdAt` DESC LIMIT 20;
Executing (default): SELECT `guideId` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` WHERE `Guide`.`createdAt` >= '2026-04-27 19:32:30' ORDER BY `Guide`.`createdAt` DESC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`name`, `Institution`.`createdAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` WHERE `Institution`.`createdAt` >= '2026-04-27 19:32:30' ORDER BY `Institution`.`createdAt` DESC;
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'LessonPlans' AND TABLE_SCHEMA = 'amitneto_moria'
Executing (default): SHOW INDEX FROM `LessonPlans`
Executing (default): SELECT `id`, `title`, `link`, `fileType`, `description`, `createdAt`, `updatedAt` FROM `LessonPlans` AS `LessonPlan` ORDER BY `LessonPlan`.`createdAt` DESC;
Executing (default): SELECT count(*) AS `count` FROM `Guides` AS `Guide`;
Executing (default): SELECT count(*) AS `count` FROM `Cities` AS `City`;
Executing (default): SELECT count(*) AS `count` FROM `Institutions` AS `Institution`;
Executing (default): SELECT `startTime`, `endTime` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` ORDER BY `Guide`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'pending' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'rejected' ORDER BY `HourReport`.`updatedAt` DESC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` WHERE `HourReport`.`createdAt` >= '2026-05-20 19:33:28' ORDER BY `HourReport`.`createdAt` DESC LIMIT 20;
Executing (default): SELECT `guideId` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` WHERE `Guide`.`createdAt` >= '2026-04-27 19:33:28' ORDER BY `Guide`.`createdAt` DESC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`name`, `Institution`.`createdAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` WHERE `Institution`.`createdAt` >= '2026-04-27 19:33:28' ORDER BY `Institution`.`createdAt` DESC;
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'LessonPlans' AND TABLE_SCHEMA = 'amitneto_moria'
Executing (default): SHOW INDEX FROM `LessonPlans`
Executing (default): SELECT `id`, `title`, `link`, `fileType`, `description`, `createdAt`, `updatedAt` FROM `LessonPlans` AS `LessonPlan` ORDER BY `LessonPlan`.`createdAt` DESC;
Executing (default): SELECT count(*) AS `count` FROM `Guides` AS `Guide`;
Executing (default): SELECT count(*) AS `count` FROM `Cities` AS `City`;
Executing (default): SELECT count(*) AS `count` FROM `Institutions` AS `Institution`;
Executing (default): SELECT `startTime`, `endTime` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` ORDER BY `Guide`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'pending' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'rejected' ORDER BY `HourReport`.`updatedAt` DESC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` WHERE `HourReport`.`createdAt` >= '2026-05-20 19:35:52' ORDER BY `HourReport`.`createdAt` DESC LIMIT 20;
Executing (default): SELECT `guideId` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` WHERE `Guide`.`createdAt` >= '2026-04-27 19:35:52' ORDER BY `Guide`.`createdAt` DESC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`name`, `Institution`.`createdAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` WHERE `Institution`.`createdAt` >= '2026-04-27 19:35:52' ORDER BY `Institution`.`createdAt` DESC;
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'LessonPlans' AND TABLE_SCHEMA = 'amitneto_moria'
Executing (default): SHOW INDEX FROM `LessonPlans`
Executing (default): SELECT `id`, `title`, `link`, `fileType`, `description`, `createdAt`, `updatedAt` FROM `LessonPlans` AS `LessonPlan` ORDER BY `LessonPlan`.`createdAt` DESC;
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'LessonPlans' AND TABLE_SCHEMA = 'amitneto_moria'
Executing (default): SHOW INDEX FROM `LessonPlans`
Executing (default): SELECT `id`, `title`, `link`, `fileType`, `description`, `createdAt`, `updatedAt` FROM `LessonPlans` AS `LessonPlan` ORDER BY `LessonPlan`.`createdAt` DESC;
Executing (default): SELECT `id`, `name`, `magicToken`, `magicTokenExpiry` FROM `Guides` AS `Guide` WHERE `Guide`.`magicToken` = '4884e8b3be3dfcc5a3e75c13f05f6337c54a972935fc885e136b4be3f069e081' LIMIT 1;
Executing (default): SELECT `id`, `name`, `phone`, `password`, `form101Path`, `contractPath`, `magicToken`, `magicTokenExpiry`, `loginToken`, `loginTokenExpiry`, `createdAt`, `updatedAt` FROM `Guides` AS `Guide` WHERE `Guide`.`phone` = 'admin' LIMIT 1;
Executing (default): SELECT `id`, `name`, `phone`, `password`, `form101Path`, `contractPath`, `magicToken`, `magicTokenExpiry`, `loginToken`, `loginTokenExpiry`, `createdAt`, `updatedAt` FROM `Guides` AS `Guide` WHERE `Guide`.`phone` = 'admin' LIMIT 1;
Executing (default): SELECT `id`, `name`, `magicToken`, `magicTokenExpiry` FROM `Guides` AS `Guide` WHERE `Guide`.`magicToken` = 'baa3679af0cb2297f0f4a94b9738a5a382bb9286466419d1c928a1c22d7f938e' LIMIT 1;
Executing (default): SELECT count(*) AS `count` FROM `Guides` AS `Guide`;
Executing (default): SELECT count(*) AS `count` FROM `Cities` AS `City`;
Executing (default): SELECT count(*) AS `count` FROM `Institutions` AS `Institution`;
Executing (default): SELECT `startTime`, `endTime` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` ORDER BY `Guide`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'pending' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'rejected' ORDER BY `HourReport`.`updatedAt` DESC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` WHERE `HourReport`.`createdAt` >= '2026-05-20 19:45:01' ORDER BY `HourReport`.`createdAt` DESC LIMIT 20;
Executing (default): SELECT `guideId` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` WHERE `Guide`.`createdAt` >= '2026-04-27 19:45:01' ORDER BY `Guide`.`createdAt` DESC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`name`, `Institution`.`createdAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` WHERE `Institution`.`createdAt` >= '2026-04-27 19:45:01' ORDER BY `Institution`.`createdAt` DESC;
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` ORDER BY `Guide`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'pending' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'rejected' ORDER BY `HourReport`.`updatedAt` DESC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` WHERE `HourReport`.`createdAt` >= '2026-05-20 19:50:55' ORDER BY `HourReport`.`createdAt` DESC LIMIT 20;
Executing (default): SELECT `guideId` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` WHERE `Guide`.`createdAt` >= '2026-04-27 19:50:55' ORDER BY `Guide`.`createdAt` DESC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`name`, `Institution`.`createdAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` WHERE `Institution`.`createdAt` >= '2026-04-27 19:50:55' ORDER BY `Institution`.`createdAt` DESC;
Executing (default): SELECT count(*) AS `count` FROM `Guides` AS `Guide`;
Executing (default): SELECT count(*) AS `count` FROM `Cities` AS `City`;
Executing (default): SELECT count(*) AS `count` FROM `Institutions` AS `Institution`;
Executing (default): SELECT `startTime`, `endTime` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Guide`.`phone` AS `Guide.phone`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name`, `Institution->City`.`guideHourlyRates` AS `Institution.City.guideHourlyRates`, `Institution->City`.`guideKmRates` AS `Institution.City.guideKmRates`, `Institution->City`.`hourlyRate` AS `Institution.City.hourlyRate` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' AND `HourReport`.`status` = 'approved' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT count(*) AS `count` FROM `Guides` AS `Guide`;
Executing (default): SELECT count(*) AS `count` FROM `Cities` AS `City`;
Executing (default): SELECT count(*) AS `count` FROM `Institutions` AS `Institution`;
Executing (default): SELECT `startTime`, `endTime` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` ORDER BY `Guide`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'pending' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'rejected' ORDER BY `HourReport`.`updatedAt` DESC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` WHERE `HourReport`.`createdAt` >= '2026-05-20 19:52:32' ORDER BY `HourReport`.`createdAt` DESC LIMIT 20;
Executing (default): SELECT `guideId` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` WHERE `Guide`.`createdAt` >= '2026-04-27 19:52:32' ORDER BY `Guide`.`createdAt` DESC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`name`, `Institution`.`createdAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` WHERE `Institution`.`createdAt` >= '2026-04-27 19:52:32' ORDER BY `Institution`.`createdAt` DESC;
Executing (default): SELECT `id`, `name`, `phone`, `createdAt`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` ORDER BY `Guide`.`id` DESC;
Executing (default): SELECT `id`, `key`, `value`, `createdAt`, `updatedAt` FROM `Settings` AS `Setting` WHERE `Setting`.`key` = 'sms_sent_total';
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution`.`hourlyRates` AS `Institution.hourlyRates`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name`, `Institution->City`.`hourlyRate` AS `Institution.City.hourlyRate`, `Institution->City`.`billingEmail` AS `Institution.City.billingEmail`, `Institution->City`.`billingEmails` AS `Institution.City.billingEmails`, `Institution->City`.`contactName` AS `Institution.City.contactName` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' AND `HourReport`.`status` = 'approved' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT `id`, `name`, `phone`, `createdAt`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` ORDER BY `Guide`.`id` DESC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution`.`hourlyRates` AS `Institution.hourlyRates`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name`, `Institution->City`.`hourlyRate` AS `Institution.City.hourlyRate`, `Institution->City`.`billingEmail` AS `Institution.City.billingEmail`, `Institution->City`.`billingEmails` AS `Institution.City.billingEmails`, `Institution->City`.`contactName` AS `Institution.City.contactName` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' AND `HourReport`.`status` = 'approved' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT `id`, `name`, `contactName`, `contactPhone`, `billingEmail`, `billingEmails`, `hourlyRate`, `guideHourlyRates`, `guideKmRates`, `createdAt`, `updatedAt` FROM `Cities` AS `City` ORDER BY `City`.`id` DESC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution`.`hourlyRates` AS `Institution.hourlyRates`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name`, `Institution->City`.`hourlyRate` AS `Institution.City.hourlyRate`, `Institution->City`.`billingEmail` AS `Institution.City.billingEmail`, `Institution->City`.`billingEmails` AS `Institution.City.billingEmails`, `Institution->City`.`contactName` AS `Institution.City.contactName` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' AND `HourReport`.`status` = 'approved' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT count(*) AS `count` FROM `Guides` AS `Guide`;
Executing (default): SELECT count(*) AS `count` FROM `Cities` AS `City`;
Executing (default): SELECT count(*) AS `count` FROM `Institutions` AS `Institution`;
Executing (default): SELECT `startTime`, `endTime` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` ORDER BY `Guide`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'pending' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'rejected' ORDER BY `HourReport`.`updatedAt` DESC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` WHERE `HourReport`.`createdAt` >= '2026-05-20 20:13:47' ORDER BY `HourReport`.`createdAt` DESC LIMIT 20;
Executing (default): SELECT `guideId` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` WHERE `Guide`.`createdAt` >= '2026-04-27 20:13:47' ORDER BY `Guide`.`createdAt` DESC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`name`, `Institution`.`createdAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` WHERE `Institution`.`createdAt` >= '2026-04-27 20:13:47' ORDER BY `Institution`.`createdAt` DESC;
Executing (default): INSERT INTO `Guides` (`id`,`name`,`phone`,`password`,`createdAt`,`updatedAt`) VALUES (DEFAULT,?,?,?,?,?);
Executing (default): UPDATE `Guides` SET `loginToken`=?,`loginTokenExpiry`=?,`updatedAt`=? WHERE `id` = ?
=== SMS019 REQUEST ===
URL: https://019sms.co.il/api
Body:
<?xml version='1.0' encoding='UTF-8'?>
<sms>
  <user>
    <username>AmitSms</username>
  </user>
  <source>Kosherosher</source>
  <destinations>
    <phone>0533622262</phone>
  </destinations>
  <message>ברוכה הבאה מאיר אדמון!
נרשמת למערכת ב.כושר.
לכניסה למערכת:
https://moria.amitnet.info/api/guide/auth?token=MTk6MTc4NzY4ODg1NDpkMjYxNDllNjU2Y2Q0ZGMzYmYyODZlOWYxODNhMDU4ZTgwNjVhYTZkYzNlNDNjZTBjNzE4OTNiZmVmNzRhZTEx</message>
</sms>
=====================
[sms019] response: <?xml version="1.0" encoding="utf-8"?>
<sms><status>0</status><message>SMS will be sent</message><shipment_id>3557364121</shipment_id></sms>

Executing (default): SELECT `id`, `key`, `value`, `createdAt`, `updatedAt` FROM `Settings` AS `Setting` WHERE `Setting`.`key` = 'sms_sent_total';
Executing (default): UPDATE `Settings` SET `value`=?,`updatedAt`=? WHERE `key` = ?
Executing (default): SELECT `id`, `name`, `phone`, `createdAt`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` ORDER BY `Guide`.`id` DESC;
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '19';
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '19';
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `name`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = 19;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 AND `WorkSchedule`.`date` BETWEEN '2026-05-26' AND '2026-06-25' ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 AND `WorkSchedule`.`date` BETWEEN '2026-05-26' AND '2026-06-25' ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 AND `WorkSchedule`.`date` BETWEEN '2026-05-26' AND '2026-06-25' ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 19 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): INSERT INTO `HourReports` (`id`,`guideId`,`institutionId`,`date`,`startTime`,`endTime`,`notes`,`status`,`kilometers`,`createdAt`,`updatedAt`) VALUES (DEFAULT,?,?,?,?,?,?,?,?,?,?);
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`id` = 13;
Executing (default): SELECT `id`, `guideId`, `institutionId`, `date`, `startTime`, `endTime`, `notes`, `status`, `rejectionReason`, `kilometers`, `createdAt`, `updatedAt` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`id` = '13' AND `HourReport`.`guideId` = 19;
Executing (default): DELETE FROM `HourReports` WHERE `id` = 13
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `name`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = 19;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 19 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `title`, `link`, `fileType`, `description`, `createdAt`, `updatedAt` FROM `LessonPlans` AS `LessonPlan` ORDER BY `LessonPlan`.`createdAt` DESC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 19 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `id`, `title`, `link`, `fileType`, `description`, `createdAt`, `updatedAt` FROM `LessonPlans` AS `LessonPlan` ORDER BY `LessonPlan`.`createdAt` DESC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `name`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = 19;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 AND `WorkSchedule`.`date` BETWEEN '2026-05-26' AND '2026-06-25' ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 19 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): INSERT INTO `HourReports` (`id`,`guideId`,`institutionId`,`date`,`startTime`,`endTime`,`notes`,`status`,`kilometers`,`createdAt`,`updatedAt`) VALUES (DEFAULT,?,?,?,?,?,?,?,?,?,?);
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`id` = 14;
Executing (default): INSERT INTO `HourReports` (`id`,`guideId`,`institutionId`,`date`,`startTime`,`endTime`,`notes`,`status`,`kilometers`,`createdAt`,`updatedAt`) VALUES (DEFAULT,?,?,?,?,?,?,?,?,?,?);
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`id` = 15;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 AND `WorkSchedule`.`date` BETWEEN '2026-05-26' AND '2026-06-25' ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `title`, `link`, `fileType`, `description`, `createdAt`, `updatedAt` FROM `LessonPlans` AS `LessonPlan` ORDER BY `LessonPlan`.`createdAt` DESC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT count(*) AS `count` FROM `Guides` AS `Guide`;
Executing (default): SELECT count(*) AS `count` FROM `Cities` AS `City`;
Executing (default): SELECT count(*) AS `count` FROM `Institutions` AS `Institution`;
Executing (default): SELECT `startTime`, `endTime` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` ORDER BY `Guide`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'pending' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'rejected' ORDER BY `HourReport`.`updatedAt` DESC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` WHERE `HourReport`.`createdAt` >= '2026-05-20 21:07:14' ORDER BY `HourReport`.`createdAt` DESC LIMIT 20;
Executing (default): SELECT `guideId` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` WHERE `Guide`.`createdAt` >= '2026-04-27 21:07:14' ORDER BY `Guide`.`createdAt` DESC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`name`, `Institution`.`createdAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` WHERE `Institution`.`createdAt` >= '2026-04-27 21:07:14' ORDER BY `Institution`.`createdAt` DESC;
Executing (default): SELECT `id`, `name`, `phone`, `createdAt`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` ORDER BY `Guide`.`id` DESC;
Executing (default): SELECT `id`, `name`, `phone`, `loginToken`, `loginTokenExpiry` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '19';
=== SMS019 REQUEST ===
URL: https://019sms.co.il/api
Body:
<?xml version='1.0' encoding='UTF-8'?>
<sms>
  <user>
    <username>AmitSms</username>
  </user>
  <source>Kosherosher</source>
  <destinations>
    <phone>0533622262</phone>
  </destinations>
  <message>שלום מאיר אדמון,
לכניסה למערכת ב.כושר:
https://moria.amitnet.info/api/guide/auth?token=MTk6MTc4NzY4ODg1NDpkMjYxNDllNjU2Y2Q0ZGMzYmYyODZlOWYxODNhMDU4ZTgwNjVhYTZkYzNlNDNjZTBjNzE4OTNiZmVmNzRhZTEx</message>
</sms>
=====================
[sms019] response: <?xml version="1.0" encoding="utf-8"?>
<sms><status>0</status><message>SMS will be sent</message><shipment_id>3557380959</shipment_id></sms>

[send-login-sms] {"status":0,"message":"SMS will be sent","shipment_id":"3557380959"}
Executing (default): SELECT `id`, `key`, `value`, `createdAt`, `updatedAt` FROM `Settings` AS `Setting` WHERE `Setting`.`key` = 'sms_sent_total';
Executing (default): UPDATE `Settings` SET `value`=?,`updatedAt`=? WHERE `key` = ?
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '19';
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '19';
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `name`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = 19;
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '19';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` ORDER BY `Guide`.`id` DESC;
Executing (default): SELECT `id`, `name`, `loginToken`, `loginTokenExpiry` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '19';
Executing (default): SELECT `id`, `name`, `phone`, `loginToken`, `loginTokenExpiry` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '6';
Executing (default): UPDATE `Guides` SET `loginToken`=?,`loginTokenExpiry`=?,`updatedAt`=? WHERE `id` = ?
=== SMS019 REQUEST ===
URL: https://019sms.co.il/api
Body:
<?xml version='1.0' encoding='UTF-8'?>
<sms>
  <user>
    <username>AmitSms</username>
  </user>
  <source>Kosherosher</source>
  <destinations>
    <phone>0556673387</phone>
  </destinations>
  <message>שלום מילכה אסרף,
לכניסה למערכת ב.כושר:
https://moria.amitnet.info/api/guide/auth?token=NjoxNzg3NjkyMTA4OjNkMDlkYzUzNzFkZTNiNTAyNDhiYWQ4NWRhOTEzNGJiMjkwMTIwOTRiYmQzZGQxYmJmNTM5NTI1MzVlNTc0Mjk</message>
</sms>
=====================
[sms019] response: <?xml version="1.0" encoding="utf-8"?>
<sms><status>0</status><message>SMS will be sent</message><shipment_id>3557381088</shipment_id></sms>

[send-login-sms] {"status":0,"message":"SMS will be sent","shipment_id":"3557381088"}
Executing (default): SELECT `id`, `key`, `value`, `createdAt`, `updatedAt` FROM `Settings` AS `Setting` WHERE `Setting`.`key` = 'sms_sent_total';
Executing (default): UPDATE `Settings` SET `value`=?,`updatedAt`=? WHERE `key` = ?
Executing (default): SELECT `id`, `name`, `phone`, `loginToken`, `loginTokenExpiry` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '10';
Executing (default): UPDATE `Guides` SET `loginToken`=?,`loginTokenExpiry`=?,`updatedAt`=? WHERE `id` = ?
=== SMS019 REQUEST ===
URL: https://019sms.co.il/api
Body:
<?xml version='1.0' encoding='UTF-8'?>
<sms>
  <user>
    <username>AmitSms</username>
  </user>
  <source>Kosherosher</source>
  <destinations>
    <phone>0545876013</phone>
  </destinations>
  <message>שלום בת חן חזן,
לכניסה למערכת ב.כושר:
https://moria.amitnet.info/api/guide/auth?token=MTA6MTc4NzY5MjExMTo3NDRjNGM4ZWQ2OTQxYmQ4YTc3ZjUxY2VlZWQyZmY1YjU0Zjg5ZDUzNjJjYzZhNjY0ZmU1ZTIwMDVkYTFiMjhl</message>
</sms>
=====================
[sms019] response: <?xml version="1.0" encoding="utf-8"?>
<sms><status>0</status><message>SMS will be sent</message><shipment_id>3557381100</shipment_id></sms>

[send-login-sms] {"status":0,"message":"SMS will be sent","shipment_id":"3557381100"}
Executing (default): SELECT `id`, `key`, `value`, `createdAt`, `updatedAt` FROM `Settings` AS `Setting` WHERE `Setting`.`key` = 'sms_sent_total';
Executing (default): UPDATE `Settings` SET `value`=?,`updatedAt`=? WHERE `key` = ?
Executing (default): SELECT `id`, `name`, `phone`, `loginToken`, `loginTokenExpiry` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '11';
Executing (default): UPDATE `Guides` SET `loginToken`=?,`loginTokenExpiry`=?,`updatedAt`=? WHERE `id` = ?
=== SMS019 REQUEST ===
URL: https://019sms.co.il/api
Body:
<?xml version='1.0' encoding='UTF-8'?>
<sms>
  <user>
    <username>AmitSms</username>
  </user>
  <source>Kosherosher</source>
  <destinations>
    <phone>0525066338</phone>
  </destinations>
  <message>שלום מוריה בוטבול,
לכניסה למערכת ב.כושר:
https://moria.amitnet.info/api/guide/auth?token=MTE6MTc4NzY5MjExMjo5OGQyMTJlYjkxNDU5MGM4OTNkYjM3ZjBkNzUxMDg0ODg1NjA3OTg4ZmRlYzZhOGJjMmM0MzI4ZjM4MDA1YmQx</message>
</sms>
=====================
[sms019] response: <?xml version="1.0" encoding="utf-8"?>
<sms><status>0</status><message>SMS will be sent</message><shipment_id>3557381102</shipment_id></sms>

[send-login-sms] {"status":0,"message":"SMS will be sent","shipment_id":"3557381102"}
Executing (default): SELECT `id`, `key`, `value`, `createdAt`, `updatedAt` FROM `Settings` AS `Setting` WHERE `Setting`.`key` = 'sms_sent_total';
Executing (default): UPDATE `Settings` SET `value`=?,`updatedAt`=? WHERE `key` = ?
Executing (default): SELECT `id`, `name`, `phone`, `loginToken`, `loginTokenExpiry` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '12';
Executing (default): UPDATE `Guides` SET `loginToken`=?,`loginTokenExpiry`=?,`updatedAt`=? WHERE `id` = ?
=== SMS019 REQUEST ===
URL: https://019sms.co.il/api
Body:
<?xml version='1.0' encoding='UTF-8'?>
<sms>
  <user>
    <username>AmitSms</username>
  </user>
  <source>Kosherosher</source>
  <destinations>
    <phone>0556746635</phone>
  </destinations>
  <message>שלום מיכל בוקובזה,
לכניסה למערכת ב.כושר:
https://moria.amitnet.info/api/guide/auth?token=MTI6MTc4NzY5MjExNDowMDVhMTlmZTZlOWYxYTlmN2Q5YmJjNTBkNjk2YzhjMjQxZTFjOTRiYTA0MTU0YmUxOTVkODgyZGFkZDkyOWE0</message>
</sms>
=====================
[sms019] response: <?xml version="1.0" encoding="utf-8"?>
<sms><status>0</status><message>SMS will be sent</message><shipment_id>3557381108</shipment_id></sms>

[send-login-sms] {"status":0,"message":"SMS will be sent","shipment_id":"3557381108"}
Executing (default): SELECT `id`, `key`, `value`, `createdAt`, `updatedAt` FROM `Settings` AS `Setting` WHERE `Setting`.`key` = 'sms_sent_total';
Executing (default): UPDATE `Settings` SET `value`=?,`updatedAt`=? WHERE `key` = ?
Executing (default): SELECT `id`, `name`, `phone`, `loginToken`, `loginTokenExpiry` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '13';
Executing (default): UPDATE `Guides` SET `loginToken`=?,`loginTokenExpiry`=?,`updatedAt`=? WHERE `id` = ?
=== SMS019 REQUEST ===
URL: https://019sms.co.il/api
Body:
<?xml version='1.0' encoding='UTF-8'?>
<sms>
  <user>
    <username>AmitSms</username>
  </user>
  <source>Kosherosher</source>
  <destinations>
    <phone>0535423460</phone>
  </destinations>
  <message>שלום אביגיל ,
לכניסה למערכת ב.כושר:
https://moria.amitnet.info/api/guide/auth?token=MTM6MTc4NzY5MjExNTo4ZGZkYWEwZmNlNGM0NWE2NjM4MWE1ODIzZGExMmEwYjdjM2M0OTY2Mzk0ZWJiM2MxYzc3OWI0OWMzZWFmMjk0</message>
</sms>
=====================
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '11';
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '10';
[sms019] response: <?xml version="1.0" encoding="utf-8"?>
<sms><status>0</status><message>SMS will be sent</message><shipment_id>3557381112</shipment_id></sms>

[send-login-sms] {"status":0,"message":"SMS will be sent","shipment_id":"3557381112"}
Executing (default): SELECT `id`, `key`, `value`, `createdAt`, `updatedAt` FROM `Settings` AS `Setting` WHERE `Setting`.`key` = 'sms_sent_total';
Executing (default): UPDATE `Settings` SET `value`=?,`updatedAt`=? WHERE `key` = ?
Executing (default): SELECT `id`, `name`, `phone`, `loginToken`, `loginTokenExpiry` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '14';
Executing (default): UPDATE `Guides` SET `loginToken`=?,`loginTokenExpiry`=?,`updatedAt`=? WHERE `id` = ?
=== SMS019 REQUEST ===
URL: https://019sms.co.il/api
Body:
<?xml version='1.0' encoding='UTF-8'?>
<sms>
  <user>
    <username>AmitSms</username>
  </user>
  <source>Kosherosher</source>
  <destinations>
    <phone>0543490332</phone>
  </destinations>
  <message>שלום אלינור מיארה,
לכניסה למערכת ב.כושר:
https://moria.amitnet.info/api/guide/auth?token=MTQ6MTc4NzY5MjExNjozZmJhYjIxMDgxZDk0NGJiZjIyZjA1OTZkYTI4NGE4MTM5NTVhZmY5NTc2YjQ4NGFkYTNmOWY1M2Q1ZDBlNjdl</message>
</sms>
=====================
[sms019] response: <?xml version="1.0" encoding="utf-8"?>
<sms><status>0</status><message>SMS will be sent</message><shipment_id>3557381118</shipment_id></sms>

[send-login-sms] {"status":0,"message":"SMS will be sent","shipment_id":"3557381118"}
Executing (default): SELECT `id`, `key`, `value`, `createdAt`, `updatedAt` FROM `Settings` AS `Setting` WHERE `Setting`.`key` = 'sms_sent_total';
Executing (default): UPDATE `Settings` SET `value`=?,`updatedAt`=? WHERE `key` = ?
Executing (default): SELECT `id`, `name`, `phone`, `loginToken`, `loginTokenExpiry` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '15';
Executing (default): UPDATE `Guides` SET `loginToken`=?,`loginTokenExpiry`=?,`updatedAt`=? WHERE `id` = ?
=== SMS019 REQUEST ===
URL: https://019sms.co.il/api
Body:
<?xml version='1.0' encoding='UTF-8'?>
<sms>
  <user>
    <username>AmitSms</username>
  </user>
  <source>Kosherosher</source>
  <destinations>
    <phone>0527572898</phone>
  </destinations>
  <message>שלום חנה דוסטרה,
לכניסה למערכת ב.כושר:
https://moria.amitnet.info/api/guide/auth?token=MTU6MTc4NzY5MjExNzo4YWFmZTk1ZjFiZTM3NmJkZTI1ZTdlMjY1NzA1ODI0YjYyOGI5OGUzMDI2NWUyYjY3NTI0NDUzYjFhZWJiZjFl</message>
</sms>
=====================
[sms019] response: <?xml version="1.0" encoding="utf-8"?>
<sms><status>0</status><message>SMS will be sent</message><shipment_id>3557381120</shipment_id></sms>

[send-login-sms] {"status":0,"message":"SMS will be sent","shipment_id":"3557381120"}
Executing (default): SELECT `id`, `key`, `value`, `createdAt`, `updatedAt` FROM `Settings` AS `Setting` WHERE `Setting`.`key` = 'sms_sent_total';
Executing (default): UPDATE `Settings` SET `value`=?,`updatedAt`=? WHERE `key` = ?
Executing (default): SELECT `id`, `name`, `phone`, `loginToken`, `loginTokenExpiry` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '16';
Executing (default): UPDATE `Guides` SET `loginToken`=?,`loginTokenExpiry`=?,`updatedAt`=? WHERE `id` = ?
=== SMS019 REQUEST ===
URL: https://019sms.co.il/api
Body:
<?xml version='1.0' encoding='UTF-8'?>
<sms>
  <user>
    <username>AmitSms</username>
  </user>
  <source>Kosherosher</source>
  <destinations>
    <phone>0505944833</phone>
  </destinations>
  <message>שלום אירית בן שושן,
לכניסה למערכת ב.כושר:
https://moria.amitnet.info/api/guide/auth?token=MTY6MTc4NzY5MjExODo4YzhkMmJhYTk1MDEyOGYwNDBiMDc5YTE4OTg1MGQ2YTAyZjI0N2YzZjQ2OGQwZjkyMDkwNTE5NjE3OGIyMTRh</message>
</sms>
=====================
[sms019] response: <?xml version="1.0" encoding="utf-8"?>
<sms><status>0</status><message>SMS will be sent</message><shipment_id>3557381126</shipment_id></sms>

[send-login-sms] {"status":0,"message":"SMS will be sent","shipment_id":"3557381126"}
Executing (default): SELECT `id`, `key`, `value`, `createdAt`, `updatedAt` FROM `Settings` AS `Setting` WHERE `Setting`.`key` = 'sms_sent_total';
Executing (default): UPDATE `Settings` SET `value`=?,`updatedAt`=? WHERE `key` = ?
Executing (default): SELECT `id`, `name`, `phone`, `loginToken`, `loginTokenExpiry` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '17';
=== SMS019 REQUEST ===
URL: https://019sms.co.il/api
Body:
<?xml version='1.0' encoding='UTF-8'?>
<sms>
  <user>
    <username>AmitSms</username>
  </user>
  <source>Kosherosher</source>
  <destinations>
    <phone>0543382088</phone>
  </destinations>
  <message>שלום טלי אבוטבול,
לכניסה למערכת ב.כושר:
https://moria.amitnet.info/api/guide/auth?token=MTc6MTc4NTgzNTIyNTpiYjc5YTUzN2JmODY2ZDdlMTc2M2M2ZjE0NDM2NzZiODZkYTRiZjc4NDhiY2ExMjBjZWZhNDc5NDNkOThjN2M5</message>
</sms>
=====================
[sms019] response: <?xml version="1.0" encoding="utf-8"?>
<sms><status>0</status><message>SMS will be sent</message><shipment_id>3557381134</shipment_id></sms>

[send-login-sms] {"status":0,"message":"SMS will be sent","shipment_id":"3557381134"}
Executing (default): SELECT `id`, `key`, `value`, `createdAt`, `updatedAt` FROM `Settings` AS `Setting` WHERE `Setting`.`key` = 'sms_sent_total';
Executing (default): UPDATE `Settings` SET `value`=?,`updatedAt`=? WHERE `key` = ?
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '13';
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '16';
Executing (default): SELECT `id`, `name`, `phone`, `loginToken`, `loginTokenExpiry` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '18';
=== SMS019 REQUEST ===
URL: https://019sms.co.il/api
Body:
<?xml version='1.0' encoding='UTF-8'?>
<sms>
  <user>
    <username>AmitSms</username>
  </user>
  <source>Kosherosher</source>
  <destinations>
    <phone>0544782838</phone>
  </destinations>
  <message>שלום עמית בדיקה,
לכניסה למערכת ב.כושר:
https://moria.amitnet.info/api/guide/auth?token=MTg6MTc4NjM2NzcwMjo0NmFlYjlhNzViMWZiNTNlZGNkYzA0ZWE0YjAxZmU0NzQ0OGY1MmIyOTRkNjNiMDc1YTBlMjhiNzVjNmQ5Y2Jm</message>
</sms>
=====================
[sms019] response: <?xml version="1.0" encoding="utf-8"?>
<sms><status>0</status><message>SMS will be sent</message><shipment_id>3557381148</shipment_id></sms>

[send-login-sms] {"status":0,"message":"SMS will be sent","shipment_id":"3557381148"}
Executing (default): SELECT `id`, `key`, `value`, `createdAt`, `updatedAt` FROM `Settings` AS `Setting` WHERE `Setting`.`key` = 'sms_sent_total';
Executing (default): UPDATE `Settings` SET `value`=?,`updatedAt`=? WHERE `key` = ?
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '15';
Executing (default): SELECT count(*) AS `count` FROM `Guides` AS `Guide`;
Executing (default): SELECT count(*) AS `count` FROM `Cities` AS `City`;
Executing (default): SELECT count(*) AS `count` FROM `Institutions` AS `Institution`;
Executing (default): SELECT `startTime`, `endTime` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` ORDER BY `Guide`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'pending' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'rejected' ORDER BY `HourReport`.`updatedAt` DESC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` WHERE `HourReport`.`createdAt` >= '2026-05-20 21:08:45' ORDER BY `HourReport`.`createdAt` DESC LIMIT 20;
Executing (default): SELECT `guideId` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` WHERE `Guide`.`createdAt` >= '2026-04-27 21:08:45' ORDER BY `Guide`.`createdAt` DESC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`name`, `Institution`.`createdAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` WHERE `Institution`.`createdAt` >= '2026-04-27 21:08:45' ORDER BY `Institution`.`createdAt` DESC;
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '10';
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '11';
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '13';
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '15';
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '15';
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 15 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `name`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = 15;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 15 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 15 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 15 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 15 AND `WorkSchedule`.`date` BETWEEN '2026-05-27' AND '2026-06-26' ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 15 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 15 AND `WorkSchedule`.`date` BETWEEN '2026-05-27' AND '2026-06-26' ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 15 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `name`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = 15;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 15 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 15 AND `WorkSchedule`.`date` BETWEEN '2026-05-27' AND '2026-06-26' ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '6';
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 15 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 15 AND `WorkSchedule`.`date` BETWEEN '2026-05-27' AND '2026-06-26' ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 15 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 15 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 6 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `name`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = 6;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 6 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `title`, `link`, `fileType`, `description`, `createdAt`, `updatedAt` FROM `LessonPlans` AS `LessonPlan` ORDER BY `LessonPlan`.`createdAt` DESC;
Executing (default): SELECT `id`, `name`, `phone`, `createdAt`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` ORDER BY `Guide`.`id` DESC;
Executing (default): SELECT `id`, `name`, `phone`, `createdAt`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` ORDER BY `Guide`.`id` DESC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution`.`hourlyRates` AS `Institution.hourlyRates`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name`, `Institution->City`.`hourlyRate` AS `Institution.City.hourlyRate`, `Institution->City`.`billingEmail` AS `Institution.City.billingEmail`, `Institution->City`.`billingEmails` AS `Institution.City.billingEmails`, `Institution->City`.`contactName` AS `Institution.City.contactName` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' AND `HourReport`.`status` = 'approved' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'LessonPlans' AND TABLE_SCHEMA = 'amitneto_moria'
Executing (default): SHOW INDEX FROM `LessonPlans`
Executing (default): SELECT `id`, `title`, `link`, `fileType`, `description`, `createdAt`, `updatedAt` FROM `LessonPlans` AS `LessonPlan` ORDER BY `LessonPlan`.`createdAt` DESC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 15 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `title`, `link`, `fileType`, `description`, `createdAt`, `updatedAt` FROM `LessonPlans` AS `LessonPlan` ORDER BY `LessonPlan`.`createdAt` DESC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 15 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 15 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `id`, `name`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = 15;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 15 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 15 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 15 AND `WorkSchedule`.`date` BETWEEN '2026-05-27' AND '2026-06-26' ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 15 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `name`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = 15;
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '19';
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `name`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = 19;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 AND `WorkSchedule`.`date` BETWEEN '2026-05-27' AND '2026-06-26' ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 19 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '16';
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 19 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 19 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 AND `WorkSchedule`.`date` BETWEEN '2026-05-27' AND '2026-06-26' ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `name`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = 19;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `name`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = 19;
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '19';
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '11';
Executing (default): SELECT `id`, `name`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = 11;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 11 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 11 AND `WorkSchedule`.`date` BETWEEN '2026-05-27' AND '2026-06-26' ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 11 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 11 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 11 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '14';
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 14 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `name`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = 14;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 14 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 14 AND `WorkSchedule`.`date` BETWEEN '2026-05-27' AND '2026-06-26' ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 14 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 14 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 14 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `title`, `link`, `fileType`, `description`, `createdAt`, `updatedAt` FROM `LessonPlans` AS `LessonPlan` ORDER BY `LessonPlan`.`createdAt` DESC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 14 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `name`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = 14;
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '16';
Executing (default): SELECT `id`, `name`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = 16;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 16 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 16 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 16 AND `WorkSchedule`.`date` BETWEEN '2026-05-27' AND '2026-06-26' ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 16 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 16 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '16';
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 16 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `name`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = 16;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 16 AND `WorkSchedule`.`date` BETWEEN '2026-05-27' AND '2026-06-26' ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 16 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 16 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 16 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 16 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 16 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 16 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 16 AND `WorkSchedule`.`date` BETWEEN '2026-05-27' AND '2026-06-26' ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '16';
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 16 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `name`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = 16;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 16 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 16 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `id`, `name` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = '19';
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `name`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = 19;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 19 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 19 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`cityId`, `Institution`.`name`, `Institution`.`age`, `Institution`.`address`, `Institution`.`neighborhood`, `Institution`.`phone`, `Institution`.`hourlyRates`, `Institution`.`stream`, `Institution`.`symbolCode`, `Institution`.`createdAt`, `Institution`.`updatedAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` ORDER BY `City`.`name` ASC, `Institution`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`guideId` = 19 AND `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `id`, `name`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` WHERE `Guide`.`id` = 16;
Executing (default): SELECT `WorkSchedule`.`id`, `WorkSchedule`.`guideId`, `WorkSchedule`.`institutionId`, `WorkSchedule`.`date`, `WorkSchedule`.`startTime`, `WorkSchedule`.`endTime`, `WorkSchedule`.`createdAt`, `WorkSchedule`.`updatedAt`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `WorkSchedules` AS `WorkSchedule` LEFT OUTER JOIN `Institutions` AS `Institution` ON `WorkSchedule`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `WorkSchedule`.`guideId` = 16 ORDER BY `WorkSchedule`.`date` ASC, `WorkSchedule`.`startTime` ASC;
Executing (default): SELECT `id`, `username`, `password`, `createdAt`, `updatedAt` FROM `Users` AS `User` WHERE `User`.`username` = 'admin';
Executing (default): SELECT count(*) AS `count` FROM `Guides` AS `Guide`;
Executing (default): SELECT count(*) AS `count` FROM `Cities` AS `City`;
Executing (default): SELECT count(*) AS `count` FROM `Institutions` AS `Institution`;
Executing (default): SELECT `startTime`, `endTime` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` ORDER BY `Guide`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'pending' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'rejected' ORDER BY `HourReport`.`updatedAt` DESC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` WHERE `HourReport`.`createdAt` >= '2026-05-23 21:54:40' ORDER BY `HourReport`.`createdAt` DESC LIMIT 20;
Executing (default): SELECT `guideId` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` WHERE `Guide`.`createdAt` >= '2026-04-30 21:54:40' ORDER BY `Guide`.`createdAt` DESC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`name`, `Institution`.`createdAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` WHERE `Institution`.`createdAt` >= '2026-04-30 21:54:40' ORDER BY `Institution`.`createdAt` DESC;
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'LessonPlans' AND TABLE_SCHEMA = 'amitneto_moria'
Executing (default): SHOW INDEX FROM `LessonPlans`
Executing (default): SELECT `id`, `title`, `link`, `fileType`, `description`, `createdAt`, `updatedAt` FROM `LessonPlans` AS `LessonPlan` ORDER BY `LessonPlan`.`createdAt` DESC;
Executing (default): SELECT count(*) AS `count` FROM `Guides` AS `Guide`;
Executing (default): SELECT count(*) AS `count` FROM `Cities` AS `City`;
Executing (default): SELECT count(*) AS `count` FROM `Institutions` AS `Institution`;
Executing (default): SELECT `startTime`, `endTime` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` ORDER BY `Guide`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'pending' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'rejected' ORDER BY `HourReport`.`updatedAt` DESC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` WHERE `HourReport`.`createdAt` >= '2026-05-23 21:54:56' ORDER BY `HourReport`.`createdAt` DESC LIMIT 20;
Executing (default): SELECT `guideId` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` WHERE `Guide`.`createdAt` >= '2026-04-30 21:54:56' ORDER BY `Guide`.`createdAt` DESC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`name`, `Institution`.`createdAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` WHERE `Institution`.`createdAt` >= '2026-04-30 21:54:56' ORDER BY `Institution`.`createdAt` DESC;
Executing (default): SELECT `id`, `name`, `phone`, `createdAt`, `form101Path`, `contractPath` FROM `Guides` AS `Guide` ORDER BY `Guide`.`id` DESC;
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` ORDER BY `Guide`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'pending' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'rejected' ORDER BY `HourReport`.`updatedAt` DESC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` WHERE `HourReport`.`createdAt` >= '2026-05-23 21:55:04' ORDER BY `HourReport`.`createdAt` DESC LIMIT 20;
Executing (default): SELECT `guideId` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` WHERE `Guide`.`createdAt` >= '2026-04-30 21:55:04' ORDER BY `Guide`.`createdAt` DESC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`name`, `Institution`.`createdAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` WHERE `Institution`.`createdAt` >= '2026-04-30 21:55:04' ORDER BY `Institution`.`createdAt` DESC;
Executing (default): SELECT count(*) AS `count` FROM `Guides` AS `Guide`;
Executing (default): SELECT count(*) AS `count` FROM `Cities` AS `City`;
Executing (default): SELECT count(*) AS `count` FROM `Institutions` AS `Institution`;
Executing (default): SELECT `startTime`, `endTime` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `id`, `username`, `password`, `createdAt`, `updatedAt` FROM `Users` AS `User` WHERE `User`.`username` = 'admin';
Executing (default): SELECT `id`, `username`, `password`, `createdAt`, `updatedAt` FROM `Users` AS `User` WHERE `User`.`username` = 'admin';
Executing (default): SELECT count(*) AS `count` FROM `Guides` AS `Guide`;
Executing (default): SELECT count(*) AS `count` FROM `Cities` AS `City`;
Executing (default): SELECT count(*) AS `count` FROM `Institutions` AS `Institution`;
Executing (default): SELECT `startTime`, `endTime` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-06-01' AND '2026-06-30';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` ORDER BY `Guide`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'pending' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'rejected' ORDER BY `HourReport`.`updatedAt` DESC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` WHERE `HourReport`.`createdAt` >= '2026-05-25 07:22:52' ORDER BY `HourReport`.`createdAt` DESC LIMIT 20;
Executing (default): SELECT `guideId` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-06-01' AND '2026-06-30';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` WHERE `Guide`.`createdAt` >= '2026-05-02 07:22:52' ORDER BY `Guide`.`createdAt` DESC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`name`, `Institution`.`createdAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` WHERE `Institution`.`createdAt` >= '2026-05-02 07:22:52' ORDER BY `Institution`.`createdAt` DESC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Guide`.`phone` AS `Guide.phone`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`date` BETWEEN '2026-06-01' AND '2026-06-30' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Guide`.`phone` AS `Guide.phone`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31' ORDER BY `HourReport`.`date` ASC, `HourReport`.`startTime` ASC;
Executing (default): SELECT `id`, `name`, `phone`, `loginToken`, `loginTokenExpiry` FROM `Guides` AS `Guide` ORDER BY `Guide`.`name` ASC;
Executing (default): SELECT `guideId` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-06-01' AND '2026-06-30';
Executing (default): SELECT `id`, `name`, `phone`, `loginToken`, `loginTokenExpiry` FROM `Guides` AS `Guide` ORDER BY `Guide`.`name` ASC;
Executing (default): SELECT `guideId` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-05-01' AND '2026-05-31';
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Guide`.`phone` AS `Guide.phone`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name`, `Institution->City`.`guideHourlyRates` AS `Institution.City.guideHourlyRates`, `Institution->City`.`guideKmRates` AS `Institution.City.guideKmRates`, `Institution->City`.`hourlyRate` AS `Institution.City.hourlyRate` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`date` BETWEEN '2026-06-01' AND '2026-06-30' AND `HourReport`.`status` = 'approved' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution`.`hourlyRates` AS `Institution.hourlyRates`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name`, `Institution->City`.`hourlyRate` AS `Institution.City.hourlyRate`, `Institution->City`.`billingEmail` AS `Institution.City.billingEmail`, `Institution->City`.`billingEmails` AS `Institution.City.billingEmails`, `Institution->City`.`contactName` AS `Institution.City.contactName` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`date` BETWEEN '2026-06-01' AND '2026-06-30' AND `HourReport`.`status` = 'approved' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT count(*) AS `count` FROM `Guides` AS `Guide`;
Executing (default): SELECT count(*) AS `count` FROM `Cities` AS `City`;
Executing (default): SELECT count(*) AS `count` FROM `Institutions` AS `Institution`;
Executing (default): SELECT `startTime`, `endTime` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-06-01' AND '2026-06-30';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` ORDER BY `Guide`.`name` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'pending' ORDER BY `HourReport`.`date` ASC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name`, `Institution`.`id` AS `Institution.id`, `Institution`.`name` AS `Institution.name`, `Institution->City`.`id` AS `Institution.City.id`, `Institution->City`.`name` AS `Institution.City.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` LEFT OUTER JOIN `Institutions` AS `Institution` ON `HourReport`.`institutionId` = `Institution`.`id` LEFT OUTER JOIN `Cities` AS `Institution->City` ON `Institution`.`cityId` = `Institution->City`.`id` WHERE `HourReport`.`status` = 'rejected' ORDER BY `HourReport`.`updatedAt` DESC;
Executing (default): SELECT `HourReport`.`id`, `HourReport`.`guideId`, `HourReport`.`institutionId`, `HourReport`.`date`, `HourReport`.`startTime`, `HourReport`.`endTime`, `HourReport`.`notes`, `HourReport`.`status`, `HourReport`.`rejectionReason`, `HourReport`.`kilometers`, `HourReport`.`createdAt`, `HourReport`.`updatedAt`, `Guide`.`id` AS `Guide.id`, `Guide`.`name` AS `Guide.name` FROM `HourReports` AS `HourReport` LEFT OUTER JOIN `Guides` AS `Guide` ON `HourReport`.`guideId` = `Guide`.`id` WHERE `HourReport`.`createdAt` >= '2026-05-25 07:23:26' ORDER BY `HourReport`.`createdAt` DESC LIMIT 20;
Executing (default): SELECT `guideId` FROM `HourReports` AS `HourReport` WHERE `HourReport`.`date` BETWEEN '2026-06-01' AND '2026-06-30';
Executing (default): SELECT `id`, `name`, `phone`, `createdAt` FROM `Guides` AS `Guide` WHERE `Guide`.`createdAt` >= '2026-05-02 07:23:26' ORDER BY `Guide`.`createdAt` DESC;
Executing (default): SELECT `Institution`.`id`, `Institution`.`name`, `Institution`.`createdAt`, `City`.`id` AS `City.id`, `City`.`name` AS `City.name` FROM `Institutions` AS `Institution` LEFT OUTER JOIN `Cities` AS `City` ON `Institution`.`cityId` = `City`.`id` WHERE `Institution`.`createdAt` >= '2026-05-02 07:23:26' ORDER BY `Institution`.`createdAt` DESC;
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'LessonPlans' AND TABLE_SCHEMA = 'amitneto_moria'
Executing (default): SHOW INDEX FROM `LessonPlans`
Executing (default): SELECT `id`, `title`, `link`, `fileType`, `description`, `createdAt`, `updatedAt` FROM `LessonPlans` AS `LessonPlan` ORDER BY `LessonPlan`.`createdAt` DESC;
[whatsapp] POST נכנס — payload: {"entry":[{"id":"2063947654539352","time":1780437630,"changes":[{"value":{"phone_number":"972533622232","event":"PHONE_NUMBER_REMOVED"},"field":"account_update"}]}],"object":"whatsapp_business_account"}
[whatsapp] אין הודעה ב-payload (status update או ping)
Error: Failed to find Server Action "60fcf4b146e76cdd26bac538691a0523afebd327". This request might be from an older or newer deployment.
Read more: https://nextjs.org/docs/messages/failed-to-find-server-action
    at ignore-listed frames