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` = '110'
AND `category_master`.`status` = 1
AND `product`.`language_slug` = 'en'
GROUP BY `product`.`content_id`
ORDER BY `product`.`product_name` ASC
LIMIT 20
Spanish pamphlet with a collection of Rebbe Nachman's teachings
about Hisbodedute meditation - conversing with Hashem.
Spanish pamphlet with a collection of Rebbe Nachman's teachings
about Hisbodedute meditation - conversing with Hashem.
Spanish pamphlet with a collection of Rebbe Nachman's teachings
about Hisbodedute meditation - conversing with Hashem.
$1.50
$1.50
$1.50
Hishtapchs HaNefesh - Mid - Hard Cover
Hishtapchs HaNefesh - Mid - Hard Cover
Hishtapchs HaNefesh - Mid - Hard Cover
Pamphlet with a collection of Rebbe Nachmans teachings about
Hisbodedute meditation - conversing with Hashem.
Pamphlet with a collection of Rebbe Nachmans teachings about
Hisbodedute meditation - conversing with Hashem.
Pamphlet with a collection of Rebbe Nachmans teachings about
Hisbodedute meditation - conversing with Hashem.
$2.50
$2.50
$2.50
Hishtapchus & Mishivas Nefesh - Mid
Hishtapchus & Mishivas Nefesh - Mid
Hishtapchus & Mishivas Nefesh - Mid
Hishtapchus & Mishivas Nefesh
[Hard Cover | 6.89 x 4.72 in | 17.5X12 cm]
Hishtapchus & Mishivas Nefesh
[Hard Cover | 6.89 x 4.72 in | 17.5X12 cm]
Hishtapchus & Mishivas Nefesh
[Hard Cover | 6.89 x 4.72 in | 17.5X12 cm]
$2.85
$2.85
$2.85
Hishtapchus Hanefesh - French
Hishtapchus Hanefesh - French
Hishtapchus Hanefesh - French
Compilation about Hisbodedute meditation, put together by Rebbe
Alter of Teplic from the books of Rebbe Nachman and his student
Rebbe Nasson.
[8 1/2 x 5 1/2 inches | 21.75 x 14 cm]
Compilation about Hisbodedute meditation, put together by Rebbe
Alter of Teplic from the books of Rebbe Nachman and his student
Rebbe Nasson.
[8 1/2 x 5 1/2 inches | 21.75 x 14 cm]
Compilation about Hisbodedute meditation, put together by Rebbe
Alter of Teplic from the books of Rebbe Nachman and his student
Rebbe Nasson.
[8 1/2 x 5 1/2 inches | 21.75 x 14 cm]
$9.50
$9.50
$9.50
Hishtapchut & Meshivas Nefesh - English - Leather Like Cover
Hishtapchut & Meshivas Nefesh - English - Leather Like Cover
Hishtapchut & Meshivas Nefesh - English - Leather Like Cover
Hishtapchus Hanefesh and Meshivas Nefesh - Outpouring of the Soul
and Revival of the Soul in English [Hard Cover | 9 3/4 x 7 inches |
25 x 18 cm]
Hishtapchus Hanefesh and Meshivas Nefesh - Outpouring of the Soul
and Revival of the Soul in English [Hard Cover | 9 3/4 x 7 inches |
25 x 18 cm]
Hishtapchus Hanefesh and Meshivas Nefesh - Outpouring of the Soul
and Revival of the Soul in English [Hard Cover | 9 3/4 x 7 inches |
25 x 18 cm]
$17.00
$17.00
$17.00
Hishtapchut and Mishivas Nefesh - Mid - Leather Like Cover
Hishtapchut and Mishivas Nefesh - Mid - Leather Like Cover
Hishtapchut and Mishivas Nefesh - Mid - Leather Like Cover
Compilation about Hisbodedute meditation, put together by Rebbe
Alter of Teplic from the books of Rebbe Nachman and his student
Rebbe Nasson.[Hard Cover | 7 x 3 3/4 inches | 17.5 x 12 cm]
Compilation about Hisbodedute meditation, put together by Rebbe
Alter of Teplic from the books of Rebbe Nachman and his student
Rebbe Nasson.[Hard Cover | 7 x 3 3/4 inches | 17.5 x 12 cm]
Compilation about Hisbodedute meditation, put together by Rebbe
Alter of Teplic from the books of Rebbe Nachman and his student
Rebbe Nasson.[Hard Cover | 7 x 3 3/4 inches | 17.5 x 12 cm]
$8.50
$8.50
$8.50
Hishtapchut and Mishivas Nefesh - Regular - Leather Like Cover
Hishtapchut and Mishivas Nefesh - Regular - Leather Like Cover
Hishtapchut and Mishivas Nefesh - Regular - Leather Like Cover
Compilation about Hisbodedute meditation and inspiration put
together by Rebbe Alter of Teplic from the books of Rebbe Nachman
and his student Rebbe Nasson.[Hard Cover | 9 3/4 x 7 inches | 25 x
18 cm]
Compilation about Hisbodedute meditation and inspiration put
together by Rebbe Alter of Teplic from the books of Rebbe Nachman
and his student Rebbe Nasson.[Hard Cover | 9 3/4 x 7 inches | 25 x
18 cm]
Compilation about Hisbodedute meditation and inspiration put
together by Rebbe Alter of Teplic from the books of Rebbe Nachman
and his student Rebbe Nasson.[Hard Cover | 9 3/4 x 7 inches | 25 x
18 cm]
$10.50
$10.50
$10.50
Hishtapchut Hanefesh - Small
Hishtapchut Hanefesh - Small
Hishtapchut Hanefesh - Small
Compilation about Hisbodedute meditation, put together by Rebbe
Alter of Teplic from the books of Rebbe Nachman and his student
Rebbe Nasson.[Hard Cover | 5 x 3 1/2 inches | 13 x 9 cm]
Compilation about Hisbodedute meditation, put together by Rebbe
Alter of Teplic from the books of Rebbe Nachman and his student
Rebbe Nasson.[Hard Cover | 5 x 3 1/2 inches | 13 x 9 cm]
Compilation about Hisbodedute meditation, put together by Rebbe
Alter of Teplic from the books of Rebbe Nachman and his student
Rebbe Nasson.[Hard Cover | 5 x 3 1/2 inches | 13 x 9 cm]
$5.50
$5.50
$5.50
Hitbodedut - English - Pamphlet
Hitbodedut - English - Pamphlet
Hitbodedut - English - Pamphlet
Pamphlet with a collection of Rebbe Nachmans teachings about
Hisbodedute meditation - conversing with Hashem.
Pamphlet with a collection of Rebbe Nachmans teachings about
Hisbodedute meditation - conversing with Hashem.
Pamphlet with a collection of Rebbe Nachmans teachings about
Hisbodedute meditation - conversing with Hashem.
$1.50
$1.50
$1.50
Outpouring of the Soul - English
Outpouring of the Soul - English
Outpouring of the Soul - English
A translation of Hishtapchus Hanefesh in English
A translation of Hishtapchus Hanefesh in English
A translation of Hishtapchus Hanefesh in English
$3.00
$3.00
$3.00
Revival and Outpouring of the Soul - English - Regular
Revival and Outpouring of the Soul - English - Regular
Revival and Outpouring of the Soul - English - Regular
Compilation about Hisbodedute meditation and inspiration put
together by Rebbe Alter of Teplic from the books of Rebbe Nachman
and his student Rebbe Nasson.
[Soft Cover | 8 3/4 x 5 3/4 inches | 22.25 x 14.75 cm]
Compilation about Hisbodedute meditation and inspiration put
together by Rebbe Alter of Teplic from the books of Rebbe Nachman
and his student Rebbe Nasson.
[Soft Cover | 8 3/4 x 5 3/4 inches | 22.25 x 14.75 cm]
Compilation about Hisbodedute meditation and inspiration put
together by Rebbe Alter of Teplic from the books of Rebbe Nachman
and his student Rebbe Nasson.
[Soft Cover | 8 3/4 x 5 3/4 inches | 22.25 x 14.75 cm]