SELECT distinct p.id, p.code, p.name, p.uri, p.details, p.collections_id, p.notes, p.auxtext1, p.auxtext4, p.date_available, p.retail_price, p.stock, p.stockmin FROM products p INNER JOIN categories c on p.categories_id=c.id LEFT JOIN barcodes b ON p.id=b.products_id LEFT JOIN subcategories s ON p.subcategories_id = s.id WHERE p.dealers_id = :dealers_id AND p.categories_id = :categories_id AND p.subcategories_id = :subcategories_id AND s.status=1 AND p.status = 1 AND c.status = 1 AND (s.status = 1 OR ISNULL(s.status)) AND (p.code LIKE :search OR p.name LIKE :search OR p.details LIKE :search OR b.barcode = :searchex) ORDER BY c.vieworder, c.code, s.vieworder, s.code, p.vieworder, p.code LIMIT 0,60
Array
(
[:dealers_id] => 2
[:categories_id] => 33
[:subcategories_id] => 441
[:search] => %stella%
[:searchex] => stella
)
