Location

SQL Error SELECT /* listProperties Location */ product_config.CLASS_KEY, product_config.ID, product_config.PRODUCT_ID, product_config.PRODUCT_VARIANT_ID, product_config.NAME_SLUG, product_config.USE_IN_SLUG, product_config.SLUG, product_config.NAME, product_config.TYPE, product_config.NEW_TYPE, product_config.VALUE, product_config.UNITS, product_config.IS_DEFAULT, product_config.PRICE, product_config.INT_VALUE, product_config.FLOAT_VALUE, product_config.BOOLEAN_VALUE, product_config.DATE_VALUE, product_config.TIME_VALUE, product_config.DATETIME_VALUE, product_config.TEXT_VALUE, product_config.CREATED_AT, product_config.CREATED_BY, product_config.UPDATED_AT, product_config.UPDATED_BY, COUNT(DISTINCT product_config.ID) AS Count FROM `product_config`, `product`, (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_cultivation` ON (product.ID=cat_cultivation.PRODUCT_ID) INNER JOIN `product_category` `cat_56` ON (product.ID=cat_56.PRODUCT_ID) WHERE product.VISIBLE=:p3 AND cat_cultivation.CATEGORY_ID = 61 AND cat_56.CATEGORY_ID = 56 GROUP BY product.ID ORDER BY product.CREATED_AT DESC) AS foundProduct WHERE product_config.NAME=:p1 AND foundProduct.ID = product_config.PRODUCT_ID AND product_config.CLASS_KEY=:p2 GROUP BY product_config.VALUE ORDER BY product_config.VALUE ASC