SELECT id, product_name, price_retail, price_list, price_map, part_number, image_url, variant_name FROM product_cat WHERE status = 1 AND (manufacturer = 'No Matches Found') AND (categories LIKE '%Apparel Patches & Decals%') and status='1' LIMIT 0,15