Banners della Querystring - TotBanners:10

QSSearch=%-%-%-%-%|%-%-%|%-%-% - QSLevel=1

Banners della Propagazione - TotBanners:SELECT banners.IDBanner, RIF_IDUtente, Tipo, Formato, Titolo, Corpo, contenuto, DataAssegnazione, IDIstanza, bi.Sottotitolo, bi.Querystring, (FIND_IN_SET('*',CONCAT(REPLACE(SUBSTRING_INDEX(bi.Querystring, '|', 1),'-',','),',*'))-1) QSLevel, IF(SUBSTRING_INDEX(SUBSTRING_INDEX(bi.Querystring, '-', 1),'-',-1)='*',0,1) QSPriority FROM banners JOIN banners_istanze bi ON banners.IDBanner=bi.IDBanner WHERE bi.Abilitato='1' AND banners.Formato=0 AND bi.Scadenza>NOW() AND bi.querystring LIKE '%-%-*-*-*|%|%' ORDER BY QSPriority ASC, QSLevel ASC, RAND()

5

Banners del Ripescaggio - TotBanners:SELECT bi.IDIstanza IDIstanza, banners.IDBanner IDBanner, Titolo, Corpo, Tipo, Formato, bi.Sottotitolo, bi.querystring, (IF(bi.querystring LIKE '*%',2,3)+ IF(bi.querystring LIKE '%|*-*-*|%',1,2) + IF(bi.querystring LIKE '%|%-%-%|%',1,2) + IF(bi.querystring LIKE '%-%-%-%-%|%|%',1,2))*TRUNCATE(LOG((Impressions DIV 1000 +1)),2) priority FROM banners JOIN banners_istanze bi ON banners.IDBanner=bi.IDBanner LEFT JOIN banners_counters ON bi.IDIstanza=banners_counters.IDIstanza WHERE bi.Abilitato='1' AND banners.Tipo=0 AND banners.Formato=0 AND bi.Scadenza>NOW() ORDER BY priority ASC, RAND()

0