This website requires cookies to provide all of its features. For more information on what data is contained in the cookies, please see our Privacy Policy page. To accept cookies from this site, please click the Allow button below

SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status`
FROM `cataloginventory_stock_item` AS `main_table`
INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id
= cp_table.entity_id
LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON
main_table.product_id=status_table.product_id AND
main_table.stock_id=status_table.stock_id AND status_table.website_id='1'
WHERE