Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN (

            SELECT `article_subtypes`.`subtype_id` 

            FROM  art' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 684]

Query: SELECT COUNT(*) AS `count` FROM `products` AS `Product` INNER JOIN articles AS `Article` ON (`Article`.`product_id` = `Product`.`id`) WHERE `Product`.`isPublished` = 1 AND IN ( SELECT `article_subtypes`.`subtype_id` FROM article_subtypes WHERE `article_subtypes`.`article_id` = `Article`.`id` )

Query: SELECT `Product`.`id`, `Article`.`isCatalog`, `Article`.`reference`, `Article`.`name_es`, `Article`.`name_en`, ( SELECT SUM(Article.pricesale) FROM articles AS Article WHERE Article.product_id = Product.id GROUP BY Article.product_id ) AS price, ( SELECT images.name FROM images, articles, products WHERE products.id = Product.id AND images.article_id = articles.id AND products.id = articles.product_id ORDER BY images.order ASC LIMIT 0,1 ) AS image FROM `products` AS `Product` INNER JOIN articles AS `Article` ON (`Article`.`product_id` = `Product`.`id`) WHERE `Product`.`isPublished` = 1 AND IN ( SELECT `article_subtypes`.`subtype_id` FROM article_subtypes WHERE `article_subtypes`.`article_id` = `Article`.`id` ) ORDER BY `Product`.`order` DESC LIMIT 20

Agua Bendita | Colecciones | Trajes de baño | Accesorios