sysk

uh... You want all products/categories from store "name.co.uk" ??

Then you will need to use IN()

[...]
AND p2c.categories_id IN(
SELECT cs.categories_id FROM categories_stores cs WHERE cs.categories_storename = 'name.co.uk'
)
[...]

__________________
icq: 612510168 / email: [email protected] / php ninja 4 hire