SELECT POST_FOTOGALLERY.url, POST_FOTOGALLERY.target_url, POST_FOTOGALLERY.foto, POST_FOTOGALLERY.id, POST_FOTOGALLERY.id_post, POST_FOTOGALLERY_META_TAG.meta_description FROM POST INNER JOIN POST_REL_LINGUA ON POST.id = POST_REL_LINGUA.id_post INNER JOIN POST_FOTOGALLERY ON POST.id = POST_FOTOGALLERY.id_post LEFT OUTER JOIN POST_FOTOGALLERY_META_TAG ON POST_FOTOGALLERY.id = POST_FOTOGALLERY_META_TAG.id_fotogallery where POST.tipo='slider_home' and POST_REL_LINGUA.lingua='en' and POST_FOTOGALLERY.lingua='en' and POST_FOTOGALLERY.visibile=1 and POST.id=689 order by POST_FOTOGALLERY.posizione asc
