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 2010,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) <= 1764169887 AND UNIX_TIMESTAMP(ends_on) >= 1764169887 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) <= 1764169887 AND UNIX_TIMESTAMP(ends_on) >= 1764169887 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) <= 1764169887 AND UNIX_TIMESTAMP(ends_on) >= 1764169887 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) <= 1764169887 AND UNIX_TIMESTAMP(ends_on) >= 1764169887 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    
Michael Hess

Today, almost everything we use is driven by technology. This includes your hotel's waste management program: Enter the smart waste compactor. The goal of a compactor is to condense waste to optimize the space for everyday trash disposal. A smart waste compactor takes this the next level and delivers a real-time, cloud-based dashboard to give you the insights about your compactor you need to better understand your hotel's waste usage. We wanted to give you a rundown of the key benefits of a smart waste compactor on your hotel and how it can make your hotel's waste management program smarter. READ MORE

Gerardo Solaro del Borgo

Over the past decades, we have seen how significant our impact on nature can be and the long-term consequences that imply. Leisure and business tourism move millions of people every year, and taking initiatives to protect nature should be a main priority for all hospitality companies around the globe. Taking care of the environment through a green-building approach, implementing new systems to preserve and recycle water resources and developing a biomass power plant to provide green energy are just a few activities that Toscana Resort Castelfalfi has undertaken to preserve the pristine nature that surrounds it and to ensure guests' wellbeing. READ MORE

Andrew Nielsen

Inspired by the location's rich history, embracing today's prevailing trends, and with a steady eye toward the future, Current doesn't suffer the effects of time. Every element of Tampa's new Marriott Autograph Collection hotel on Rocky Point is steeped in intention, from the location, architecture, art gallery, and dining options, to the guest rooms – each one specifically designated to make sure it maintains an ocean view. The hotel stimulates all of the senses, and the excitement of something new is right around the corner. Offerings remain fresh with ever-changing menus at Julian and Rox, and a curated art gallery with rotating exhibits. In this way, Current travelers and visitors are always offered a unique taste of Tampa Bay. READ MORE

Keiko Sutton

The women of today have begun to shift public opinion on who is able to travel alone-studies have shown that accommodations booked by female lone travelers has increased by 45 percent in recent years. As women continue to venture out into the world for solo travel experiences, safety precautions remain a major concern. Throughout Japan, this issue has been remedied by women-centric travel and experiential accommodations. Taking women's comfort into consideration, sleep capsules are being utilized in hotels that exclusively serve women or offer the option of gender specific floors, offering women necessary privacy and safety in their own spaces. READ MORE

Greg Pesik

The management of groups, especially small groups and meetings, is at an inflection point in the industry. The industry has long relied on antiquated methods, such as room lists, as a core component of that management process. However, room lists are just symptomatic of a non-guest, non-planner centric approach to the process. The industry is not only poised for change, but must change to meet the demands of the digital age. READ MORE

Coming up in March 1970...

Click here to Subscribe






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