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=117) order by c.position asc limit 1
Fresh Juices
select *,(SELECT size_layouts_id FROM restaurant WHERE id=117) as size_layouts_id,(SELECT image_display FROM category WHERE id=2154) as image_display from product where status=1 and category_id=2154 order by position ASC
1
Apple
Price
3.1
- LBP 0 Price 0
3.1$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=117) as size_layouts_id,(SELECT image_display FROM category WHERE id=2154) as image_display from product where status=1 and category_id=2154 order by position ASC
1
Carrot
Price
3.1
- LBP 0 Price 0
3.1$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=117) as size_layouts_id,(SELECT image_display FROM category WHERE id=2154) as image_display from product where status=1 and category_id=2154 order by position ASC
1
Strawberry
Price
4.5
- LBP 0 Price 0
4.5$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=117) as size_layouts_id,(SELECT image_display FROM category WHERE id=2154) as image_display from product where status=1 and category_id=2154 order by position ASC
1
Kiwi
Price
5
- LBP 0 Price 0
5$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=117) as size_layouts_id,(SELECT image_display FROM category WHERE id=2154) as image_display from product where status=1 and category_id=2154 order by position ASC
1
Mango
Price
7.8
- LBP 0 Price 0
7.8$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=117) as size_layouts_id,(SELECT image_display FROM category WHERE id=2154) as image_display from product where status=1 and category_id=2154 order by position ASC
1
Pineapple
Price
7.8
- LBP 0 Price 0
7.8$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=117) as size_layouts_id,(SELECT image_display FROM category WHERE id=2154) as image_display from product where status=1 and category_id=2154 order by position ASC
1
Avocado, Strawberry
Price
7.2
- LBP 0 Price 0
7.2$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=117) as size_layouts_id,(SELECT image_display FROM category WHERE id=2154) as image_display from product where status=1 and category_id=2154 order by position ASC
1
Mango, Strawberry
Price
7.2
- LBP 0 Price 0
7.2$
select *,(SELECT size_layouts_id FROM restaurant WHERE id=117) as size_layouts_id,(SELECT image_display FROM category WHERE id=2154) as image_display from product where status=1 and category_id=2154 order by position ASC
