Symphony Fatal Database Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND t3.relation_id = '' ORDER BY id asc LIMIT 90 OFFSET 0' at line 1
An error occurred while attempting to execute the following query
-
SELECT SQL_CACHE s5.entry_id as id, s5.value as title, s5.handle as handle, s11.handle as article, s7.value as price, s20.value as new, s10.value as special, s8.value as oldprice, s35.value as description, s64.value as brand, s64.handle as brand_handle, s113.value as stock FROM sym_entries_data_5 s5 LEFT JOIN sym_entries_data_11 s11 USING(entry_id) LEFT JOIN sym_entries_data_7 s7 USING(entry_id) LEFT JOIN sym_entries_data_20 s20 USING(entry_id) LEFT JOIN sym_entries_data_10 s10 USING(entry_id) LEFT JOIN sym_entries_data_8 s8 USING (entry_id) LEFT JOIN sym_entries_data_35 s35 USING (entry_id) LEFT JOIN sym_entries_data_64 s64 USING (entry_id) LEFT JOIN sym_entries_data_113 s113 USING (entry_id) LEFT JOIN sym_entries_data_9 t9 USING(entry_id) LEFT JOIN sym_entries_data_113 t113 USING(entry_id) LEFT JOIN sym_entries_data_7 t7 USING(entry_id) LEFT JOIN sym_entries_data_3 t3 USING(entry_id) WHERE t9.value = 'yes' AND t113.value = 'no' AND t7.value <= 9000/ AND t3.relation_id = '' ORDER BY id asc LIMIT 90 OFFSET 0