SELECT a.id,a.name as pname,a.price,a.member_id as userid,a.stock,c.company,b.property_1,b.property_2,b.property_3,b.property_4,b.property_5,b.property_6,b.property_7,b.property_8,b.property_6_float,b.property_6_price FROM mb_product a left join mb_defind_1 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 a.is_shelves=1  and b.property_2="54"  and LOCATE('100004',a.catid)=1  and a.name = 'GN-AL'  and (1  and ( c.company like '%df%' or a.brand like '%df%' or a.subhead like '%df%')) order by (CASE WHEN b.property_1 < 3 THEN 0 ELSE 1 END) DESC,(CASE WHEN a.name LIKE 'GN-AL' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'BTLY' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NG-A(BTLY)' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NG-A' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YD-NG/A' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'WDZAN-NG/A' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'WDZAN-BTLY' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'BTLE' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NGA-BTLY' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'BTLY-C' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'FBTLY' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-FBTLY' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-FWDZA-BTLY' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-FBBTRV' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'WDNZA-FBBTRY' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NTG-LA' THEN 3 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'GN-AL%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'BTLY%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NG-A(BTLY)%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NG-A%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'YD-NG/A%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'WDZAN-NG/A%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'WDZAN-BTLY%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'BTLE%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NGA-BTLY%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'BTLY-C%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'FBTLY%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-FBTLY%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-FWDZA-BTLY%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'N-FBBTRV%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'WDNZA-FBBTRY%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE 'NTG-LA%' THEN 2 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%GN-AL' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%BTLY' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NG-A(BTLY)' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NG-A' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%YD-NG/A' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%WDZAN-NG/A' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%WDZAN-BTLY' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%BTLE' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NGA-BTLY' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%BTLY-C' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%FBTLY' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%N-FBTLY' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%N-FWDZA-BTLY' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%N-FBBTRV' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%WDNZA-FBBTRY' THEN 1 ELSE 0 END) DESC,(CASE WHEN a.name LIKE '%NTG-LA' 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,30Query execution was interrupted