select *,(SELECT size_layouts_id FROM restaurant WHERE id=120) as size_layouts_id,(SELECT image_display FROM category WHERE id=2544) as image_display from product where status=1 and category_id=2544 order by position ASC
1
Paincake chokolate
Price
350000
- LBP 0 Price 0
350,000 L.L
select *,(SELECT size_layouts_id FROM restaurant WHERE id=120) as size_layouts_id,(SELECT image_display FROM category WHERE id=2544) as image_display from product where status=1 and category_id=2544 order by position ASC
1
Paincake exotic
Price
400000
- LBP 0 Price 0
400,000 L.L
select *,(SELECT size_layouts_id FROM restaurant WHERE id=120) as size_layouts_id,(SELECT image_display FROM category WHERE id=2544) as image_display from product where status=1 and category_id=2544 order by position ASC
1
Paincake lotus
Price
400000
- LBP 0 Price 0
400,000 L.L
select *,(SELECT size_layouts_id FROM restaurant WHERE id=120) as size_layouts_id,(SELECT image_display FROM category WHERE id=2544) as image_display from product where status=1 and category_id=2544 order by position ASC