string(605) " SELECT a.ID, currency, b.name, type, latin_title, c.date, GROUP_CONCAT(c.date_end ORDER BY c.date ASC SEPARATOR ',') as dates_end, GROUP_CONCAT(c.price ORDER BY c.date ASC SEPARATOR ',') as prices FROM (offers a, offer_ad_pos) LEFT JOIN offers_info b ON a.ID = b.ID LEFT JOIN offers_start_dates as c ON a.ID = c.offer_id WHERE active='1' AND offer_ad_pos.pos_active = 1 AND offer_ad_pos.pos_type = 1 AND a.ID = offer_ad_pos.pos_offer GROUP BY a.ID ORDER BY c.date DESC, a.adddata DESC LIMIT 0, 9 " string(112) "Disk full (/tmp/#sql_3ae_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")" string(824) " SELECT o.ID, o.pic, o.ID, oi.name, o.currency, nights, transport, latin_title, o.type, GROUP_CONCAT(osd.date_end ORDER BY osd.date ASC SEPARATOR ',') as dates_end, GROUP_CONCAT(osd.price ORDER BY osd.date ASC SEPARATOR ',') as prices, od.* FROM offers AS o LEFT JOIN offer_ad_pos AS oap ON (oap.pos_offer = o.ID) LEFT JOIN offer_ad_pos AS oap2 ON (oap2.pos_offer = o.ID) INNER JOIN offers_info AS oi ON (oi.ID = o.ID) INNER JOIN offers_start_dates AS osd ON (o.ID = osd.offer_id) LEFT JOIN offers_destinations AS od ON (o.ID = od.offer_id) WHERE o.active = '1' AND od.state != 0 AND od.town != 0 AND od.order_num != 0 AND oap.pos_active = 1 AND (oap.pos_type = 4 OR oap.pos_type = 5) GROUP BY o.ID " string(112) "Disk full (/tmp/#sql_3ae_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")"
Топ оферти

Оферти - Дубай (ОАЕ)

ЗАРЕЖДАНЕ...




КАТЕГОРИИ
string(324) " SELECT name_en, filter_exkurzii.title, COUNT(*) AS cnt FROM filter_exkurzii INNER JOIN states ON states.ID = fstate INNER JOIN offers ON offers.state = fstate WHERE sh = 'Y' AND offers.type = 0 AND offers.active = 1 GROUP BY filter_id ORDER BY title ASC LIMIT 28 " string(112) "Disk full (/tmp/#sql_3ae_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")" string(322) " SELECT name_en, filter_vakancii.title, COUNT(*) AS cnt FROM filter_vakancii INNER JOIN states ON states.ID = fstate INNER JOIN offers ON offers.state = fstate WHERE sh='Y' AND offers.type = 1 AND offers.active = 1 GROUP BY filter_id ORDER BY title ASC LIMIT 28 " string(112) "Disk full (/tmp/#sql_3ae_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")"