Sticky Fingers  

Dsoft database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND mc.client_id=126 AND mi.disable_half_half!=1 ORDER BY mc.list_o' at line 19]
SELECT mi.condiment_group_id, ca.client_code, mi.SellShop, mi.PLU, mi.SellDelivery, mi.SubCategoryID, mi.description, ig.group_name, mc.group_id, mi.size_group, (SELECT mii.SellShop FROM menu_item_groups miig LEFT JOIN menu_items mii ON mii.PLU = miig.PLU AND mii.client_id=126 WHERE miig.group_id= mc.group_id AND mii.size_group='LRG' GROUP BY mii.client_id) AS SellShop_, (SELECT mii.SellDelivery FROM menu_item_groups miig LEFT JOIN menu_items mii ON mii.PLU = miig.PLU AND mii.client_id=126 WHERE miig.group_id= mc.group_id AND mii.size_group='LRG'GROUP BY mii.client_id) AS SellDelivery_, (SELECT mii.PLU FROM menu_item_groups miig LEFT JOIN menu_items mii ON mii.PLU = miig.PLU AND mii.client_id=126 WHERE miig.group_id= mc.group_id AND mii.size_group='LRG' GROUP BY mii.client_id) AS PLU_ FROM menu_items_client mc LEFT JOIN menu_items mi ON (mi.PLU=mc.PLU OR mc.PLU IS null) AND mi.client_id=126 LEFT JOIN item_groups ig ON ig.id=mc.group_id OR ig.id IS null LEFT JOIN menu m ON mc.menu_id = m.menu_id AND m.client_id=126 LEFT JOIN media_library ml ON ml.media_id=mi.image_id LEFT JOIN client_accounts ca ON ca.client_id = mc.client_id WHERE mc.menu_id= AND mc.client_id=126 AND mi.disable_half_half!=1 ORDER BY mc.list_order ASC

Half Half

TOTAL:
1st Half
    2nd Half