select * from categories where sub_id = '38'

Access denied for user 'root'@'localhost' (using password: NO) SELECT items.id, items.name, items_brands.brand_id, items_categories.cat_id FROM items LEFT JOIN items_brands ON items.id=items_brands.item_id LEFT JOIN brands ON items_brands.brand_id=brands.id LEFT JOIN item_ages ON items.id=item_ages.item_id LEFT JOIN ages ON item_ages.age_id=ages.id LEFT JOIN styles ON items.style_id=styles.id LEFT JOIN sexes ON items.sex=sexes.id LEFT JOIN items_categories ON items.id=items_categories.item_id LEFT JOIN categories ON items_categories.cat_id=categories.id WHERE items.id>0 AND items.stock>0 AND items_brands.brand_id='114' AND (items.sex='m' OR items.sex='' OR items.sex='u') AND (items_categories.cat_id='38') and items.hidden = '0' GROUP BY items.id ORDER BY items_brands.position ASC, items.id DESC

Access denied for user 'root'@'localhost' (using password: NO) SELECT items.id, items.name, items_brands.brand_id, items_categories.cat_id FROM items LEFT JOIN items_brands ON items.id=items_brands.item_id LEFT JOIN brands ON items_brands.brand_id=brands.id LEFT JOIN item_ages ON items.id=item_ages.item_id LEFT JOIN ages ON item_ages.age_id=ages.id LEFT JOIN styles ON items.style_id=styles.id LEFT JOIN sexes ON items.sex=sexes.id LEFT JOIN items_categories ON items.id=items_categories.item_id LEFT JOIN categories ON items_categories.cat_id=categories.id WHERE items.id>0 AND items.stock>0 AND items_brands.brand_id='114' AND (items.sex='m' OR items.sex='' OR items.sex='u') AND (items_categories.cat_id='38') and items.hidden = '0' GROUP BY items.id ORDER BY items_brands.position ASC, items.id DESC LIMIT 0,15

Access denied for user 'root'@'localhost' (using password: NO)

There are currently no products.