Database error: Invalid SQL: SELECT DISTINCT p.property_id, pt.property_title, pt.property_name, pt.property_prefix, pt.property_suffix, pt.type, pdv.value FROM abbeyroadcable_ru_rus_catalog_properties p, abbeyroadcable_ru_rus_catalog_properties_table pt LEFT JOIN abbeyroadcable_ru_rus_catalog_properties_def_values pdv ON p.property_id = pdv.property_id WHERE p.search = 1 AND p.property_id = pt.id ORDER BY p.property_id, pdv.value
MySQL Error: 1054 (Unknown column 'p.property_id' in 'on clause')
Session halted.