ON THE MOVE

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 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)) 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] => 444 )