| Query: | SELECT `T1`.*, `T4`.`Path`, `T4`.`Parent_ID`, `T4`.`Type` AS `Listing_type`, `T4`.`Key` AS `Cat_key`, `T4`.`Parent_keys`, `T4`.`Parent_IDs` FROM `fl_listings` AS `T1` LEFT JOIN `fl_categories` AS `T4` ON `T1`.`Category_ID` = `T4`.`ID` WHERE `T1`.`Featured_date` <> '0000-00-00 00:00:00' AND `T1`.`Status` = 'active' AND `T4`.`Type` = 'listings' AND `T1`.`citizenship` = 'countries_saint_vincent_and_the_grenadines' AND `T1`.`country` = 'countries_saint_vincent_and_the_grenadines' ORDER BY `Last_show` ASC LIMIT 0, 4 |