• 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='21719' OR e.Section='12613' OR e.Section='6506')) OR ((e.Section='21719' OR e.Section='12613' OR e.Section='6506') AND e.Site IS NULL) OR (e.Class='17938' AND e.Object='0') OR (e.Class='17938' 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=21719), 1) AND IF(d.RubricIDs <> '' AND d.RubricIDs <> '-', (d.RubricIDs REGEXP '((^|,)21719(,|$))' OR d.RubricIDs REGEXP '((^|,)12613(,|$))'), 1) AND f.Message_ID=d.Script AND f.TimeZone13=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: Table './mbtg/Banner_CampaignBanner' is marked as crashed and should be repaired

  • russian version Russian version

For example: delivery

Optimal solutions for growing & managing your business

Laundry Equipment Sales & Service

Total results: 17 companies found.

Address: 125284, Begovoy proezd, 8
Phone: (499) 946-0707, 946-0617
Fax: (499) 946-0210
URL: www.sbmash.ru
Показать на карте
On map

Categories: Dry Cleaning Equipment Sales & Service, Laundry Equipment Sales & Service

Address: 123290, Magistralnaya 2-ya ul., 14G, str. 1
Phone: (495) 730-5927
E-mail: info@lisichka.ru
URL: www.lisichka.ru
Показать на карте
On map

Categories: Laundry Equipment Sales & Service

Pages: 1 | 2