SELECT deals.id, products.name as product, deals_tmp.geo, deals.department, DATE(deals.created_at), deals.usd_summary, deals_tmp.ad_url, deals_tmp.extention, deals_tmp.cost_item, deals_tmp.about FROM `deals` LEFT JOIN `deals_tmp` ON `deals`.`id` = `deals_tmp`.`deal_id` LEFT JOIN `partners` ON `partners`.`id` = `deals`.`partner_id` LEFT JOIN `products` ON `products`.`id` = `partners`.`product_id` ORDER BY `deals`.`id` DESC