|
| ОСДП АЗАТ / Қызметі / Бастамалар мен заңжобалары |
 |
| Бастамалар мен заңжобалары |
|
Архив по годам:
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, Message30 AS c, Message28 as d, Message29 AS e, Message32 AS f, Field AS g LEFT JOIN Classificator_BannerSize AS h ON h.BannerSize_ID=d.Size LEFT JOIN Message31 AS i ON f.Message_ID=i.Script 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 c.Message_ID=2 AND b.Zone_ID='1' AND b.Zone_ID=e.Message_ID AND ((e.Site='3' AND e.Section IS NULL) OR (e.Site='3' AND (e.Section='434' OR e.Section='419')) OR ((e.Section='434' OR e.Section='419') AND e.Site IS NULL) OR (e.Class='300' AND e.Object='0') OR (e.Class='300' 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 f.Message_ID=d.Script AND
f.TimeZone5=1
AND
f.Day7=1
AND
(
(
(
i.Site!='3'
OR
i.Site IS NULL
)
AND
i.Section IS NULL
AND
i.Class IS NULL
AND
i.Object IS NULL
)
OR
(
(
i.Section!='434'
OR
i.Section IS NULL
)
AND
i.Class IS NULL
AND
i.Object IS NULL
)
OR
(
i.Class!='300'
AND
i.Object IS NULL
)
OR
(
i.Class IS NULL
AND
i.Object!='0'
)
OR
(
i.Object!='0'
OR
(
i.Class!='300'
AND
i.Object IS NOT NULL
)
)
OR
(
i.Site IS NULL
AND
i.Section IS NULL
AND
i.Class IS NULL
AND
i.Object IS NULL
)
) AND g.Class_ID=28 AND g.TypeOfData_ID=6 AND g.Field_Name='File' ORDER BY RAND() LIMIT 1
Error: Unknown column 'd.Size' in 'on clause'
|
|
