QUERY error
SELECT
* ,
girl.play_option_cds AS girl_play_option_cds,
shop.play_option_cds AS shop_play_option_cds
FROM girl
LEFT JOIN shop ON girl.shop_cd=shop.shop_cd
WHERE (girl.act_flg = 1
AND girl.del_flg = 0
AND '2026-11-19 04:19:17' BETWEEN girl.start_time AND girl.end_time)
AND (shop.act_flg = 1
AND shop.del_flg = 0
AND '2026-11-19 04:19:17' BETWEEN shop.start_time AND shop.end_time)
AND (
shop.charge_flg = '1' OR shop.charge_flg = '2'
)
ORDER BY
charge_flg=1 DESC,
charge_flg=2 DESC,
charge_flg=0 DESC
,
start_time DESC
LIMIT 40,20