Error
  • Unknown column 'a.title_alias' in 'field list' SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM t4fbx_content AS a LEFT JOIN t4fbx_categories AS c ON c.id = a.catid LEFT JOIN t4fbx_users AS ua ON ua.id = a.created_by LEFT JOIN t4fbx_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM t4fbx_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN t4fbx_categories as parent ON parent.id = c.parent_id LEFT JOIN t4fbx_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM t4fbx_categories AS cat JOIN t4fbx_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN t4fbx_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,5) AND c.access IN (1,1,5) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2016-05-25 22:35:03') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-05-25 22:35:03') GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY c.lft, a.featured DESC, fp.ordering, a.created DESC LIMIT 0, 4 Unknown column 'a.title_alias' in 'field list' SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM t4fbx_content AS a LEFT JOIN t4fbx_categories AS c ON c.id = a.catid LEFT JOIN t4fbx_users AS ua ON ua.id = a.created_by LEFT JOIN t4fbx_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM t4fbx_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN t4fbx_categories as parent ON parent.id = c.parent_id LEFT JOIN t4fbx_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM t4fbx_categories AS cat JOIN t4fbx_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN t4fbx_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,5) AND c.access IN (1,1,5) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2016-05-25 22:35:03') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-05-25 22:35:03') GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY c.lft, a.featured DESC, fp.ordering, a.created DESC
Wed, May 25, 2016
Twitter Facebook
  • Slideshow 6
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6

Midfield Concession Enterprises, Inc. (MCE) is a premier food and beverage service organization capable of delivering world-class, quality food, management and customer service to any destination.  MCE is woman-owned and ACDBE certified offering a wide range of experience and restaurant options.

Our hands-on approach allows our management team to direct all facets of your food and beverage service requirements.  From innovative designs to menu planning to staff training, you can rely on the wealth of knowledge and national prominence that MCE brings to the table.

MCE’s award winning brands and concepts continue to set standards and raises the bar in an airport setting.  MCE believes in change and for years has proven that the company has the foresight to pave the way for concession programs that provide travelers with a “WOW” experience rather than just a product.  MCE’s commitment to enhancing the experience of the airport traveler is reflected in its extensive customer service training, high quality brands and the contemporary, appealing design that can only be produced by an industry leader of this caliber.

Customer Service

Customer service is at the forefront of every MCE operation.  Our staff is put through detailed training procedures to ensure our customers receive the finest service they will ever experience in a traveling environment.

Learn More

Highest Quality

MCE is exceptionally proud of our commitment to only the freshest, healthiest and highest quality food. 

Learn More

Innovative Design

At Midfield Concession Enterprises, we understand that innovative design is also essential in setting your dining environment apart from the others.

Learn More