Hi there,

Hoping someone can help me out converting a query so that it works in MySQL 3.23 - it includes a sub select so I believe that's what the problem is.

Code:
SELECT * 
FROM products_extra_fields pef
WHERE category_id LIKE '% 3,%'
OR category_id =3
OR category_id = 'all'
OR pef.category_id = ( 
SELECT c.parent_id
FROM categories AS c
WHERE c.categories_id =3 ) 
ORDER BY products_extra_fields_order
Is it a case of breaking it up in to two seperate queries?

Any help much appreciated.

Cheers,

DM