select c.id, c.name, c.image_display, (select count(c2.id) from category c2 where c2.parent_id = c.id ) sub_category_count from category c where c.id IN (select c2.id from category c2 where c2.company_id=101) order by c.position asc limit 1
صحن يومي
select *,(SELECT size_layouts_id FROM restaurant WHERE id=101) as size_layouts_id,(SELECT image_display FROM category WHERE id=1625) as image_display from product where status=1 and category_id=1625 order by position ASC
1
مقلوبة باذنجان
Price
0
- LBP 95000 Price 0
0 L.L
select *,(SELECT size_layouts_id FROM restaurant WHERE id=101) as size_layouts_id,(SELECT image_display FROM category WHERE id=1625) as image_display from product where status=1 and category_id=1625 order by position ASC
1
أرز برياني بالدجاج
Price
0
- LBP 95000 Price 0
0 L.L
select *,(SELECT size_layouts_id FROM restaurant WHERE id=101) as size_layouts_id,(SELECT image_display FROM category WHERE id=1625) as image_display from product where status=1 and category_id=1625 order by position ASC
1
سترغنوف دجاج
Price
0
- LBP 95000 Price 0
0 L.L
select *,(SELECT size_layouts_id FROM restaurant WHERE id=101) as size_layouts_id,(SELECT image_display FROM category WHERE id=1625) as image_display from product where status=1 and category_id=1625 order by position ASC
1
سمكة حرة طرابلسية
Price
0
- LBP 95000 Price 0
0 L.L
select *,(SELECT size_layouts_id FROM restaurant WHERE id=101) as size_layouts_id,(SELECT image_display FROM category WHERE id=1625) as image_display from product where status=1 and category_id=1625 order by position ASC
