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` = '100'
AND `category_master`.`status` = 1
AND `product`.`language_slug` = 'en'
GROUP BY `product`.`content_id`
ORDER BY `product`.`product_name` ASC
LIMIT 20
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
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
Likutey Tefilos for Children
Likutey Tefilos for Children
Likutey Tefilos for Children
Selected prayer from Likutay Tefilos for Children with
Illustrations
[Hard Cover - 11.81 inches x 8.66 inches / 22x30 cm]
Selected prayer from Likutay Tefilos for Children with
Illustrations
[Hard Cover - 11.81 inches x 8.66 inches / 22x30 cm]
Selected prayer from Likutay Tefilos for Children with
Illustrations
[Hard Cover - 11.81 inches x 8.66 inches / 22x30 cm]
$12.75
$12.75
$12.75
Rabbeinu Hakadosh (4 vol)
Rabbeinu Hakadosh (4 vol)
Rabbeinu Hakadosh (4 vol)
Stories about Rebbe Nachman of Breslov set of 4 books complied by
the Keren.
[Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
Stories about Rebbe Nachman of Breslov set of 4 books complied by
the Keren.
[Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
Stories about Rebbe Nachman of Breslov set of 4 books complied by
the Keren.
[Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
$44.50
$44.50
$44.50
Yisroel'nu HaPigisha ShBalev
Yisroel'nu HaPigisha ShBalev
Yisroel'nu HaPigisha ShBalev
An Illustrated Children's Book. Yisroel, a Breslov child learns an
important lesson.
[Hard Cover | 9.45 x 9.45 inches | 24 x 24 cm]
An Illustrated Children's Book. Yisroel, a Breslov child learns an
important lesson.
[Hard Cover | 9.45 x 9.45 inches | 24 x 24 cm]
An Illustrated Children's Book. Yisroel, a Breslov child learns an
important lesson.
[Hard Cover | 9.45 x 9.45 inches | 24 x 24 cm]
