SELECT
	   IF(lang_c1.url IS NOT NULL,CONCAT(lang_c1.url,'/',lang_c2.url,'/',lang_c3.url,'/',lang_n.url),
			IF(lang_c2.url IS NOT NULL,CONCAT(lang_c2.url,'/',lang_c3.url,'/',lang_n.url),
			   IF(lang_c3.url IS NOT NULL,CONCAT(lang_c3.url,'/',lang_n.url),'')
			 )
		) AS url_news,
	   IF(lang_c1.url IS NOT NULL,CONCAT(lang_c1.url,'/',lang_c2.url,'/',lang_c3.url),
			IF(lang_c2.url IS NOT NULL,CONCAT(lang_c2.url,'/',lang_c3.url),
			   IF(lang_c3.url IS NOT NULL,lang_c3.url,'')
			 )
		) AS url_categoria,
	  lang_c3.nome AS nome_categoria,
	  lang_n.url,
	  lang_n.nome,
	  lang_n.descrizione_breve,
	  n.foto,
	  n.id,
	  UNIX_TIMESTAMP(n.data_inizio) AS time_inizio
	FROM
	  shb_db.widget_lancio_news_collegati AS ce
	INNER JOIN
		shb_db.cms_contenuti AS n ON(
		  n.id = ce.contenuto_id 
		   AND ce.riferimento_id = 41
		  )
	INNER JOIN
		shb_db.cms_contenuti_lang AS lang_n ON( 
				n.id = lang_n.riferimento_id AND 
				lang_n.lang = 'it' AND 
				lang_n.attivo = '1' 
				) 
	INNER JOIN
		shb_db.cms_contenuti_e_categorie AS cc ON(n.id = cc.contenuto_id)
	INNER JOIN
		shb_db.cms_categorie AS c3 ON(c3.id = cc.categoria_id)
	INNER JOIN
		shb_db.cms_categorie_lang AS lang_c3 ON(
				c3.id = lang_c3.riferimento_id AND 
				lang_c3.lang = 'it') 
		
	LEFT JOIN
		shb_db.cms_categorie AS c2 ON(c2.id = c3.parent_id)
	LEFT JOIN
		shb_db.cms_categorie_lang AS lang_c2 ON(
				c2.id = lang_c2.riferimento_id AND 
				lang_c2.lang = 'it') 
	LEFT JOIN
		shb_db.cms_categorie AS c1 ON(c1.id = c2.parent_id)
	LEFT JOIN
		shb_db.cms_categorie_lang AS lang_c1 ON(
				c1.id = lang_c1.riferimento_id AND 
				lang_c1.lang = 'it') 
	GROUP BY
	  cc.contenuto_id
	ORDER BY
	  ce.ordinazione ASC, ce.contenuto_id DESC
	LIMIT 4