Ardent Fireworks

Classification

SQL Error SELECT /* CategoryCounterQuery */ category.SLUG AS ASlug, COUNT(ccO.ID) AS Count FROM `category` CROSS JOIN (SELECT product.CLASS_KEY, product.ID, product.PROPERTY_SET_ID, product.NAME, product.SUMMARY, product.TAGLINE, product.DESCRIPTION, product.VISIBLE, product.FEATURED, product.POPULAR, product.DEFAULT_VARIANT_ID, product.DEFAULT_PRICE, product.PRODUCT_AVAILABLE, product.PRODUCT_IN_STOCK, product.PRODUCT_ON_OFFER, product.PER_VARIANT_IMAGES, product.BEST_PRICE, product.EXTRA_PRODUCT_INFO, product.ONE_PRICING, product.ONE_AVAILABILITY, product.ONE_DELIVERY, product.ONE_BUNDLE, product.ONE_STOCK, product.ONE_OPTION_SET, product.PROPORTIONAL_PRICING, product.PRODUCT_PROPORTIONAL_PRICING_ID, product.VARIANT_PRICING_ID, product.BUNDLE_POLICY_ID, product.META_DATA_ID, product.WISHES, product.LIKES, product.RATING, product.SLUG, product.LATITUDE, product.LONGITUDE, product.MAP_ICON, product.CREATED_AT, product.CREATED_BY, product.UPDATED_AT, product.UPDATED_BY, 1 AS Rank FROM `product` INNER JOIN `product_category` `cat_medium` ON (product.ID=cat_medium.PRODUCT_ID) INNER JOIN `product_category` `cat_roman_candles` ON (product.ID=cat_roman_candles.PRODUCT_ID) WHERE product.VISIBLE=:p1 AND cat_medium.CATEGORY_ID = 57 AND cat_roman_candles.CATEGORY_ID = 61 GROUP BY product.ID ORDER BY product.CREATED_AT DESC) AS foundObject INNER JOIN `product_category` `ccOC` ON (category.ID=ccOC.CATEGORY_ID) INNER JOIN `product` `ccO` ON (ccOC.PRODUCT_ID=ccO.ID) WHERE foundObject.ID = ccO.ID GROUP BY category.ID