| Query: | SELECT `T1`.*, `T2`.`Type` AS `Listing_type`, `T2`.`Key` AS `Cat_key`, `T2`.`Type` AS `Cat_type`,`T2`.`Path` AS `Cat_path`, `T2`.`Parent_keys`, `T2`.`Parent_IDs`, `T2`.`Parent_ID`, `T2`.`Path`, `T3`.`Image`, `T3`.`Image_unlim`, `T3`.`Video`, `T3`.`Video_unlim`, CONCAT('categories+name+', `T2`.`Key`) AS `Category_pName`, IF ( UNIX_TIMESTAMP(DATE_ADD(`T1`.`Pay_date`, INTERVAL `T3`.`Listing_period` DAY)) <= UNIX_TIMESTAMP(NOW()) AND `T3`.`Listing_period` > 0, 1, 0) AS `Listing_expired` FROM `fl_listings` AS `T1` LEFT JOIN `fl_categories` AS `T2` ON `T1`.`Category_ID` = `T2`.`ID` LEFT JOIN `fl_listing_plans` AS `T3` ON `T1`.`Plan_ID` = `T3`.`ID` LEFT JOIN `fl_accounts` AS `T5` ON `T1`.`Account_ID` = `T5`.`ID` WHERE `T1`.`ID` = '78318' AND `T2`.`Status` = 'active' AND `T5`.`Status` = 'active' LIMIT 1 |