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=127) order by c.position asc limit 1
مقبلات باردة
select *,(SELECT size_layouts_id FROM restaurant WHERE id=127) as size_layouts_id,(SELECT image_display FROM category WHERE id=1738) as image_display from product where status=1 and category_id=1738 order by position ASC
1
جاط خضرة
Price4 - LBP 0 Price 0
4$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=127) as size_layouts_id,(SELECT image_display FROM category WHERE id=1738) as image_display from product where status=1 and category_id=1738 order by position ASC
1
كبيس
Price2.5 - LBP 0 Price 0
2.5$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=127) as size_layouts_id,(SELECT image_display FROM category WHERE id=1738) as image_display from product where status=1 and category_id=1738 order by position ASC
1
مكدوس
Price5 - LBP 0 Price 0
5$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=127) as size_layouts_id,(SELECT image_display FROM category WHERE id=1738) as image_display from product where status=1 and category_id=1738 order by position ASC
1
لبنة بتوم
Price4.5 - LBP 0 Price 0
4.5$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=127) as size_layouts_id,(SELECT image_display FROM category WHERE id=1738) as image_display from product where status=1 and category_id=1738 order by position ASC
1
تبولة
Price6.5 - LBP 0 Price 0
6.5$ Large5.25$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=127) as size_layouts_id,(SELECT image_display FROM category WHERE id=1738) as image_display from product where status=1 and category_id=1738 order by position ASC
1
فتوش
Price6.5 - LBP 0 Price 0
6.5$ Large5.5$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=127) as size_layouts_id,(SELECT image_display FROM category WHERE id=1738) as image_display from product where status=1 and category_id=1738 order by position ASC
1
كبة نية
Price9 - LBP 0 Price 0
9$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=127) as size_layouts_id,(SELECT image_display FROM category WHERE id=1738) as image_display from product where status=1 and category_id=1738 order by position ASC
1
تابلة
Price9 - LBP 0 Price 0
9$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=127) as size_layouts_id,(SELECT image_display FROM category WHERE id=1738) as image_display from product where status=1 and category_id=1738 order by position ASC
1
لوحة نية
Price11 - LBP 0 Price 0
11$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=127) as size_layouts_id,(SELECT image_display FROM category WHERE id=1738) as image_display from product where status=1 and category_id=1738 order by position ASC
1
حمص
Price4 - LBP 0 Price 0
4$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=127) as size_layouts_id,(SELECT image_display FROM category WHERE id=1738) as image_display from product where status=1 and category_id=1738 order by position ASC
1
لبنة
Price4 - LBP 0 Price 0
4$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=127) as size_layouts_id,(SELECT image_display FROM category WHERE id=1738) as image_display from product where status=1 and category_id=1738 order by position ASC
1
متبل
Price4 - LBP 0 Price 0
4$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=127) as size_layouts_id,(SELECT image_display FROM category WHERE id=1738) as image_display from product where status=1 and category_id=1738 order by position ASC
1
شنكليش
Price6 - LBP 0 Price 0
6$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=127) as size_layouts_id,(SELECT image_display FROM category WHERE id=1738) as image_display from product where status=1 and category_id=1738 order by position ASC
1
جبنة بلدي
Price6 - LBP 0 Price 0
6$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=127) as size_layouts_id,(SELECT image_display FROM category WHERE id=1738) as image_display from product where status=1 and category_id=1738 order by position ASC
1
جبنة ضرفية
Price7 - LBP 0 Price 0
7$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=127) as size_layouts_id,(SELECT image_display FROM category WHERE id=1738) as image_display from product where status=1 and category_id=1738 order by position ASC
