32 select distinct wr_parent from g5_write_job where 1 = 1 and ( store_city_code = '1-2-348' or
store_city_code like '1-2-348-%' or
store_city_code like '1-2-348|%' or
store_city_code like '%|1-2-348' or
store_city_code like '%|1-2-348-%' or
store_city_code like '%|1-2-348|%'
) and goods_status_admin = 1 and goods_status = 1 and (wr_num between -4125 and (-4125 + 1000000)) order by CASE WHEN goods_date > now() THEN 0 else 1 end asc, result_date desc limit 30, 30