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` = '103'
AND `category_master`.`status` = 1
AND `product`.`language_slug` = 'en'
GROUP BY `product`.`content_id`
ORDER BY `product`.`product_name` ASC
LIMIT 20
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
Bal Hapetek - Illustrated Children's Book
Bal Hapetek - Illustrated Children's Book
Bal Hapetek - Illustrated Children's Book
An illustrated childrens book about the li]fe of Rebbe Yisroel
Odesser.[Soft Cover
| 8 x 11 inches | 20.5 x 27.5 cm
An illustrated childrens book about the li]fe of Rebbe Yisroel
Odesser.[Soft Cover
| 8 x 11 inches | 20.5 x 27.5 cm
An illustrated childrens book about the li]fe of Rebbe Yisroel
Odesser.[Soft Cover
| 8 x 11 inches | 20.5 x 27.5 cm
$6.00
$6.00
$6.00
Letter from Heaven - English - Short
Letter from Heaven - English - Short
Letter from Heaven - English - Short
All about the Petek - the letter from recieved by Rabbi Yisroel Dov
Ber Odeser from Rabbi Nachman of Breslov.
[Soft Cover | 5.1 x 8.2 inches | 13.3 x 22.5 cm]
All about the Petek - the letter from recieved by Rabbi Yisroel Dov
Ber Odeser from Rabbi Nachman of Breslov.
[Soft Cover | 5.1 x 8.2 inches | 13.3 x 22.5 cm]
All about the Petek - the letter from recieved by Rabbi Yisroel Dov
Ber Odeser from Rabbi Nachman of Breslov.
[Soft Cover | 5.1 x 8.2 inches | 13.3 x 22.5 cm]
$5.00
$5.00
$5.00
Shema Yisroel - Mid
Shema Yisroel - Mid
Shema Yisroel - Mid
A number of stories from the life of Rebbe Yisroel Odeser and some
of his teachings.
[Soft Cover | 6 1/2 x 4 3/4 inches | 16.5 x 12 cm]
A number of stories from the life of Rebbe Yisroel Odeser and some
of his teachings.
[Soft Cover | 6 1/2 x 4 3/4 inches | 16.5 x 12 cm]
A number of stories from the life of Rebbe Yisroel Odeser and some
of his teachings.
[Soft Cover | 6 1/2 x 4 3/4 inches | 16.5 x 12 cm]
$4.50
$4.50
$4.50
Yisroel Saba - Regular - Leather Like Cover
Yisroel Saba - Regular - Leather Like Cover
Yisroel Saba - Regular - Leather Like Cover
Life and teachings of Rebbe Yisroel Dov Odesser.
[Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
Life and teachings of Rebbe Yisroel Dov Odesser.
[Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
Life and teachings of Rebbe Yisroel Dov Odesser.
[Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]