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