select p.products_id, pd.products_name,
/*ZB EFI Free_shipping_by_store - changing to read from cache_products table*/
cp.products_free_shipping_ups, cp.products_free_shipping_usps, cp.products_free_shipping_table,
p.products_restrict_air, p.products_restrict_usps, p.products_restrict_ups, p.products_model,
IF(ps.products_price IS NULL, p.products_price, ps.products_price) as products_price,
IF(ps.products_quantity_breakpoint IS NULL, p.products_quantity_breakpoint, ps.products_quantity_breakpoint) as products_quantity_breakpoint,
IF(ps.products_quantity_price IS NULL, p.products_quantity_price, ps.products_quantity_price) as products_quantity_price,
p.products_weight, p.products_tax_class_id, p.registration_id, p.products_man_sku, p.products_upc, p.country,
IF(((ps.products_cart_limit IS NULL) OR (ps.products_cart_limit = '0')), p.products_cart_limit, ps.products_cart_limit) as products_cart_limit,
p.products_multipack_quantity as products_multipack_quantity,
/* ZB EFI Free_shipping_by_store */
p2c.products_id, p2c.categories_id
FROM products p
LEFT JOIN products_to_categories p2c ON(p2c.products_id = p.products_id)
LEFT JOIN cache_products cp ON(p2c.categories_id = cp.categories_id)
INNER JOIN products_description pd
LEFT JOIN products_stores ps ON(p.products_id = ps.products_id AND ps.stores_id = '" . STORE_ID . "')
WHERE p.products_id='608'
AND pd.products_id = p.products_id
AND pd.language_id = '1'