SELECT a.id FROM mb_product a left join mb_distribution_product p ON a.id=p.product_id left join  b on a.id=b.product_id left join mb_shop c on a.member_id=c.userid WHERE c.shop_statu=1 and a.status>0 and is_shelves=1   and LOCATE('100405',a.catid)=1  and (1  and (a.name like "%AC90%" or a.name like "%YJLHS%" or a.name like "%ZA-AC90(-40)%" or a.name like "%ZA-AC90%" or a.name like "%YJHLV8%" or a.name like "%YJXLHVK%" or a.name like "%YJGLHV8%" or a.name like "%YJGLHBV8%" or a.name like "%YJLHV60%" or a.name like "%ZAAC90%" or a.name like "%YJLHB8%" or a.name like "%AC90(-40)%" or a.name like "%YJGLH8%" or a.name like "%YJLHB90%" or a.name like "%YJLHV8%") ) order by (CASE WHEN b.property_1 < 3 THEN 0 ELSE 1 END) DESC,(CASE WHEN a.name LIKE 'AC90' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'ZA-AC90(-40)' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'ZA-AC90' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'ZAAC90' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'AC90(-40)' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YJLHS' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YJHLV8' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YJXLHVK' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YJGLHV8' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YJGLHBV8' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YJLHV60' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YJLHB8' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YJGLH8' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YJLHB90' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YJLHV8' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'AC90%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'ZA-AC90(-40)%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'ZA-AC90%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'ZAAC90%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'AC90(-40)%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YJLHS%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YJHLV8%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YJXLHVK%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YJGLHV8%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YJGLHBV8%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YJLHV60%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YJLHB8%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YJGLH8%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YJLHB90%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YJLHV8%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%AC90' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%ZA-AC90(-40)' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%ZA-AC90' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%ZAAC90' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%AC90(-40)' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%YJLHS' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%YJHLV8' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%YJXLHVK' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%YJGLHV8' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%YJGLHBV8' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%YJLHV60' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%YJLHB8' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%YJGLH8' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%YJLHB90' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%YJLHV8' THEN 1 ELSE 0 END) DESC, a.rank desc,(CASE WHEN (a.is_top=1 and a.is_rec=1) THEN 3 WHEN (a.is_top=1) THEN 2 WHEN (a.is_rec=1) THEN 1 ELSE 0 END) DESC, (CASE WHEN (a.price=0) THEN 1 ELSE 0 END) ASC,c.grade desc,b.property_6 desc,b.property_8 asc,a.uptime desc limit 0,1500Table 'mb.b' doesn't exist