1054: Unknown column 'p.1' in 'order clause' in SELECT COUNT(DISTINCT p.page_id) as count FROM pages p LEFT JOIN pages_languages pl ON p.page_id = pl.page_id LEFT JOIN pages_fields pf ON p.page_id = pf.page_id LEFT JOIN users u ON p.page_author = u.user_id LEFT JOIN users_data ud ON u.user_id = ud.user_id LEFT JOIN fields f ON pf.field_id = f.field_id LEFT JOIN fields_languages fl ON (pf.field_id = fl.field_id) LEFT JOIN fields_values_to_field fvtf ON f.field_id = fvtf.field_id LEFT JOIN pages_fields_values pfv ON pfv.page_id = p.page_id LEFT JOIN fields_values_languages fvl ON fvtf.field_value_id = fvl.field_value_id LEFT JOIN pages_tags pt ON p.page_id = pt.page_id LEFT JOIN pages_relations pr ON p.page_id = pr.relation_page_id WHERE ud.deleted = 0 AND pl.language_id='14' AND p.site_id='1' AND p.page_id IN ("914","915","916","917","918","919","922","923","924") AND p.page_status IN (1) ORDER BY p.1
Class: DB. Stop.