Berria.eus

albistea

Publizitatea

albistea

 

/ Berria

 

Publizitatea

albistea saileko albiste gehiago

(SELECT t1.id,t1.dosierra AS despliege_ID,t1.zintiloa,t1.titularra,t1.data,t1.ordua,t1.ordena AS orria,t1.jarraia AS tamaina,t1.sarrera,t1.testua,t1.egilea,t1.dosierra AS quark_orria,t1.twittergaia AS kategoria FROM edjarraia.jarraia AS t1 WHERE t1.data<=CURDATE() AND t1.id!=23 AND t1.saila='Albistea' AND t1.ordena<6 AND t1.ordena!=4 AND t1.argumentuak='') UNION (SELECT t2.uniqueID AS id,t2.despliege_ID,t2.zintilloa AS zintiloa,t2.titularra,t2.fetxa AS data,'',t2.orria,t2.tamaina,t2.azpititularra AS sarrera,t2.testua,t2.egilea,t2.quark_orria,t2.kategoria FROM publikazioak.albisteak AS t2 WHERE t2.fetxa<=CURDATE() AND t2.uniqueID!=23 AND t2.saila='albistea' AND t2.mota='nagusia' AND t2.produktua='BERRIA' AND t2.zintilloa!='Sailkapenak' AND t2.kategoria!='ESANA') ORDER BY data DESC, ordua DESC, orria ASC, tamaina DESC LIMIT 3

Albiste nagusiak

Gehien irakurriak