Moscow Business Telephone Guide - B to B yellow pages directory, addresses and telephone numbers of Moscow companies. Contact information of leading companies in the market of corporate products and services. Best solutions to grow and manage your business.
Last Updated:Query: SELECT a.Banner_ID,
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
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,
<= IF (c.Shows IS NOT NULL,
AND a.Campaign_ID=c.Message_ID AND b.Zone_ID='12'
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.TimeZone20=1
ORDER BY RAND()
Error: Table './mbtg/Banner_CampaignBanner' is marked as crashed and should be repaired 15.09.2014
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.