QUERY error
SELECT * FROM shop
LEFT JOIN shop_type ON shop.shop_type_cd=shop_type.shop_type_cd
WHERE (shop.act_flg = 1
AND shop.del_flg = 0
AND '2026-11-19 04:19:25' BETWEEN shop.start_time AND shop.end_time)
AND (( play_cd IN (1)))
ORDER BY
charge_flg=1 DESC,
charge_flg=2 DESC,
charge_flg=0 DESC,
girl.start_time DESC