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('100203',a.catid)=1  and a.name = 'N-AVP'  and (1  and ( c.company like '%YFD%' or a.brand like '%YFD%' or a.subhead like '%YFD%')) order by (CASE WHEN b.property_1 < 3 THEN 0 ELSE 1 END) DESC,(CASE WHEN a.name LIKE 'N-AVP' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 红' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 黄' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 蓝' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 绿' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 黑' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 双' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 白' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 棕' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 灰' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 橙' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 紫' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 红' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 黄' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 蓝' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 绿' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 黑' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 双' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 白' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 棕' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 灰' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 橙' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 紫' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 红' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 黄' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 蓝' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 绿' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 黑' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 双' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 白' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 棕' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 灰' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 橙' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 紫' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 红' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 黄' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 蓝' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 绿' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 黑' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 双' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 白' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 棕' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 灰' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 橙' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 紫' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 红%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 黄%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 蓝%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 绿%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 黑%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 双%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 白%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 棕%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 灰%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 橙%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-AVP 紫%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 红%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 黄%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 蓝%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 绿%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 黑%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 双%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 白%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 棕%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 灰%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 橙%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NH-AVP 紫%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 红%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 黄%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 蓝%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 绿%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 黑%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 双%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 白%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 棕%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 灰%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 橙%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NHB-AVP 紫%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 红%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 黄%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 蓝%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 绿%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 黑%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 双%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 白%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 棕%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 灰%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 橙%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NB-AVP 紫%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%N-AVP' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%N-AVP 红' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%N-AVP 黄' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%N-AVP 蓝' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%N-AVP 绿' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%N-AVP 黑' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%N-AVP 双' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%N-AVP 白' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%N-AVP 棕' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%N-AVP 灰' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%N-AVP 橙' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%N-AVP 紫' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NH-AVP' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NHB-AVP' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NB-AVP' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NH-AVP 红' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NH-AVP 黄' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NH-AVP 蓝' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NH-AVP 绿' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NH-AVP 黑' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NH-AVP 双' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NH-AVP 白' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NH-AVP 棕' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NH-AVP 灰' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NH-AVP 橙' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NH-AVP 紫' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NHB-AVP 红' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NHB-AVP 黄' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NHB-AVP 蓝' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NHB-AVP 绿' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NHB-AVP 黑' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NHB-AVP 双' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NHB-AVP 白' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NHB-AVP 棕' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NHB-AVP 灰' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NHB-AVP 橙' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NHB-AVP 紫' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NB-AVP 红' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NB-AVP 黄' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NB-AVP 蓝' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NB-AVP 绿' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NB-AVP 黑' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NB-AVP 双' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NB-AVP 白' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NB-AVP 棕' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NB-AVP 灰' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NB-AVP 橙' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NB-AVP 紫' 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