• 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='5151' )) OR ((e.Section='5151' ) AND e.Site IS NULL) OR (e.Class='' AND e.Object='0') OR (e.Class='' 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=5151), 1) AND IF(d.RubricIDs <> '' AND d.RubricIDs <> '-', (d.RubricIDs REGEXP '((^|,)5151(,|$))'), 1) AND f.Message_ID=d.Script AND f.TimeZone6=1 AND f.Day2=1 AND g.Class_ID=73 AND g.TypeOfData_ID=6 AND g.Field_Name='File' ORDER BY RAND() LIMIT 1

    Error: Table './mbtg/Banner_CampaignBanner' is marked as crashed and should be repaired

  • russian version Russian version

For example: advertising

Optimal solutions for growing & managing your business

Moscow Business Telephone Guide

Popular categories

Advertising, PR & Marketing

Courier & Postal Services

Finance & Insurance

Food, Corporate Services

Freight Transport & Logistics

Furniture & Interior


Legal Services & Consulting

Office Equipment & Supplies

Passenger Transport

Printing & Design

Real Estate

Recruitment & Employment Services


Tourism & Hotel Services


All categories

Moscow Business Telephone Guide yellow pages type, business directory of the Moscow market leaders. Published since 1992.Periodical printed magazine and Internet edition till July 2011, since August 2011 online format exclusively.

We include information on the top 20% companies accounting for 80% of Moscow economic activity. We publish information about leaders of ratings, the most active advertisers, members of prestigious business associations, participants of major exhibitions and conferences, tenants of class A office and business centers.

This rating tool will help you minimize expenses and increase profits.

Very accurate information.
We are monitoring the market and verify information on a permanent basis, changesthe site is updated every two weeks.Users get unbiased information about the market of the Moscow market leaders.

  Предлагаем на заказ резиновые печати и штампы, изготовление факсимиле. . портативный DVD плеер . Пуше - фабрика мягкой мебели.