Problema consulta

[gnzsoloyo]

Código MySQL:

SELECT   t_products.*, t_categories.*, t_products_filters.*
    FROM t_products 
         INNER JOIN t_categories ON t_products.CATEGORY_ID = t_categories.CATEGORY_ID
         INNER JOIN t_products_filters ON t_products.PRODUCT_ID = t_products_filters.PRODUCT_ID
   WHERE t_products.PRODUCT_options_erased = 0
     AND t_categories.CATEGORY_area = 'particular'
     AND t_products_filters.PRODUCTFILTER_options IN(95, 96)
GROUP BY t_products.PRODUCT_ID
ORDER BY t_products.PRODUCT_ID DESC