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 60,20