SELECT xyz.*,fk_categories.name AS category, fk_categories.name AS fk_category,fk_categories.seo_url AS category_seo_url,fk_categories.seo_url AS fk_category_seo_url,authors.profile_image_path AS author_image,authors.title AS author_title,authors.company AS author_company,CONCAT(authors.first_name, ' ', authors.last_name) AS author_name,brstatus.name AS status FROM business_review AS xyz LEFT JOIN business_review_categories AS fk_categories ON xyz.fk_category_id = fk_categories.category_id LEFT JOIN authors ON xyz.fk_author_id = authors.author_id LEFT JOIN business_review_status AS brstatus ON xyz.fk_status_id = brstatus.status_id WHERE xyz.fk_status_id IN (1,2,3,4,8) AND xyz.date_of_release<'2025-11-26 00:00:00' ORDER BY xyz.date_of_release DESC LIMIT 2100,5

SELECT xyz.*,CONCAT(xyz.first_name, ' ', xyz.last_name) AS name,authors_status.name AS status,categories.name AS category_name FROM authors AS xyz LEFT JOIN authors_status ON authors_status.status_id = xyz.fk_status_id LEFT JOIN business_review_categories AS categories ON xyz.fk_category_id = categories.category_id WHERE fk_status_id IN (1, 2, 6, 5) ORDER BY first_name, last_name LIMIT 0,100000

SELECT xyz.* FROM business_review_categories AS xyz WHERE xyz.status = 1 ORDER BY name ASC LIMIT 0,100

SELECT xyz.* FROM business_review_categories AS xyz WHERE xyz.status = 1 ORDER BY name ASC LIMIT 0,100

SELECT xyz.* FROM video_spotlight AS xyz WHERE type = 2 AND status = 1 ORDER BY RAND() LIMIT 0,1

SELECT xyz.*,banner_types.name AS type,banners_status.name AS status FROM banners AS xyz LEFT JOIN banner_types ON xyz.fk_type_id = banner_types.id LEFT JOIN banners_status ON xyz.fk_status_id = banners_status.id WHERE fk_type_id IN (6) AND fk_status_id = 1 AND UNIX_TIMESTAMP(starts_on) <= 1764168566 AND UNIX_TIMESTAMP(ends_on) >= 1764168566 ORDER BY id LIMIT 0,15

SELECT xyz.*,banner_types.name AS type,banners_status.name AS status FROM banners AS xyz LEFT JOIN banner_types ON xyz.fk_type_id = banner_types.id LEFT JOIN banners_status ON xyz.fk_status_id = banners_status.id WHERE fk_type_id IN (9) AND fk_status_id = 1 AND UNIX_TIMESTAMP(starts_on) <= 1764168566 AND UNIX_TIMESTAMP(ends_on) >= 1764168566 ORDER BY id LIMIT 0,15

SELECT xyz.*,banner_types.name AS type,banners_status.name AS status FROM banners AS xyz LEFT JOIN banner_types ON xyz.fk_type_id = banner_types.id LEFT JOIN banners_status ON xyz.fk_status_id = banners_status.id WHERE fk_type_id = 4 AND fk_status_id = 1 AND DATE(NOW()) >= starts_on AND DATE(NOW()) <= ends_on ORDER BY RAND() LIMIT 0,15

SELECT xyz.*,banner_types.name AS type,banners_status.name AS status FROM banners AS xyz LEFT JOIN banner_types ON xyz.fk_type_id = banner_types.id LEFT JOIN banners_status ON xyz.fk_status_id = banners_status.id WHERE fk_type_id IN (11) AND fk_status_id = 1 AND DATE(NOW()) >= starts_on AND DATE(NOW()) <= ends_on ORDER BY RAND() LIMIT 0,15

SELECT xyz.*,banner_types.name AS type,banners_status.name AS status FROM banners AS xyz LEFT JOIN banner_types ON xyz.fk_type_id = banner_types.id LEFT JOIN banners_status ON xyz.fk_status_id = banners_status.id WHERE fk_type_id = 3 AND fk_status_id = 1 AND DATE(NOW()) >= starts_on AND DATE(NOW()) <= ends_on ORDER BY RAND() LIMIT 0,15

SELECT xyz.*,banner_types.name AS type,banners_status.name AS status FROM banners AS xyz LEFT JOIN banner_types ON xyz.fk_type_id = banner_types.id LEFT JOIN banners_status ON xyz.fk_status_id = banners_status.id WHERE fk_type_id IN (1) AND fk_status_id = 1 AND DATE(NOW()) >= starts_on AND DATE(NOW()) <= ends_on ORDER BY RAND() LIMIT 0,15

SELECT xyz.*,banner_types.name AS type,banners_status.name AS status FROM banners AS xyz LEFT JOIN banner_types ON xyz.fk_type_id = banner_types.id LEFT JOIN banners_status ON xyz.fk_status_id = banners_status.id WHERE fk_type_id IN (15) AND fk_status_id = 1 AND UNIX_TIMESTAMP(starts_on) <= 1764168566 AND UNIX_TIMESTAMP(ends_on) >= 1764168566 ORDER BY id LIMIT 0,15

SELECT xyz.*,banner_types.name AS type,banners_status.name AS status FROM banners AS xyz LEFT JOIN banner_types ON xyz.fk_type_id = banner_types.id LEFT JOIN banners_status ON xyz.fk_status_id = banners_status.id WHERE fk_type_id IN (11) AND fk_status_id = 1 AND UNIX_TIMESTAMP(starts_on) <= 1764168566 AND UNIX_TIMESTAMP(ends_on) >= 1764168566 ORDER BY id LIMIT 0,15

HOTEL EXECUTIVE
☰
✕

HOTEL BUSINESS REVIEW

LIBRARY ARCHIVES : Search for articles here

 
Search articles by Topic
Search articles by Author    
Search Authors by Topic    
Search articles by Keyword    
Steve Cohen

Artificial intelligence will never replace the warmth and welcome of personal interaction; however, in the hospitality industry, it can be an effective tool to enhance the guest experience. AI can help smooth out touchpoints and anticipate guests' needs. While the guest is at the center of any hotel or resort experience, AI can also benefit brands with back-of-house efficiencies like improving supply chain, staffing, scheduling and more. Used correctly, AI has the potential to vastly improve the hotel guest experience. It is a tool that can make hospitality brands more profitable, but only as a complement to the human touch. READ MORE

Marcela Trujillo

Revenue management and marketing can seem like two different worlds. Different in many respects, many revenue and marketing teams operate without true cooperation. In this article, Marcela Trujillo with Total Customized Revenue Management (TCRM) explores the similarities and differences between revenue and marketing teams, uncovers the potential of a partnership between the two disciplines and explains how a collaboration can work to attract the perfect customer - one who will not just stay at the hotel or resort, but will also spend within the property and increase total asset revenue. READ MORE

Adria Levtchenko

Labor costs are a significant portion of any hotel's total operating costs. At the same time, hotel property management companies are competing with other service industries to find enough qualified (and affordable) entry-level and experienced candidates. No one wants to lower service levels or possibly negatively impact guest satisfaction. The solution applies in applying new technologies that can enhance worker productivity, job satisfaction and the overall hotel experience. This article discusses how today's best hotel task optimization software platforms can accomplish these goals and make a positive contribution to a hotel's bottom line. READ MORE

Rani Gharbie

The Pod Hotels will be expanding from five to fifty properties over the next decade across North America and, eventually, globally. BD Hotels has appointed Rani Gharbie as Head of Acquisitions & Development to lead this robust expansion plan to key markets such as San Francisco, Miami, Austin, Boston, Nashville, Seattle, Toronto, and Mexico City. The Pod Hotels portfolio includes New York-based Pod Times Square, Pod 51, Pod 39 and Pod Brooklyn, as well as Pod Washington D.C. with two more hotels in the direct pipeline - Pod Philly and Pod LA. In addition, there are over ten ongoing discussions for new deals. READ MORE

S. Lakshmi Narasimhan

What is the way forward? The future is indeed bright for mixed use projects. Buoyed by a young, sophisticated, urban demand base (millennials and Gen Z) which is willing to fork out big bucks if unique, personalized experiences are delivered, stake holders have been falling over themselves to jump on to this bandwagon which has long term implications for their return on investment. On the one side constant innovation keeps the demand fertile and on the other, intelligent pricing keeps the bottom line thriving and happy. This is a heady cocktail that no self-respecting stakeholder will be willing to pass up. READ MORE

Coming up in March 1970...

Click here to Subscribe






Copyright © 1996-2025. All content on HotelExecutive.com. All Rights Reserved.