#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 (23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39) AND district_id IN (101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112) AND area >= '350' AND area <= '400-m2' AND building_class = 'B+' AND number_seats >= '100' AND number_seats <= '150' AND near_office_metro.metroid IN (171, 172, 195, 239, 358) AND near_office_metro.min_go <= 30 AND near_office_metro.metroid = 201 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 (57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72) AND district_id IN (23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39) AND district_id IN (101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112) AND area >= '350' AND area <= '400-m2' AND building_class = 'B+' AND number_seats >= '100' AND number_seats <= '150' AND near_office_metro.metroid IN (171, 172, 195, 239, 358) AND near_office_metro.min_go <= 30 AND near_office_metro.metroid = 201 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, 17:45:22