| Query: | SELECT COUNT(`T1`.`ID`) AS `Count` FROM `fl_listings` AS `T1` LEFT JOIN `fl_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` LEFT JOIN `fl_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` WHERE (`T1`.`Category_ID` = '1742' OR FIND_IN_SET('1742', `Crossed`) > 0 OR FIND_IN_SET('1742', `T3`.`Parent_IDs`) > 0 ) AND `T1`.`Status` = 'active' AND (UNIX_TIMESTAMP(DATE_ADD(`T1`.`Pay_date`, INTERVAL `T2`.`Listing_period` DAY)) > UNIX_TIMESTAMP(NOW()) OR `T2`.`Listing_period` = 0) AND `T1`.`citizenship` = 'countries_saint_vincent_and_the_grenadines' AND `T1`.`country` = 'countries_saint_vincent_and_the_grenadines' LIMIT 1 |