QUERY = select status,brand,shortdesc,cat_.*,dler_unit_price,msrp,pieces_carton,sale,closeout,prodimage1,smallicon from cat_ left join product on product.itemno=cat_.itemno left join prod_price on cat_.itemno=prod_price.itemno left join prod_images on cat_.itemno=prod_images.itemno where trim(cat_.itemno) != \'\' and cat_.itemno in (select itemno from product where status!=\'Inactive\' and status!=\'Turn off\' and status!=\'WIP\' and status!=\'New Concept\' and status!=\'N/A\' and status!=\'Close-out\') order by neworder ASC, cat_.itemno ASC