が症状の時のお薬
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