SELECT t.*,c.name as club_name,c.info as club_info,c.img1 as club_img1,c.img2 as club_img2 
FROM (
SELECT  t1.advance,t1.remainder,t1.examination,t1.valuation, t1.interval, t1.interval_type, t1.interval_num,t1.bonus_week, t1.apartment,t1.season,t1.date_end,t1.advance_accept,t1.member_type,t1.contract_timelimit,t1.id,t1.date_sell as dt,t1.block_type,t1.price,t1.sum_dog,1 as sellt,t1.club_id,t1.autog,t1.last_change_status,s.name as company_name,s.info as company_info,s.img1 as company_img1,s.img2 as company_img2,s.country as country,company_sell,company_buy,commission_agent
FROM tbl_timeshares_sell t1 , tbl_firms  s
WHERE s.type=2 and (t1.company_sell=s.id and date_sell<UNIX_TIMESTAMP()) and t1.company_sell>0  
ORDER BY last_change_status DESC, t1.date_sell DESC,t1.id DESC) t, tbl_clubs c 
WHERE t.club_id=c.id  and c.id='207' LIMIT 0,49