SELECT `e`.`entity_id`,
matrix_cron.sort_order as custom_sort,
`e`.`type_id`,
`e`.`is_kids_product`,
`e`.`name`,
`e`.`sku`,
`e`.`price`,
`e`.`special_price`,
`e`.`special_from_date`,
`e`.`special_to_date`,
`e`.`manufacturer_value`,
`e`.`small_image`,
`e`.`news_from_date`,
`e`.`news_to_date`,
`e`.`url_path`,
`e`.`default_sort_value`,
`e`.`luxe`,
`e`.`luxe_value`,
`e`.`stock_status`,
`e`.`discount_percent`
FROM `darveyscatalog_product_flat_1` AS `e`
INNER JOIN `darveyscatalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id
INNER JOIN `darveyscatalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id INNER JOIN `darveysvss_matrix_cron_test` AS `matrix_cron` ON matrix_cron.product_id=e.entity_id WHERE 1
AND cat_index.store_id=1
AND cat_index.visibility IN(2,4)
AND cat_index.category_id = '835'
AND price_index.website_id = '1'
AND price_index.customer_group_id = '1'
AND matrix_cron.is_collection = '0' And matrix_cron.category_id = 835 group by e.entity_id ORDER BY custom_sort ASC limit 48, 48
There are no products matching the selection.
FILTERED BY
Designer
Type
Size
Discount
Season
Color
Price