• ФОРМУЛА КРАСОТЫ
  • Last Updated:
    Query: SELECT a.Banner_ID, a.Campaign_ID, d.Type, h.BannerSize_Name, d.File, d.Alt, d.Text, g.Field_ID, d.NewWindow FROM (Banner_CampaignBanner AS a, Banner_CampaignZone AS b, Message74 AS c, Message73 as d, Message70 AS e, Message71 AS f, Field AS g) LEFT JOIN Classificator_BannerSize AS h ON h.BannerSize_ID=d.Size WHERE ((c.Start <= IF(c.Start IS NOT NULL, NOW(), 0) AND c.Stop > IF(c.Stop IS NOT NULL, NOW(), 0)) AND IF (c.Shows IS NOT NULL, (c.Showed+1), 0) <= IF (c.Shows IS NOT NULL, c.Shows, 0)) AND a.Campaign_ID=b.Campaign_ID AND c.Checked=1 AND a.Campaign_ID=c.Message_ID AND b.Zone_ID='12' AND b.Zone_ID=e.Message_ID AND ((e.Site='2' AND e.Section IS NULL) OR (e.Site='2' AND (e.Section='22449' OR e.Section='12669' OR e.Section='6506')) OR ((e.Section='22449' OR e.Section='12669' OR e.Section='6506') AND e.Site IS NULL) OR (e.Class='18671' AND e.Object='0') OR (e.Class='18671' AND e.Object IS NULL)) AND f.Message_ID = d.Script AND d.Status=1 AND d.Checked=1 AND c.Size=d.Size AND d.Size=e.Size AND a.Banner_ID=d.Message_ID AND IF(d.OnlyThisSub <> 0, (d.OnlyThisSub=22449), 1) AND IF(d.RubricIDs <> '' AND d.RubricIDs <> '-', (d.RubricIDs REGEXP '((^|,)22449(,|$))' OR d.RubricIDs REGEXP '((^|,)12669(,|$))'), 1) AND f.Message_ID=d.Script AND f.TimeZone16=1 AND f.Day1=1 AND g.Class_ID=73 AND g.TypeOfData_ID=6 AND g.Field_Name='File' ORDER BY RAND() LIMIT 1

    Error: Got error 28 from storage engine

    01.09.2014
  • russian version Russian version

For example: delivery

Optimal solutions for growing & managing your business


IWM

Travel Agencies

Total results: 687 companies found.

Address: 129164, Yaroslavskaya ul., 8, k. 5
Phone: (495) 933-5577, 775-0005
Fax: (495) 933-5561
URL: www.msk.ntk-intourist.ru
Показать на карте
On map

Categories: Travel Agencies



Address: 129085, Zvezdny bulv., 19
Phone: (495) 232-3377
Fax: (495) 616-9747
E-mail: info@office-travel.ru
URL: www.office-travel.ru
www.tez.ru
Показать на карте
On map

Categories: Travel Agencies

Address: 107014, Sokolnicheskaya pl., 4A, ofis 302
Phone: (495) 926-4365
Fax: (495) 926-4365
E-mail: ok-tour@ok-tour.info
URL: www.ok-tour.info
Показать на карте
On map

Categories: Airline Ticket Agencies, Travel Agencies

Address: 101000, Kolpachny per., 6, str. 5
Phone: (495) 721-0213, 221-3683, 968-7424
Fax: (495) 221-3683
E-mail: oliuss514@mail.ru
URL: www.oliuss.ru
Показать на карте
On map

Categories: Airline Ticket Agencies, Travel Agencies

Address: 121069, Nikitskaya B. ul., 50A/5, str. 1
Phone: (495) 697-9367, 695-8358, 691-6301, 797-2688, 691-7990
Fax: (495) 691-6301, 695-8358, 691-7990, 797-2688
E-mail: travel@olr.ru
URL: www.olr.ru
www.germanwings.com
Показать на карте
On map

Categories: Airline Ticket Agencies, Travel Agencies

Address: 101000, Maroseyka ul., 6-8, str. 1, ofis 26
Phone: (495) 628-2093, 624-7011, 621-0069
Fax: (495) 628-2093, 624-7011, 621-0069
E-mail: olympic@orc.ru
URL: www.olympicts.ru
www.aviakasa.ru
Показать на карте
On map

Categories: Travel Agencies

Address: 107078, Haritonevski B. per., 16-18, ofis 1
Phone: (495) 628-9254
E-mail: krv@mgp.ru
URL: www.mgp.ru
Показать на карте
On map

Categories: Travel Agencies

Address: 127051, Tsvetnoy bulv., 21, str. 6
Phone: (495) 740-7744
Fax: (495) 740-7744
E-mail: info@onlinevoyage.ru
URL: www.onlinevoyage.ru
Показать на карте
On map

Categories: Travel Agencies

Address: 127051, Petrovka ul., 26, str. 6
Phone: (495) 727-1753
Fax: (495) 727-1753
E-mail: info@oostmarkt.ru
URL: www.oostmarkt.ru
Показать на карте
On map

Categories: Travel Agencies

Address: 119180, Yakimanka B. ul., 31, ofis 218
Phone: (495) 505-6325
Fax: (495) 649-8328
E-mail: moscow@optimatours.ru
URL: www.optimatours.ru
Показать на карте
On map

Categories: Hotel Reservations in Russia & Abroad, Travel Agencies

Address: 119002, Arbat ul., 35, ofis 314
Phone: (499) 241-0828, 248-5322
Fax: (499) 241-0828
E-mail: o@oreand.ru
URL: www.oreand.ru
Показать на карте
On map

Categories: Travel Agencies

Address: 127006, Dmitrovka M. ul., 3, pod'ezd 2, ofis 226
Phone: (495) 506-2306, 778-3830
Fax: (495) 506-2306
E-mail: oreol-tour@yandex.ru
URL: www.oreol-tour.ru
Показать на карте
On map

Categories: Airline Ticket Agencies, Travel Agencies

Address: 125040, Leningradski prosp., 5, str. 2
Phone: (499) 257-0215
Fax: (499) 251-3105
E-mail: belo@orient-tour.ru
URL: www.orient-tour.ru
Показать на карте
On map

Categories: Travel Agencies

Address: 119021, Rossolimo ul., 17, ofis 402
Phone: (495) 783-9851
Fax: (495) 783-9851
E-mail: info@orientaltravel.ru
URL: www.orientaltravel.ru
Показать на карте
On map

Categories: Travel Agencies

Address: 125057, Alabyana ul., 5
Phone: (499) 943-8561, 943-8562, 943-8563
Fax: (499) 198-1101
E-mail: office@cruise.ru
URL: www.cruise.ru
Показать на карте
On map

Categories: Motor Ships, Rental, Travel Agencies

Pages: 1 ... 27 | 28 | 29 | 30 | 31 | 32 ... 46
  • Далюс
  • Классики
  • ТК Паритет Сервис
  • Медэкс