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 (69658,69602,69612,69609,69610,69595,69362,69276,69367,69491,69267,69619,69618,69305,61507,69604,69350,28924,28963,64463,69613,69325,69623,69615,69289,69290,60850,60863,69282,69303,67287,69270,69272,69309,69324,69594,69291,69346,69274,69320,69363,69343,69627,69347,69299,69358,69364,69342,69330,69284,69339,69624,69651,69489,69308,29059,69368,60874,61487,69295,69319,69304,69279,69600,61347,69334,69487,62801,69340,60870,28966,69344,37341,13402,69361,14888,69268,69310,69493,69329,69294,69629,69605,69603) AND loctyp.id = locations.type_id ORDER BY projrel.object_id ASC, locord.priority ASC | |
