A Specially Tailored Talk For Agile Northants

button-icon-arrow-right
button-icon-arrow-left
Query Error in 'CPSetSelection::execute' method in '/var/www/vhosts/www.explore-group.com/httpdocs/class.cp_sets.php' on line 8636, 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 = -1999 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 = '601' LEFT OUTER JOIN cp_data AS table1 ON table1.cpda_meta_id = mainTable.cpda_id AND table1.cpda_meta_key = '602' LEFT OUTER JOIN cp_data AS table2 ON table2.cpda_meta_id = mainTable.cpda_id AND table2.cpda_meta_key = '24027' WHERE mainTable.cpda_meta_id = 590 AND mainTable.cpda_meta_key = 'set_element_stub' AND mainTable.cpda_active = 1 AND table0.cpda_meta_val  >= 1711670400 AND table1.cpda_meta_val  =  AND (table2.cpda_meta_val = -1999 OR table2.cpda_meta_val  IS NULL) ORDER BY table0.cpda_meta_val, mainTable.cpda_seq, mainTable.cpda_id LIMIT 0, 3