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` = '133'
AND `category_master`.`status` = 1
AND `product`.`language_slug` = 'en'
GROUP BY `product`.`content_id`
ORDER BY `product`.`product_name` ASC
LIMIT 20
Sefer Hamidos - Book of Traits in English [Hard Cover | 9 3/4 x 7
inches | 25 x 18 cm]
Sefer Hamidos - Book of Traits in English [Hard Cover | 9 3/4 x 7
inches | 25 x 18 cm]
Sefer Hamidos - Book of Traits in English [Hard Cover | 9 3/4 x 7
inches | 25 x 18 cm]
$17.00
$17.00
$17.00
Sefer Hamedos - English - Mid
Sefer Hamedos - English - Mid
Sefer Hamedos - English - Mid
Book of attributes, list the attributes of reality as well as their
cause and effect. Written by Rebbe Nachman. Includes Hebrew text
along with a side by side English translation.
[Soft Cover | 6.5 x 3 3/4 inches | 16.5 x 12 cm]
Book of attributes, list the attributes of reality as well as their
cause and effect. Written by Rebbe Nachman. Includes Hebrew text
along with a side by side English translation.
[Soft Cover | 6.5 x 3 3/4 inches | 16.5 x 12 cm]
Book of attributes, list the attributes of reality as well as their
cause and effect. Written by Rebbe Nachman. Includes Hebrew text
along with a side by side English translation.
[Soft Cover | 6.5 x 3 3/4 inches | 16.5 x 12 cm]
$2.85
$2.85
$2.85
Sefer Hamedos - Mid - Leather Like Cover
Sefer Hamedos - Mid - Leather Like Cover
Sefer Hamedos - Mid - Leather Like Cover
Book of attributes, list the attributes of reality as well as their
cause and effect. Written by Rebbe Nachman.
[Hard Cover | 7 x 3 3/4 inches | 17.5 x 12 cm]
Book of attributes, list the attributes of reality as well as their
cause and effect. Written by Rebbe Nachman.
[Hard Cover | 7 x 3 3/4 inches | 17.5 x 12 cm]
Book of attributes, list the attributes of reality as well as their
cause and effect. Written by Rebbe Nachman.
[Hard Cover | 7 x 3 3/4 inches | 17.5 x 12 cm]
$8.50
$8.50
$8.50
Sefer Hamedos - Pocket
Sefer Hamedos - Pocket
Sefer Hamedos - Pocket
Book of attributes, list the attributes of reality as well as their
cause and effect. Written by Rebbe Nachman.
Book of attributes, list the attributes of reality as well as their
cause and effect. Written by Rebbe Nachman.
Book of attributes, list the attributes of reality as well as their
cause and effect. Written by Rebbe Nachman.
$1.50
$1.50
$1.50
Sefer Hamedos - Regular - Leather Like Cover
Sefer Hamedos - Regular - Leather Like Cover
Sefer Hamedos - Regular - Leather Like Cover
Book of attributes, list the attributes of reality as well as their
cause and effect. Written by Rebbe Nachman.
[Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
Book of attributes, list the attributes of reality as well as their
cause and effect. Written by Rebbe Nachman.
[Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
Book of attributes, list the attributes of reality as well as their
cause and effect. Written by Rebbe Nachman.
[Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
$10.50
$10.50
$10.50
Sefer Hamedos - Small
Sefer Hamedos - Small
Sefer Hamedos - Small
Book of attributes, list the attributes of reality as well as their
cause and effect. Written by Rebbe Nachman.
[Hard Cover | 5 x 3 1/2 inches | 13 x 9 cm]
Book of attributes, list the attributes of reality as well as their
cause and effect. Written by Rebbe Nachman.
[Hard Cover | 5 x 3 1/2 inches | 13 x 9 cm]
Book of attributes, list the attributes of reality as well as their
cause and effect. Written by Rebbe Nachman.
[Hard Cover | 5 x 3 1/2 inches | 13 x 9 cm]
$5.50
$5.50
$5.50
Sefer Hamidos - Small - Hard Cover
Sefer Hamidos - Small - Hard Cover
Sefer Hamidos - Small - Hard Cover
Book of attributes, list the attributes of reality as well as their
cause and effect. Written by Rebbe Nachman.
Book of attributes, list the attributes of reality as well as their
cause and effect. Written by Rebbe Nachman.
Book of attributes, list the attributes of reality as well as their
cause and effect. Written by Rebbe Nachman.
