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` = '127'
AND `category_master`.`status` = 1
AND `product`.`language_slug` = 'en'
GROUP BY `product`.`content_id`
ORDER BY `product`.`product_name` ASC
LIMIT 20
Selected letters from Rabbi Natan (Alim Letrufa), Rabbi Yisroel Ber
Oddeser (Ebay Hanachal) and other Breslov Chasidim aranged by
topic. Includes TK, Nanach and Petek.[Soft Cover
| 6 1/2 x 4 1/2 in | 16.5 x 11.5 cm]
Selected letters from Rabbi Natan (Alim Letrufa), Rabbi Yisroel Ber
Oddeser (Ebay Hanachal) and other Breslov Chasidim aranged by
topic. Includes TK, Nanach and Petek.[Soft Cover
| 6 1/2 x 4 1/2 in | 16.5 x 11.5 cm]
Selected letters from Rabbi Natan (Alim Letrufa), Rabbi Yisroel Ber
Oddeser (Ebay Hanachal) and other Breslov Chasidim aranged by
topic. Includes TK, Nanach and Petek.[Soft Cover
| 6 1/2 x 4 1/2 in | 16.5 x 11.5 cm]
$2.50
$2.50
$2.50
Alim Litrufa - Mid - Leather Like Cover
Alim Litrufa - Mid - Leather Like Cover
Alim Litrufa - Mid - Leather Like Cover
Midsized print of Rebbe Nasson's letters. [Hard Cover
| 7 x 3 3/4 inches | 17.5 x 12 cm]
Midsized print of Rebbe Nasson's letters. [Hard Cover
| 7 x 3 3/4 inches | 17.5 x 12 cm]
Midsized print of Rebbe Nasson's letters. [Hard Cover
| 7 x 3 3/4 inches | 17.5 x 12 cm]
$9.50
$9.50
$9.50
Alim Litrufa - Regular - Leather Like Cover
Alim Litrufa - Regular - Leather Like Cover
Alim Litrufa - Regular - Leather Like Cover
Classic print of Rebbe Nasson's letters with an elegent leather
like cover. This edition also includes a number of letters written
by Rabbi Nachman of Breslov.[Hard Cover | 9 3/4 x 7 inches | 25 x
18 cm]
Classic print of Rebbe Nasson's letters with an elegent leather
like cover. This edition also includes a number of letters written
by Rabbi Nachman of Breslov.[Hard Cover | 9 3/4 x 7 inches | 25 x
18 cm]
Classic print of Rebbe Nasson's letters with an elegent leather
like cover. This edition also includes a number of letters written
by Rabbi Nachman of Breslov.[Hard Cover | 9 3/4 x 7 inches | 25 x
18 cm]
$11.00
$11.00
$11.00
Alim Litrufa 3 Vol - Mid - Leather Like Cover
Alim Litrufa 3 Vol - Mid - Leather Like Cover
Alim Litrufa 3 Vol - Mid - Leather Like Cover
Mid sized print of Rebbe Nasson's letters with large letters and
split into 3 volumes
Mid sized print of Rebbe Nasson's letters with large letters and
split into 3 volumes
Mid sized print of Rebbe Nasson's letters with large letters and
split into 3 volumes
$25.50
$25.50
$25.50
Sheva Meshivay Tom
Sheva Meshivay Tom
Sheva Meshivay Tom
Reviving and inspiring excerpts from Alim Letrufa 14cm x 11cm
Reviving and inspiring excerpts from Alim Letrufa 14cm x 11cm
Reviving and inspiring excerpts from Alim Letrufa 14cm x 11cm