I have theis query
SELECT item.name, item_category.item
FROM category, item_category, item
WHERE (
item_category.category =12175
)
AND (
category.number =12175
)
AND item_category.item = item.number
ORDER BY item.name
LIMIT 0 , 30
It works like I like, but I also want to do another query where i would like to list everything like above, but only the one which also have item_category.category = 12177.
And I cant manage to think out how that query would be.
