#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 near_office_metro.metroid IN ('195') AND min_go <= 10 AND min_go <= 70AND near_office_metro.metroid = 171 AND near_office_metro.min_go <= 70 AND district_id IN (85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100) AND area >= '25' AND area <= '30-m2' AND district_id IN (113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125) AND building_class = 'B' AND near_office_metro.metroid = 24 AND near_office_metro.min_go <= 70 AND orgs.cityid = '1') called at [/var/www/code/core/func.php:1317]
#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 near_office_metro.metroid IN ('195') AND min_go <= 10 AND min_go <= 70AND near_office_metro.metroid = 171 AND near_office_metro.min_go <= 70 AND district_id IN (85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100) AND area >= '25' AND area <= '30-m2' AND district_id IN (113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125) AND building_class = 'B' AND near_office_metro.metroid = 24 AND near_office_metro.min_go <= 70 AND orgs.cityid = '1') called at [/var/www/code/office/list-officy.php:645]
#2 require(/var/www/code/office/list-officy.php) called at [/var/www/code/office/office.php:22]
#3 require_once(/var/www/code/office/office.php) called at [/var/www/index.php:153]
Sorry, there is a fatal error!
Error reference time: 2024/11/24, 04:43:01