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` = '122'
AND `category_master`.`status` = 1
AND `product`.`language_slug` = 'en'
GROUP BY `product`.`content_id`
ORDER BY `product`.`product_name` ASC
LIMIT 20
Prayers composed by Rebbe Nason based on the teachings of Rebbe
Nachman in Likutay Maharan.
[Hard Cover | 7 x 3 3/4 inches | 17.5 x 12 cm]
Prayers composed by Rebbe Nason based on the teachings of Rebbe
Nachman in Likutay Maharan.
[Hard Cover | 7 x 3 3/4 inches | 17.5 x 12 cm]
Prayers composed by Rebbe Nason based on the teachings of Rebbe
Nachman in Likutay Maharan.
[Hard Cover | 7 x 3 3/4 inches | 17.5 x 12 cm]
$9.50
$9.50
$9.50
Likutay Tefilos - Regular - Leather Like Cover
Likutay Tefilos - Regular - Leather Like Cover
Likutay Tefilos - Regular - Leather Like Cover
Prayers composed by Rebbe Nason based on the teachings of Rebbe
Nachman in Likutay Maharan.
[Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
Prayers composed by Rebbe Nason based on the teachings of Rebbe
Nachman in Likutay Maharan.
[Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
Prayers composed by Rebbe Nason based on the teachings of Rebbe
Nachman in Likutay Maharan.
[Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
$11.00
$11.00
$11.00
Likutay Tefilos - Small
Likutay Tefilos - Small
Likutay Tefilos - Small
Likutay Tefilos - Small
Likutay Tefilos - Small
Likutay Tefilos - Small
$5.50
$5.50
$5.50
Likutay Tefilos 3 Vol - Mid - Leather Like Cover
Likutay Tefilos 3 Vol - Mid - Leather Like Cover
Likutay Tefilos 3 Vol - Mid - Leather Like Cover
Prayers composed by Rebbe Nason based on the teachings of Rebbe
Nachman in Likutay Maharan. This print has large letters and is
split into 3 volumes
Prayers composed by Rebbe Nason based on the teachings of Rebbe
Nachman in Likutay Maharan. This print has large letters and is
split into 3 volumes
Prayers composed by Rebbe Nason based on the teachings of Rebbe
Nachman in Likutay Maharan. This print has large letters and is
split into 3 volumes
$25.50
$25.50
$25.50
Likutay Tefilos Zmanei Hashanah - Mid - Leather Like Cover
Likutay Tefilos Zmanei Hashanah - Mid - Leather Like Cover
Likutay Tefilos Zmanei Hashanah - Mid - Leather Like Cover
Prayers composed by Rebbe Nason based on the teachings of Rebbe
Nachman in Likutay Maharan arranged and categorized according the
the Jewish calendar and holidays.
[Hard Cover | 7 x 3 3/4 inches | 17.5 x 12 cm]
Prayers composed by Rebbe Nason based on the teachings of Rebbe
Nachman in Likutay Maharan arranged and categorized according the
the Jewish calendar and holidays.
[Hard Cover | 7 x 3 3/4 inches | 17.5 x 12 cm]
Prayers composed by Rebbe Nason based on the teachings of Rebbe
Nachman in Likutay Maharan arranged and categorized according the
the Jewish calendar and holidays.
[Hard Cover | 7 x 3 3/4 inches | 17.5 x 12 cm]
$8.50
$8.50
$8.50
Likutay Tefilos Zmanei Hashanah - Small
Likutay Tefilos Zmanei Hashanah - Small
Likutay Tefilos Zmanei Hashanah - Small
Likutay Tefilos Zmanei Hashanah - Small
Likutay Tefilos Zmanei Hashanah - Small
Likutay Tefilos Zmanei Hashanah - Small
$5.50
$5.50
$5.50
Likutey Tefilos - Regular
Likutey Tefilos - Regular
Likutey Tefilos - Regular
Likutey Tefilos
[Hard Cover | 9.65 x 6.69 inches | 17 X 24.5 cm]
Likutey Tefilos
[Hard Cover | 9.65 x 6.69 inches | 17 X 24.5 cm]
Likutey Tefilos
[Hard Cover | 9.65 x 6.69 inches | 17 X 24.5 cm]
$5.85
$5.85
$5.85
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
Prayers From Heart's Strings Vol 1 - English - Mid
Prayers From Heart's Strings Vol 1 - English - Mid
Prayers From Heart's Strings Vol 1 - English - Mid
Selected compilations of prayers from Likutay Tefilos translated
into English. Has index by Subject. Includes Petek.
Selected compilations of prayers from Likutay Tefilos translated
into English. Has index by Subject. Includes Petek.
Selected compilations of prayers from Likutay Tefilos translated
into English. Has index by Subject. Includes Petek.
$5.00
$5.00
$5.00
Tefilos Vetzos
Tefilos Vetzos
Tefilos Vetzos
Prayers from Likutey Tefilot along with Advice 14cm x 10cm
Prayers from Likutey Tefilot along with Advice 14cm x 10cm
Prayers from Likutey Tefilot along with Advice 14cm x 10cm
$1.75
$1.75
$1.75
Tefilot Zimany Hashana - English - Leather Like Cover
Tefilot Zimany Hashana - English - Leather Like Cover
Tefilot Zimany Hashana - English - Leather Like Cover
Selected prayers from Likutey Tefilos related to the holidays and
various times of the year, in English [Hard Cover | 9 3/4 x 7
inches | 25 x 18 cm]
Selected prayers from Likutey Tefilos related to the holidays and
various times of the year, in English [Hard Cover | 9 3/4 x 7
inches | 25 x 18 cm]
Selected prayers from Likutey Tefilos related to the holidays and
various times of the year, in English [Hard Cover | 9 3/4 x 7
inches | 25 x 18 cm]
