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` = '128'
AND `category_master`.`status` = 1
AND `product`.`language_slug` = 'en'
GROUP BY `product`.`content_id`
ORDER BY `product`.`product_name` ASC
LIMIT 20
Compilation of inspirational teachings, put together by Rebbe Alter
of Teplic from the books of Rebbe Nachman and his student Rebbe
Nasson.
[Soft Cover | 6.5 x 3 3/4 inches | 16.5 x 12 cm]
Compilation of inspirational teachings, put together by Rebbe Alter
of Teplic from the books of Rebbe Nachman and his student Rebbe
Nasson.
[Soft Cover | 6.5 x 3 3/4 inches | 16.5 x 12 cm]
Compilation of inspirational teachings, put together by Rebbe Alter
of Teplic from the books of Rebbe Nachman and his student Rebbe
Nasson.
[Soft Cover | 6.5 x 3 3/4 inches | 16.5 x 12 cm]
$1.75
$1.75
$1.75
Tehilim with Shemos Hatzadikim - Mid - Leather Like Cover
Tehilim with Shemos Hatzadikim - Mid - Leather Like Cover
Tehilim with Shemos Hatzadikim - Mid - Leather Like Cover
Book of King Dovids Psalms and the Names of the Righteous.
[Hard Cover | 7 x 3 3/4 inches | 17.5 x 12 cm]
Book of King Dovids Psalms and the Names of the Righteous.
[Hard Cover | 7 x 3 3/4 inches | 17.5 x 12 cm]
Book of King Dovids Psalms and the Names of the Righteous.
[Hard Cover | 7 x 3 3/4 inches | 17.5 x 12 cm]
$8.50
$8.50
$8.50
Tehilim with Shemos Hatzadikim - Small
Tehilim with Shemos Hatzadikim - Small
Tehilim with Shemos Hatzadikim - Small
Book of King Dovid's Psalms and the Names of the Righteous.
[Hard Cover | 5 x 3 1/2 inches | 13 x 9 cm]
Book of King Dovid's Psalms and the Names of the Righteous.
[Hard Cover | 5 x 3 1/2 inches | 13 x 9 cm]
Book of King Dovid's Psalms and the Names of the Righteous.
[Hard Cover | 5 x 3 1/2 inches | 13 x 9 cm]