70 select distinct wr_parent from g5_write_job where 1 = 1 and ( store_city_code = '1-2-371' or store_city_code like '1-2-371-%' or store_city_code like '1-2-371|%' or store_city_code like '%|1-2-371' or store_city_code like '%|1-2-371-%' or store_city_code like '%|1-2-371|%' ) 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
  • 06.12
  • 05.29
  • 11.03
  • 09.14
  • 09.07
  • 07.30
  • 07.26
  • 06.18
  • 06.14
  • 06.11
  • 03.24
  • 02.23
  • 02.23
  • 02.13
  • 08.14
  • 07.25
  • 05.18
  • 05.13
  • 04.13
  • 03.14
  • 02.14
  • 11.16
  • 11.16
  • 11.16
  • 10.01
  • 07.28
  • 07.15
  • 07.08
  • 06.03
  • 06.01