la parte que me da error esta en negrita
Código:
Gracias de antemano. $extra_fields_query = tep_db_query("SELECT * FROM " . TABLE_PRODUCTS_EXTRA_FIELDS . " pef WHERE category_id like '%" . $current_category_id .",%' OR category_id=". $current_category_id ." OR category_id='all' OR pef.category_id=(SELECT c.parent_id FROM " . TABLE_CATEGORIES . " as c WHERE c.categories_id =".$current_category_id .") OR pef.category_id like'% (SELECT c.parent_id FROM " . TABLE_CATEGORIES . " as c WHERE c.categories_id =".$current_category_id .")%' ORDER BY products_extra_fields_order");