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 15,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) <= 1764169834 AND UNIX_TIMESTAMP(ends_on) >= 1764169834 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) <= 1764169834 AND UNIX_TIMESTAMP(ends_on) >= 1764169834 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) <= 1764169834 AND UNIX_TIMESTAMP(ends_on) >= 1764169834 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) <= 1764169834 AND UNIX_TIMESTAMP(ends_on) >= 1764169834 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    
Fred Ho

In an increasingly competitive hospitality landscape, hotel partnerships have evolved from simple cross-promotions into sophisticated, multi-channel collaborations that can drive revenue, elevate guest experience, and amplify brand visibility. The right partnership can serve as a powerful lever for growth. But to truly maximize the impact of these collaborations, hoteliers must approach partnerships with strategic intent, operational clarity, and a shared vision for success. READ MORE

Richard Halsall

Thermal de-stratification is a cost-effective HVAC strategy for environmentally-conscious hotels, addressing vertical temperature layering that wastes energy, reduces comfort, and increases maintenance. By gently mixing air with fans or vents, it improves heating and cooling efficiency, enhances guest comfort, lowers energy use, extends equipment life, and complements other green technologies. Payback is rapid, making it a high-impact, low-disruption retrofit. READ MORE

Lori Cohen

Human trafficking is a crime that can affect anyone regardless of sex, race, or origin. A widespread misconception is that trafficking only happens overseas, but it is occurring in cities, suburbs and rural communities throughout all 50 states. Hospitality team members, from front desk to housekeeping, are uniquely positioned to observe, identify, and safely report potential instances of trafficking. READ MORE

Robert O'Halloran

No one can do it all by themselves. There is strength in a team and the ability to share responsibility and trust with others can create an optimal service environment. The hospitality industry needs good teams that can focus on getting the job done and working towards a collective goal. This article will discuss team building and teamwork to provide great guest experiences. READ MORE

Jeff Baldwin

Legionella infection is a very real risk throughout the hotel and hospitality industry. In this article T&S Brass' Director of Engineering Jeff Baldwin explains why your fittings may be the weak link in your water safety plan and how smarter fixture design can help safeguard your guests and employees. READ MORE

1 2 3 4 5 6 ... 1352
Coming up in March 1970...

Click here to Subscribe






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