SELECT
carliner_data.id,
carliner_data.title,
carliner_data.description,
carliner_data.name,
carliner_data.email,
carliner_data.phone,
carliner_data.url,
carliner_data.date,
carliner_data.cat,
carliner_data.city,
carliner_data.photo,
carliner_data.price,
carliner_data.currency,
carliner_data.pred,
carliner_data.period,
carliner_data.type,
carliner_data.count,
carliner_data.ip,
carliner_data.action,
carliner_data.exp_date,
carliner_data.sel_exp_date,
carliner_data.top_exp_date,
carliner_data.date

FROM `carliner_data` where `action` = '1' ORDER BY `date` desc limit 50