select
c.id as c_id, c.description as c_desc,
c1.id as c1_id, c1.description as c1_desc,
c2.id as c2_id, c2.description as c2_desc
from category c
inner join category c1 on c1.id = c.parent_id and c1.is_live = 1 and c1.is_brand = 0
left join category c2 on c2.id = c1.parent_id and c2.is_live = 1 and c2.is_brand = 0
inner join product_category pc on c.id = pc.category_id
inner join product p on p.id = pc.product_id and p.id =
where c.is_live = 1 and c.is_brand = 0
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'where c.is_live = 1 and c.is_brand = 0' at line 10
Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in /home/thenaturalstore/public_html/products.php on line 82 The Natural Store – Ethical Fashion - Organic Baby - Fairtrade - Organic Cotton Clothing
We are sorry for any inconvenience caused but we are unable to send any orders out from Saturday, 27th July to Tuesday, 13th August.
We will send out any orders placed online during this time from Wednesday, 14th August onwards.
