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` = '112'
AND `category_master`.`status` = 1
AND `product`.`language_slug` = 'en'
GROUP BY `product`.`content_id`
ORDER BY `product`.`product_name` ASC
LIMIT 20
Prayers of Likutay Tifilos paired side by side with their matching
torah from Kitzur Likutay Maharan. Compiled at the instruction of
Rebbe Yisroel Dov Odesser.[Soft Cover | 6 1/2 x 4 1/2 inches | 16.5
x 11.5 cm]
Prayers of Likutay Tifilos paired side by side with their matching
torah from Kitzur Likutay Maharan. Compiled at the instruction of
Rebbe Yisroel Dov Odesser.[Soft Cover | 6 1/2 x 4 1/2 inches | 16.5
x 11.5 cm]
Prayers of Likutay Tifilos paired side by side with their matching
torah from Kitzur Likutay Maharan. Compiled at the instruction of
Rebbe Yisroel Dov Odesser.[Soft Cover | 6 1/2 x 4 1/2 inches | 16.5
x 11.5 cm]
$10.50
$10.50
$10.50
Kisvay Rebbe Nachman Torahs Utfilos (3 Vol) - Mid
Kisvay Rebbe Nachman Torahs Utfilos (3 Vol) - Mid
Kisvay Rebbe Nachman Torahs Utfilos (3 Vol) - Mid
Kisvay Rebbe Nachman Torahs Utfilos
Kisvay Rebbe Nachman Torahs Utfilos
Kisvay Rebbe Nachman Torahs Utfilos
$24.00
$24.00
$24.00
Kisvay Rebbe Nachman Torahs Utfilos - Mid
Kisvay Rebbe Nachman Torahs Utfilos - Mid
Kisvay Rebbe Nachman Torahs Utfilos - Mid
Kisvay Rebbe Nachman Torahs Utfilos
[Hard Cover | 9.65 x 6.69 inches | 17 X 24.5 cm]
Kisvay Rebbe Nachman Torahs Utfilos
[Hard Cover | 9.65 x 6.69 inches | 17 X 24.5 cm]
Kisvay Rebbe Nachman Torahs Utfilos
[Hard Cover | 9.65 x 6.69 inches | 17 X 24.5 cm]
Prayers of Likutay Tifilos paired side by side with their matching
Torah from Kitzur Likutay Maharan.
Compiled at the instruction of Rebbe Yisroel Dov Odesser.
[Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
Prayers of Likutay Tifilos paired side by side with their matching
Torah from Kitzur Likutay Maharan.
Compiled at the instruction of Rebbe Yisroel Dov Odesser.
[Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
Prayers of Likutay Tifilos paired side by side with their matching
Torah from Kitzur Likutay Maharan.
Compiled at the instruction of Rebbe Yisroel Dov Odesser.
[Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]