SELECT `product`.*, `product_image`.`image`, IF((product.sale_price>0), `product`.`sale_price`, product.price) AS sort_price, GROUP_CONCAT(product_options.option_id SEPARATOR ", ") as option_id
FROM `product`
LEFT JOIN `product_category` ON `product`.`content_id` = `product_category`.`content_id`
LEFT JOIN `category_master` ON `product_category`.`category_content_id` = `category_master`.`content_id`
LEFT JOIN `product_options` ON `product`.`content_id` = `product_options`.`content_id`
LEFT JOIN `product_image` ON (`product`.`content_id` = `product_image`.`content_id` AND `main_image` = 1)
WHERE `product`.`status` = 1
AND `product_category`.`category_content_id` = '96'
AND `category_master`.`status` = 1
AND `product`.`language_slug` = 'en'
GROUP BY `product`.`content_id`
ORDER BY `product`.`product_name` ASC
LIMIT 20
Set of three books filled with stories about the Baal Shem Tov. It
includes the original Shivchi HaBaal Shem Tov as well as two
volumes of Bikvos HaBaal Shem Tov filled with great stories
complied by the Keren.
Set of three books filled with stories about the Baal Shem Tov. It
includes the original Shivchi HaBaal Shem Tov as well as two
volumes of Bikvos HaBaal Shem Tov filled with great stories
complied by the Keren.
Set of three books filled with stories about the Baal Shem Tov. It
includes the original Shivchi HaBaal Shem Tov as well as two
volumes of Bikvos HaBaal Shem Tov filled with great stories
complied by the Keren.