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` = '97'
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
Ashreinu - Mid
Ashreinu - Mid
Ashreinu - Mid
Stories and conversations from Rabbi Yisroel Dov Ber Oddeser.
Stories and conversations from Rabbi Yisroel Dov Ber Oddeser.
Stories and conversations from Rabbi Yisroel Dov Ber Oddeser.
$2.00
$2.00
$2.00
Baal Shem Tov Stories Set of 3 - Regular
Baal Shem Tov Stories Set of 3 - Regular
Baal Shem Tov Stories Set of 3 - Regular
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.
$34.00
$34.00
$34.00
Ebay Hanachal - Mid
Ebay Hanachal - Mid
Ebay Hanachal - Mid
Letters of Rebbe Yisroel Dov Odesser to President of Israel Zalman
Shazar.
[Soft Cover | 6 1/2 x 4 1/2 in | 16.5 x 11.5 cm]
Letters of Rebbe Yisroel Dov Odesser to President of Israel Zalman
Shazar.
[Soft Cover | 6 1/2 x 4 1/2 in | 16.5 x 11.5 cm]
Letters of Rebbe Yisroel Dov Odesser to President of Israel Zalman
Shazar.
[Soft Cover | 6 1/2 x 4 1/2 in | 16.5 x 11.5 cm]
$2.50
$2.50
$2.50
Ebay Hanachal - Mid - Leather Like Cover
Ebay Hanachal - Mid - Leather Like Cover
Ebay Hanachal - Mid - Leather Like Cover
Letters of Rebbe Yisroel Dov Odesser to President of Israel Zalman
Shazar.
Letters of Rebbe Yisroel Dov Odesser to President of Israel Zalman
Shazar.
Letters of Rebbe Yisroel Dov Odesser to President of Israel Zalman
Shazar.
$8.50
$8.50
$8.50
Ebay Hanachal - Regular
Ebay Hanachal - Regular
Ebay Hanachal - Regular
Letters of Rebbe Yisroel Dov Odesser to President of Israel Zalman
Shazar.[Hard Cover
| 9 3/4 x 7 inches | 25 x 18 cm]
Letters of Rebbe Yisroel Dov Odesser to President of Israel Zalman
Shazar.[Hard Cover
| 9 3/4 x 7 inches | 25 x 18 cm]
Letters of Rebbe Yisroel Dov Odesser to President of Israel Zalman
Shazar.[Hard Cover
| 9 3/4 x 7 inches | 25 x 18 cm]
$8.00
$8.00
$8.00
Ebay Hanachal - Regular - Leather Like Cover
Ebay Hanachal - Regular - Leather Like Cover
Ebay Hanachal - Regular - Leather Like Cover
Letters of Rebbe Yisroel Dov Odesser to President of Israel Zalman
Shazar.
Letters of Rebbe Yisroel Dov Odesser to President of Israel Zalman
Shazar.
Letters of Rebbe Yisroel Dov Odesser to President of Israel Zalman
Shazar.
$10.50
$10.50
$10.50
Ebay Hanachal - Small
Ebay Hanachal - Small
Ebay Hanachal - Small
Letters of Rebbe Yisroel Dov Odesser to President of Israel Zalman
Shazar.[Hard Cover | 5 x 3 1/2 inches | 13 x 9 cm]
Letters of Rebbe Yisroel Dov Odesser to President of Israel Zalman
Shazar.[Hard Cover | 5 x 3 1/2 inches | 13 x 9 cm]
Letters of Rebbe Yisroel Dov Odesser to President of Israel Zalman
Shazar.[Hard Cover | 5 x 3 1/2 inches | 13 x 9 cm]
$5.50
$5.50
$5.50
Kisvay Rebbe Yisroel - Short
Kisvay Rebbe Yisroel - Short
Kisvay Rebbe Yisroel - Short
Letters of Rebbe Yisroel Karduner and Rebbe Yisroel Dov
Odesser.
[Hard Cover | 9 1/4 x 6 1/4 inches | 23.5 x 15.75 cm]
Letters of Rebbe Yisroel Karduner and Rebbe Yisroel Dov
Odesser.
[Hard Cover | 9 1/4 x 6 1/4 inches | 23.5 x 15.75 cm]
Letters of Rebbe Yisroel Karduner and Rebbe Yisroel Dov
Odesser.
[Hard Cover | 9 1/4 x 6 1/4 inches | 23.5 x 15.75 cm]