SELECT pc.page_id as p_id FROM page_category pc WHERE pc.category_id=2
#2006 - MySQL server has gone away
select c.category_id, c.category_up_id, c.clickable, ct.title, ct.description, ct.url, ct.h1, ct.h2 from category c left outer join category_trans ct on c.category_id=ct.category_id and ct.lang_id=4 where c.active=1 and c.category_up_id=1 order by c.order_by asc
Coming soon...