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`.`language_slug` = 'en'
GROUP BY `product`.`content_id`
ORDER BY `product`.`product_name` ASC
LIMIT 20
New upgraded translation by the Keren of Siporay Masiyos into
English.
[Soft Cover | 9 x 6 inches | 22.75 x 15 cm]
New upgraded translation by the Keren of Siporay Masiyos into
English.
[Soft Cover | 9 x 6 inches | 22.75 x 15 cm]
New upgraded translation by the Keren of Siporay Masiyos into
English.
[Soft Cover | 9 x 6 inches | 22.75 x 15 cm]
$11.00
$11.00
$11.00
Alay Hanachal - Mid - Soft Cover
Alay Hanachal - Mid - Soft Cover
Alay Hanachal - Mid - Soft Cover
Selected letters from Rabbi Natan (Alim Letrufa), Rabbi Yisroel Ber
Oddeser (Ebay Hanachal) and other Breslov Chasidim aranged by
topic. Includes TK, Nanach and Petek.[Soft Cover
| 6 1/2 x 4 1/2 in | 16.5 x 11.5 cm]
Selected letters from Rabbi Natan (Alim Letrufa), Rabbi Yisroel Ber
Oddeser (Ebay Hanachal) and other Breslov Chasidim aranged by
topic. Includes TK, Nanach and Petek.[Soft Cover
| 6 1/2 x 4 1/2 in | 16.5 x 11.5 cm]
Selected letters from Rabbi Natan (Alim Letrufa), Rabbi Yisroel Ber
Oddeser (Ebay Hanachal) and other Breslov Chasidim aranged by
topic. Includes TK, Nanach and Petek.[Soft Cover