DB接続失敗3(query). drug_effect_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 ') AND
drug_effect_tbl.effect_theme_id is NULL
' at line 20||SELECT
item_tbl.item_id
FROM
item_tbl,
effect_tbl,
drug_tbl,
item_type_tbl,
drug_effect_tbl,
piece_tbl,
theme_tbl
WHERE
drug_tbl.drug_id = item_tbl.drug_id AND
item_tbl.drug_id = drug_effect_tbl.drug_id AND
drug_effect_tbl.effect_id = effect_tbl.effect_id AND
piece_tbl.item_id = item_tbl.item_id AND
piece_tbl.piece_total_count > 0 AND
(
(
theme_tbl.theme_id = effect_tbl.theme_id AND
effect_tbl.theme_id in () AND
drug_effect_tbl.effect_theme_id is NULL
)
||
(
drug_effect_tbl.effect_theme_id is NOT NULL AND
theme_tbl.theme_id = drug_effect_tbl.effect_theme_id AND
drug_effect_tbl.effect_theme_id in ()
)
) AND
(
theme_tbl.recommend_item1 = item_tbl.item_id || theme_tbl.recommend_item2 = item_tbl.item_id
) GROUP BY
item_tbl.item_id
ORDER BY
piece_tbl.piece_amount,
theme_tbl.recommend_item1,
theme_tbl.recommend_item2