This website or third-party tools used by this site use cookies that are necessary for its functioning and are useful for the purposes illustrated in the cookie policy.
If you want to learn more or opt out of all or some cookies, see the cookie policy.
By closing this banner you consent to the use of cookies.
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `at_costruttoredrop`.`value` AS `costruttoredrop`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `catalog_product_entity_int` AS `at_costruttoredrop` ON (`at_costruttoredrop`.`entity_id` = `e`.`entity_id`) AND (`at_costruttoredrop`.`attribute_id` = '142') AND (`at_costruttoredrop`.`store_id` = 0)
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE ((((at_costruttoredrop.value = 'costruttoredrop') OR (at_costruttoredrop.value = '2718')))) AND (e.entity_id IN (1301447, 1301448)) ORDER BY FIELD(e.entity_id,1301447,1301448)
LIMIT 5
Go to
BrandManunfacturer
ItemOriginal code manufaturer
DescriptionItem description
Weight (Kg)Unit weight
Min qty
PriceUnit price
AvailabilityAvailability
Available
Incoming goods
Non disponibile
Information request
Insufficient quantity in stock
Replaced item
Delivery dateDelivery dates are estimated only, not binding
