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:38:41' BETWEEN shop.start_time AND shop.end_time)
AND (( other_cds LIKE '%,6,%'))
ORDER BY
charge_flg=1 DESC,
charge_flg=2 DESC,
charge_flg=0 DESC,
girl.start_time DESC