select iItemID, iItemBrandID, vName, vPic, fRate, fMRP, cStock, iQOH from os_item where cStatus="A" and LCASE(vName) LIKE "%cornitos%" or iItemCatID IN (select iItemCatID from os_cat where cStatus="A" and LCASE(vName) LIKE "%cornitos%") or iItemBrandID IN (select iItemBrandID from os_brand where cStatus="A" and LCASE(vName) LIKE "%cornitos%") and iQOH>0 order by iItemID asc