#0 haltOnError(pdo, SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'near_office_metro' ----- Query: SELECT office_tariffs.*, orgs.code as orgCode, orgs.ttl as orgName, orgs.logoid as logoId
FROM office_tariffs
left join near_office_metro on near_office_metro.office_tariff_id = office_tariffs.idleft join near_office_metro on near_office_metro.office_tariff_id = office_tariffs.id
left join orgs on orgs.id = office_tariffs.org_id
WHERE office_tariffs.status = 'on' AND district_id IN (13, 14, 15, 16, 17, 18, 19, 20, 21, 22) AND near_office_metro.metroid = 18 AND near_office_metro.min_go <= 70 AND area >= '35' AND area <= '40-m2' AND number_seats >= '20' AND number_seats <= '50' AND district_id IN (139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150) AND near_office_metro.metroid IN (171, 172, 195, 239, 358) AND near_office_metro.min_go <= 30 AND area >= '40' AND area <= '50-m2' AND near_office_metro.metroid = 141 AND near_office_metro.min_go <= 70 AND orgs.cityid = '1') called at [/var/www/code/core/func.php:1316]
#1 db(SELECT office_tariffs.*, orgs.code as orgCode, orgs.ttl as orgName, orgs.logoid as logoId
FROM office_tariffs
left join near_office_metro on near_office_metro.office_tariff_id = office_tariffs.idleft join near_office_metro on near_office_metro.office_tariff_id = office_tariffs.id
left join orgs on orgs.id = office_tariffs.org_id
WHERE office_tariffs.status = 'on' AND district_id IN (13, 14, 15, 16, 17, 18, 19, 20, 21, 22) AND near_office_metro.metroid = 18 AND near_office_metro.min_go <= 70 AND area >= '35' AND area <= '40-m2' AND number_seats >= '20' AND number_seats <= '50' AND district_id IN (139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150) AND near_office_metro.metroid IN (171, 172, 195, 239, 358) AND near_office_metro.min_go <= 30 AND area >= '40' AND area <= '50-m2' AND near_office_metro.metroid = 141 AND near_office_metro.min_go <= 70 AND orgs.cityid = '1') called at [/var/www/code/office/list-officy.php:644]
#2 require(/var/www/code/office/list-officy.php) called at [/var/www/code/office/office.php:21]
#3 require_once(/var/www/code/office/office.php) called at [/var/www/index.php:143]
Sorry, there is a fatal error!
Error reference time: 2024/11/10, 23:04:05