A Database Error Occurred

Error Number: 1064

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 ') ORDER BY sets.`id` DESC LIMIT 4' at line 7

SELECT sets.spetial,sets.super_price,sets.flag, sets.id AS set_id, groups.id AS group_id,groups.main_cat,groups.new, cont.name, cont.playtime,cont.quantity,sc.tb FROM (`sets`) LEFT JOIN `groups` ON `sets`.`group_id` = `groups`.`id` LEFT JOIN `cont` ON `cont`.`sets_id` = `sets`.`id` LEFT JOIN `sets_sc` ON `sets_sc`.`sets_id` = `sets`.`id` LEFT JOIN `sc` ON `sets_sc`.`sc_id` = `sc`.`id` WHERE (`sc`.`tb_flag` = 'YES' AND `cont`.`flag` = 'MAIN') and sets.id in (SELECT sets.id FROM sets JOIN groups ON sets.group_id=groups.id JOIN group_mod ON groups.id=group_mod.group_id JOIN models ON group_mod.mod_id=models.id )) ORDER BY sets.`id` DESC LIMIT 4

Filename: /home/admin/web/hqcont.com/public_html/models/main_model.php

Line Number: 77