Home Page

SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `at_lofmprivate`.`value` AS `lofmprivate`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store2` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.category_id=52 AND cat_index.is_parent=1 LEFT JOIN `catalog_product_entity_int` AS `at_lofmprivate` ON (`at_lofmprivate`.`entity_id` = `e`.`entity_id`) AND (`at_lofmprivate`.`attribute_id` = '205') AND (`at_lofmprivate`.`store_id` = 0) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE ((at_lofmprivate.value IS NULL) OR (at_lofmprivate.value = 0)) AND (stock_status_index.stock_status = 1) ORDER BY `cat_index`.`position` ASC