SELECT ccode, compatible, screenprotector FROM products where compatible like '%Sam_OmniaIIi920%' and Doml=1 and mainproduct<>'No' and twin=0 and cname like '%Beyza%' order by (stockquantity + stockquantityHK) desc;SELECT ccode, compatible, screenprotector FROM products where compatible like '%Sam_OmniaIIi920%' and Doml=1 and mainproduct<>'No' and twin=0 and cname like '%BW %' order by (stockquantity + stockquantityHK) desc;SELECT ccode, compatible, screenprotector FROM products where compatible like '%Sam_OmniaIIi920%' and Doml=1 and mainproduct<>'No' and twin=0 and cname like '%Bstripe%' order by (stockquantity + stockquantityHK) desc;SELECT ccode, compatible, screenprotector FROM products where compatible like '%Sam_OmniaIIi920%' and Doml=1 and mainproduct<>'No' and twin=0 and cname like '%case%' order by (stockquantity + stockquantityHK) desc;SELECT ccode, compatible, screenprotector FROM products where compatible like '%Sam_OmniaIIi920%' and Doml=1 and mainproduct<>'No' and twin=0 and cname like '%screen protector%' order by (stockquantity + stockquantityHK) desc;SELECT ccode, compatible, screenprotector FROM products where compatible like '%Sam_OmniaIIi920%' and Doml=1 and mainproduct<>'No' and twin=0 and cname like '%cable%' order by (stockquantity + stockquantityHK) desc;SELECT ccode, compatible, screenprotector FROM products where compatible like '%Sam_OmniaIIi920%' and Doml=1 and mainproduct<>'No' and twin=0 and cname like '%%' order by (stockquantity + stockquantityHK) desc;