Paul
Boyle

Query Error in 'CPSetSelection::execute' method in '/mnt/ccd-vhost-data/www/vhosts/connacht.reskin.ccd07.ccd.systems/httpdocs/class.cp_sets.php' on line 8741, You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND (table2.cpda_meta_val = 158478 OR table2.cpda_meta_val IS NULL) ORDER BY ...' at line 1

Full query: SELECT mainTable.cpda_id FROM cp_data AS mainTable LEFT OUTER JOIN cp_data AS table0 ON table0.cpda_meta_id = mainTable.cpda_id AND table0.cpda_meta_key = '59789' LEFT OUTER JOIN cp_data AS table1 ON table1.cpda_meta_id = mainTable.cpda_id AND table1.cpda_meta_key = '59774' LEFT OUTER JOIN cp_data AS table2 ON table2.cpda_meta_id = mainTable.cpda_id AND table2.cpda_meta_key = '158412' LEFT OUTER JOIN cp_data AS table3 ON table3.cpda_meta_id = mainTable.cpda_id AND table3.cpda_meta_key = '59733' WHERE mainTable.cpda_meta_id = 59722 AND mainTable.cpda_meta_key = 'set_element_stub' AND mainTable.cpda_active = 1 AND table0.cpda_meta_val = 59790 AND table1.cpda_meta_val =  AND (table2.cpda_meta_val = 158478 OR table2.cpda_meta_val IS NULL) ORDER BY table3.cpda_meta_val DESC, mainTable.cpda_seq, mainTable.cpda_id