が症状の時のお薬

DB接続失敗3(query). item_tbl SQLSTATE[42000]: Syntax error or access violation: 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 ') group by item_tbl.item_id ' at line 22|| SELECT item_tbl.item_id FROM item_tbl INNER JOIN drug_tbl ON drug_tbl.drug_id = item_tbl.drug_id INNER JOIN drug_effect_tbl ON drug_tbl.drug_id = drug_effect_tbl.drug_id INNER JOIN effect_tbl ON drug_effect_tbl.effect_id = effect_tbl.effect_id LEFT JOIN piece_tbl ON item_tbl.item_pict_piece_id = piece_tbl.piece_id WHERE item_tbl.item_id IS NOT NULL AND (piece_spot_search_name not LIKE 'LINE限定セール' OR piece_spot_search_name is NULL ) AND piece_tbl.piece_id = item_tbl.item_pict_piece_id AND piece_tbl.piece_total_count > 0 AND effect_tbl.effect_id in () group by item_tbl.item_id order by item_tbl.item_recommend_weight DESC, item_tbl.access_cnt DESC, item_tbl.item_week_buy_count DESC, item_tbl.item_id DESC