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` = '136'
AND `category_master`.`status` = 1
AND `product`.`language_slug` = 'en'
GROUP BY `product`.`content_id`
ORDER BY `product`.`product_name` ASC
LIMIT 20
By R' Nachman of Tcherin. It goes through the whole Shulchan Orach
based on first Torah of Likutey Moharan. It also includes the
sefer; Machnia Zadim. [Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
By R' Nachman of Tcherin. It goes through the whole Shulchan Orach
based on first Torah of Likutey Moharan. It also includes the
sefer; Machnia Zadim. [Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
By R' Nachman of Tcherin. It goes through the whole Shulchan Orach
based on first Torah of Likutey Moharan. It also includes the
sefer; Machnia Zadim. [Hard Cover | 9 3/4 x 7 inches | 25 x 18 cm]
$10.50
$10.50
$10.50
Sichos Vhisorerus
Sichos Vhisorerus
Sichos Vhisorerus
By Rabbi Shmuel Horowitz [Hard Cover | 9 3/4 x 7 inches | 25 x 18
cm]
By Rabbi Shmuel Horowitz [Hard Cover | 9 3/4 x 7 inches | 25 x 18
cm]
By Rabbi Shmuel Horowitz [Hard Cover | 9 3/4 x 7 inches | 25 x 18
cm]
$10.50
$10.50
$10.50
Siddur Sefard With Meshivas Nefesh
Siddur Sefard With Meshivas Nefesh
Siddur Sefard With Meshivas Nefesh
Siddur Nusach Sefard with the text of Meshivas Nefesh 14cm x 11cm
Siddur Nusach Sefard with the text of Meshivas Nefesh 14cm x 11cm
Siddur Nusach Sefard with the text of Meshivas Nefesh 14cm x 11cm
$3.00
$3.00
$3.00
Sod Rashbi
Sod Rashbi
Sod Rashbi
Compilation of Torah and Tefillah about Rebbe Shimon Bar Yochai
Compilation of Torah and Tefillah about Rebbe Shimon Bar Yochai
Compilation of Torah and Tefillah about Rebbe Shimon Bar Yochai