nproducts.*, MATCH (title) AGAINST ('venu 3') AS title_relevance
nproducts.publish='y' and MATCH(title, tags) AGAINST('venu 3' IN BOOLEAN MODE)
and in_stock>0 ORDER BY id desc LIMIT 0, 33
We are Middle East's first dedicate online shopping portal for health and wellness products. We are launched in the year 2016 and today we have presence in all GCC countries. We are selling all leading brands in Health and Sports Nutrition, Food Supplements, Fitness Technology and Baby care. All our products are original and sourced directly from the official distribution channels.
eShop Managed By Al Taiyeb Trading FZC United Arab Emirates