SELECT count(bid) AS nrows FROM news AS b JOIN news_it AS bt ON bt.btid=b.bid AND bt.bactive=1 JOIN newsmenu AS bm ON bm.bmid=b.brel JOIN newsmenu_it AS bmt ON bmt.bmtid=bm.bmid AND bmt.bmactive=1 WHERE btags LIKE '%,102,%' AND b.bcreationdate <= current_date

News

Articoli relativi alla keyword grandi carnivori