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_39f_3.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_39f_3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")"
Топ оферти

Лято 2016 - Почивки в чужбина

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




КАТЕГОРИИ
string(548) " SELECT *,towns.name as offers_town_name, states.name AS offers_state_name, towns.ID as ofers_town_id, seasons.name AS vidtitle, short_name FROM `seasons` JOIN offers ON seasons.ID = offers.season JOIN towns ON offers.town=towns.ID JOIN states ON offers.state=states.ID WHERE seasons.name_latin='liato-chujbina' AND offers.active='1' GROUP BY offers_state_name ORDER BY offers_state_name LIMIT 45" string(112) "Disk full (/tmp/#sql_39f_3.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_39f_3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")"