#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 (57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72) AND district_id IN (73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84) AND area >= '50' AND area <= '60-m2' AND district_id IN (134, 135, 136, 137, 138) AND near_office_metro.metroid = 168 AND near_office_metro.min_go <= 70 AND district_id IN (40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56) AND near_office_metro.metroid = 108 AND near_office_metro.min_go <= 70 AND orgs.cityid = '1') called at [/var/www/code/core/func.php:1314]
#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 (57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72) AND district_id IN (73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84) AND area >= '50' AND area <= '60-m2' AND district_id IN (134, 135, 136, 137, 138) AND near_office_metro.metroid = 168 AND near_office_metro.min_go <= 70 AND district_id IN (40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56) AND near_office_metro.metroid = 108 AND near_office_metro.min_go <= 70 AND orgs.cityid = '1') called at [/var/www/code/office/list-officy.php:454]
#2 require(/var/www/code/office/list-officy.php) called at [/var/www/code/office/office.php:20]
#3 require_once(/var/www/code/office/office.php) called at [/var/www/index.php:136]
Sorry, there is a fatal error!
Error reference time: 2024/09/20, 11:21:40