SELECT *,
(SELECT COUNT(products.product_id) FROM products LEFT OUTER JOIN brands ON products.brand_id = brands.brand_id
INNER JOIN products_to_categories ON products.product_id = products_to_categories.product_id
INNER JOIN categories ON products_to_categories.category_id = categories.category_id WHERE categories.category_id = '0' AND products.product_status = '1' ) AS count
FROM products
LEFT OUTER JOIN brands ON products.brand_id = brands.brand_id
INNER JOIN products_to_categories ON products.product_id = products_to_categories.product_id
INNER JOIN categories ON products_to_categories.category_id = categories.category_id
WHERE categories.category_id = '0' AND products.product_status = '1'
ORDER BY products.product_added
LIMIT 0, 12 Poplar Tree Garden Centre

0 Items £0.00

ViewCart

Pages

There are no items in this section yet. New items are added every day.


Pages