Архив по годам:
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='1' AND e.Section IS NULL) OR (e.Site='1' AND (e.Section='366' )) OR ((e.Section='366' ) AND e.Site IS NULL) OR (e.Class='240' AND e.Object='0') OR (e.Class='240' 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.TimeZone6=1
AND
f.Day7=1
AND
(
(
(
i.Site!='1'
OR
i.Site IS NULL
)
AND
i.Section IS NULL
AND
i.Class IS NULL
AND
i.Object IS NULL
)
OR
(
(
i.Section!='366'
OR
i.Section IS NULL
)
AND
i.Class IS NULL
AND
i.Object IS NULL
)
OR
(
i.Class!='240'
AND
i.Object IS NULL
)
OR
(
i.Class IS NULL
AND
i.Object!='0'
)
OR
(
i.Object!='0'
OR
(
i.Class!='240'
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'
2006; 2007;
|
