Ошибка
INSERT INTO `products_filters`(`specificationc_id`,`specification_id`,`parent`,`value_id`,`results`,`type`) SELECT s.specificationc_id,s.specification_id AS specification_id,c.content AS parent,s.specification_id AS value_id,0,1 AS type FROM (SELECT DISTINCT specification_id,specificationc_id FROM products_filters WHERE specification_id>0) AS s LEFT JOIN pa_content AS c ON(c.id=s.specification_id) ORDER BY c.sort,c.namefull /* api/dpage/poisk.php(415) ssql_add_spec_answer() */