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` = '124'
AND `category_master`.`status` = 1
AND `product`.`language_slug` = 'en'
GROUP BY `product`.`content_id`
ORDER BY `product`.`product_name` ASC
LIMIT 20
Eitzos and Mevuarot (2 vol) - Regular - Leather Like Cover
Eitzos and Mevuarot (2 vol) - Regular - Leather Like Cover
Eitzos and Mevuarot (2 vol) - Regular - Leather Like Cover
2 volume set. It has Likutey Eitzos with Mevuaros on the bottom. At
the end of the second volume, it has the letters of Rabbi Shimshon
Barsky who authored the Eitzos Mevuaros and a little of a biography
about him. [Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
2 volume set. It has Likutey Eitzos with Mevuaros on the bottom. At
the end of the second volume, it has the letters of Rabbi Shimshon
Barsky who authored the Eitzos Mevuaros and a little of a biography
about him. [Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
2 volume set. It has Likutey Eitzos with Mevuaros on the bottom. At
the end of the second volume, it has the letters of Rabbi Shimshon
Barsky who authored the Eitzos Mevuaros and a little of a biography
about him. [Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
$24.00
$24.00
$24.00
Eitzos Utfilos - Mid - Leather Like Cover
Eitzos Utfilos - Mid - Leather Like Cover
Eitzos Utfilos - Mid - Leather Like Cover
Prayers from Likutay Tefilos categorized according to advice for
Likutay Eitzot. Compilation created by Keren Rebbe Yisroel Odesser.
[Hard Cover | 7 x 3 3/4 inches | 17.5 x 12 cm]
Prayers from Likutay Tefilos categorized according to advice for
Likutay Eitzot. Compilation created by Keren Rebbe Yisroel Odesser.
[Hard Cover | 7 x 3 3/4 inches | 17.5 x 12 cm]
Prayers from Likutay Tefilos categorized according to advice for
Likutay Eitzot. Compilation created by Keren Rebbe Yisroel Odesser.
[Hard Cover | 7 x 3 3/4 inches | 17.5 x 12 cm]
$9.50
$9.50
$9.50
Likutay Eitzos - Mid - Leather Like Cover
Likutay Eitzos - Mid - Leather Like Cover
Likutay Eitzos - Mid - Leather Like Cover
Practical advise extracted from the books of Rebbe Nachman.
[Hard Cover | 7 x 3 3/4 inches | 17.5 x 12 cm]
Practical advise extracted from the books of Rebbe Nachman.
[Hard Cover | 7 x 3 3/4 inches | 17.5 x 12 cm]
Practical advise extracted from the books of Rebbe Nachman.
[Hard Cover | 7 x 3 3/4 inches | 17.5 x 12 cm]
$8.50
$8.50
$8.50
Likutay Eitzos - Regular - Leather Like Cover
Likutay Eitzos - Regular - Leather Like Cover
Likutay Eitzos - Regular - Leather Like Cover
Practical advise extracted from the books of Rebbe Nachman.
[Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
Practical advise extracted from the books of Rebbe Nachman.
[Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
Practical advise extracted from the books of Rebbe Nachman.
[Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
$10.50
$10.50
$10.50
Likutay Eitzos - Small
Likutay Eitzos - Small
Likutay Eitzos - Small
Practical advise extracted from the books of Rebbe Nachman.
[Hard Cover | 5 x 3 1/2 inches | 13 x 9 cm]
Practical advise extracted from the books of Rebbe Nachman.
[Hard Cover | 5 x 3 1/2 inches | 13 x 9 cm]
Practical advise extracted from the books of Rebbe Nachman.
[Hard Cover | 5 x 3 1/2 inches | 13 x 9 cm]
$5.50
$5.50
$5.50
Likutay Eitzos with Eitzot Hamivoarot - Regular - Leather Like
Cover
Likutay Eitzos with Eitzot Hamivoarot - Regular - Leather Like
Cover
Likutay Eitzos with Eitzot Hamivoarot - Regular - Leather Like
Cover
Practical advise extracted from the books of Rebbe Nachman along
with expansion of advice by Rabbi Shimshon Barsky.
[Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
Practical advise extracted from the books of Rebbe Nachman along
with expansion of advice by Rabbi Shimshon Barsky.
[Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
Practical advise extracted from the books of Rebbe Nachman along
with expansion of advice by Rabbi Shimshon Barsky.
[Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
$12.50
$12.50
$12.50
Tefilos Vetzos
Tefilos Vetzos
Tefilos Vetzos
Prayers from Likutey Tefilot along with Advice 14cm x 10cm
Prayers from Likutey Tefilot along with Advice 14cm x 10cm
Prayers from Likutey Tefilot along with Advice 14cm x 10cm
