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` = '104'
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
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]
