Unknown column 'locations.type_id' in 'on clause'
SELECT projrel.object_id, locations.id, locations.name1, loctyp.label, locord.priority FROM ws_objects_rel projrel, ws_objects_rel locrel, ws_objects locations, ws_objects_types loctyp LEFT JOIN ws_objects_types_order locord ON locord.main_obj_type IN (7,8) AND locord.rel_obj_type = locations.type_id WHERE locrel.relnum = projrel.relnum AND locrel.object_id <> projrel.object_id AND locrel.publish_relation = '1' AND locations.id = locrel.object_id AND locations.type_id IN (11,6,4) AND locations.publish = '1' AND projrel.object_id IN (60459,60382) AND loctyp.id = locations.type_id ORDER BY projrel.object_id ASC, locord.priority ASC | |
