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:24' BETWEEN shop.start_time AND shop.end_time)
AND (( s_area_cds LIKE '%,3,%' OR s_area_cds LIKE '%,4,%' OR s_area_cds LIKE '%,5,%' OR s_area_cds LIKE '%,6,%' OR s_area_cds LIKE '%,7,%' OR s_area_cds LIKE '%,15,%'))
ORDER BY
charge_flg=1 DESC,
charge_flg=2 DESC,
charge_flg=0 DESC,
girl.start_time DESC