SELECT
    CONCAT(v.capitolo) AS id,
    CONCAT(l.titolo, ' ', v.capitolo) AS titolo,
    GROUP_CONCAT(
        CONCAT('<sup>', v.versetto, '</sup> ', v.testo)
        ORDER BY v.versetto
        SEPARATOR ' '
    ) AS testo
FROM bibbiacei v
JOIN libri l ON l.id = v.libro
WHERE v.libro = 45  and l.lingua ='it'
GROUP BY v.libro, v.capitolo
ORDER BY v.capitolo;


SELECT id,titolo,testo FROM `documentazione` WHERE id BETWEEN 4403 and 4406
 


  <a href="mailto:?subject=App Android {{testoplaystore}}&body={{testoplaystore}} {{linkplaystore}}"><img
                    src="/assets/img/icons/email.png" alt="email"></a>
            <a href="http://www.facebook.com/sharer/sharer.php?u={{linkplaystore}}"><img
                    src="/assets/img/icons/facebook.png" alt="facebook"></a>
            <a href="https://twitter.com/share?url={{linkplaystore}}&text={{testoplaystore}}"><img
                    src="/assets/img/icons/twitter.png" alt="twitter"></a>
            <a href="https://t.me/share/url?url={{testoplaystore}}&text={{linkplaystore}}"><img
                    src="/assets/img/icons/telegram.png" alt="Telegram"></a>
            <a href="https://wa.me/?text={{testoplaystore}} {{linkplaystore}}"><img src="/assets/img/icons/whatsapp.png"
                    alt="Whatsapp"></a>

  
-- per creare i menu se non ci sono
SELECT id,idtxt,categoria, nome FROM `novene` WHERE lingua = 'lt' order by categoria; 

-- lista.json
SELECT id,nome FROM `novene` WHERE lingua = 'it' order by id asc; 
 
-- scarichi tutte le novene una per una
SELECT nt.idn,nt.giorno,n.nome as titolo,nt.testo FROM novene as n, novene_testo as nt where n.id = nt.idn and n.lingua = 'en' order by n.id

-- calendari
SELECT nc.giorno,nc.idn,nc.gn,n.nome FROM novene_cal as nc,novene as n WHERE n.id = nc.idn and n.lingua = 'es' and nc.mese = 1

SELECT nc.idn,nc.gn,nc.idtxt, n.nome FROM novene_cal_anno as nc,novene as n WHERE n.id = nc.idn and n.lingua = 'it'

SELECT giorno,titolo,testo FROM `medi_testo` WHERE idm = 7;

novene da riparare: 102 san gaetano 171 medaglia miracolosa 174 Saverio
greco controlla configurazione
gestire novena volto santo sia ita che lituano
,
  {
    "id": "meditazioni",
    "titleKey": "menu_biblioteca",
    "title": "Meditazioni",
    "route": "/meditazioni/meditazioni",
    "cssClass": "mbutton_base",
    "background": "_gesucristo1.webp",
    "back":""
  }

[
  "11ThSundayOfOrdinaryTime",
  "12ThSundayOfOrdinaryTime",
  "13ThSundayOfOrdinaryTime",
  "14thSundayOfOrdinaryTime",
  "15thSundayOfOrdinaryTime",
  "16thSundayOfOrdinaryTime",
  "17thSundayOfOrdinaryTime",
  "18thSundayOfOrdinaryTime",
  "19thSundayOfOrdinaryTime",
  "1stSundayOfAdvent",
  "1stSundayOfLent",
  "20thSundayOfOrdinaryTime",
  "21stSundayOfOrdinaryTime",
  "22ndSundayOfOrdinaryTime",
  "23rdSundayOfOrdinaryTime",
  "24thSundayOfOrdinaryTime",
  "25thSundayOfOrdinaryTime",
  "26thSundayOfOrdinaryTime",
  "27thSundayOfOrdinaryTime",
  "28thSundayOfOrdinaryTime",
  "29thSundayOfOrdinaryTime",
  "2ndSundayOfAdvent",
  "2ndSundayOfLent",
  "2ndSundayOfOrdinaryTime",
  "30thSundayOfOrdinaryTime",
  "32ndSundayOfOrdinaryTime",
  "33rdSundayOfOrdinaryTime",
  "3rdSundayOfAdvent",
  "3rdSundayOfEaster",
  "3rdSundayOfLent",
  "3rdSundayOfOrdinaryTime",
  "4thSundayOfAdvent",
  "4thSundayOfEaster",
  "4thSundayOfLent",
  "4thSundayOfOrdinaryTime",
  "5thSundayOfEaster",
  "5thSundayOfLent",
  "5thSundayOfOrdinaryTime",
  "6thDayInTheOctaveOfChristmas",
  "6thSundayOfEaster",
  "6thSundayOfOrdinaryTime",
  "7thSundayOfEaster",
  "allSaints",
  "allSouls",
  "annunciation",
  "ascension",
  "ashWednesday",
  "assumption",
  "baptismOfTheLord",
  "birthOfJohnTheBaptist",
  "birthOfTheBlessedVirginMary",
  "christTheKing",
  "christmas",
  "corpusChristi",
  "dedicationOfTheBasilicaOfSaintMaryMajor",
  "dedicationOfTheBasilicasOfSaintsPeterAndPaulApostles",
  "dedicationOfTheLateranBasilica",
  "divineMercySunday",
  "easter",
  "easterFriday",
  "easterMonday",
  "easterSaturday",
  "easterThursday",
  "easterTuesday",
  "easterWednesday",
  "epiphany",
  "firstMartyrsOfTheChurchOfRome",
  "fridayAfterAshWednesday",
  "fridayAfterEpiphany",
  "fridayOfThe12ThWeekOfOrdinaryTime",
  "fridayOfThe14thWeekOfOrdinaryTime",
  "fridayOfThe15thWeekOfOrdinaryTime",
  "fridayOfThe1stWeekOfLent",
  "fridayOfThe1stWeekOfOrdinaryTime",
  "fridayOfThe22ndWeekOfOrdinaryTime",
  "fridayOfThe23rdWeekOfOrdinaryTime",
  "fridayOfThe24thWeekOfOrdinaryTime",
  "fridayOfThe25thWeekOfOrdinaryTime",
  "fridayOfThe2ndWeekOfEaster",
  "fridayOfThe2ndWeekOfLent",
  "fridayOfThe2ndWeekOfOrdinaryTime",
  "fridayOfThe30thWeekOfOrdinaryTime",
  "fridayOfThe31stWeekOfOrdinaryTime",
  "fridayOfThe32ndWeekOfOrdinaryTime",
  "fridayOfThe33rdWeekOfOrdinaryTime",
  "fridayOfThe34thWeekOfOrdinaryTime",
  "fridayOfThe3rdWeekOfAdvent",
  "fridayOfThe3rdWeekOfLent",
  "fridayOfThe3rdWeekOfOrdinaryTime",
  "fridayOfThe4thWeekOfLent",
  "fridayOfThe5thWeekOfEaster",
  "fridayOfThe5thWeekOfLent",
  "fridayOfThe5thWeekOfOrdinaryTime",
  "fridayOfThe6thWeekOfEaster",
  "fridayOfThe8thWeekOfOrdinaryTime",
  "goodFriday",
  "guardianAngels",
  "holyFamily",
  "holyInnocentsMartyrs",
  "holyNameOfTheBlessedVirginMary",
  "holySaturday",
  "holyThursday",
  "immaculateConception",
  "immaculateHeartOfMary",
  "josephHusbandOfMary",
  "maryMotherOfGod",
  "maryMotherOfTheChurch",
  "mondayAfterEpiphany",
  "mondayOfHolyWeek",
  "mondayOfThe10thWeekOfOrdinaryTime",
  "mondayOfThe11ThWeekOfOrdinaryTime",
  "mondayOfThe17thWeekOfOrdinaryTime",
  "mondayOfThe18thWeekOfOrdinaryTime",
  "mondayOfThe1stWeekOfOrdinaryTime",
  "mondayOfThe20thWeekOfOrdinaryTime",
  "mondayOfThe22ndWeekOfOrdinaryTime",
  "mondayOfThe23rdWeekOfOrdinaryTime",
  "mondayOfThe27thWeekOfOrdinaryTime",
  "mondayOfThe28thWeekOfOrdinaryTime",
  "mondayOfThe2ndWeekOfLent",
  "mondayOfThe2ndWeekOfOrdinaryTime",
  "mondayOfThe30thWeekOfOrdinaryTime",
  "mondayOfThe3rdWeekOfEaster",
  "mondayOfThe4thWeekOfEaster",
  "mondayOfThe4thWeekOfLent",
  "mondayOfThe5thWeekOfEaster",
  "mondayOfThe5thWeekOfOrdinaryTime",
  "mondayOfThe6thWeekOfEaster",
  "mondayOfThe6thWeekOfOrdinaryTime",
  "ourLadyOfFatima",
  "ourLadyOfGuadalupe",
  "ourLadyOfLoreto",
  "ourLadyOfLourdes",
  "ourLadyOfMountCarmel",
  "ourLadyOfSorrows",
  "ourLadyOfTheRosary",
  "palmSunday",
  "pentecostSunday",
  "peterAndPaulApostles",
  "popeSaintJohnPaulII",
  "presentationOfTheBlessedVirginMary",
  "presentationOfTheLord",
  "queenshipOfBlessedVirginMary",
  "sacredHeartOfJesus",
  "saintAgathaVirginAndMartyr",
  "saintAgnesVirginAndMartyr",
  "saintAlphonsusMariaDeLiguoriBishopAndDoctorOfTheChurch",
  "saintAmbroseBishopAndDoctor",
  "saintAndrewDungLacAndCompanionsMartyrs",
  "saintAndrewTheApostle",
  "saintAngelaMericiVirgin",
  "saintAnselmOfCanterburyBishopAndDoctorOfTheChurch",
  "saintAnthonyMaryClaretBishop",
  "saintAnthonyOfEgyptAbbot",
  "saintApollinaris",
  "saintAthanasiusBishopAndDoctor",
  "saintAugustineOfCanterburyBishop",
  "saintAugustineOfHippoBishopAndDoctorOfTheChurch",
  "saintBarnabasTheApostle",
  "saintBartholomewTheApostle",
  "saintBenedictOfNursiaAbbot",
  "saintBernardOfClairvauxAbbotAndDoctorOfTheChurch",
  "saintBernardineOfSienaPriest",
  "saintBlaseBishopAndMartyrSaintAnsgarBishop",
  "saintBonaventureBishopAndDoctor",
  "saintBonifaceBishopAndMartyr",
  "saintBridgetOfSwedenReligious",
  "saintBrunoPriest",
  "saintCallistusIPopeAndMartyr",
  "saintCamillusDeLellisPriest",
  "saintCasimir",
  "saintCatherineOfAlexandriaVirginAndMartyr",
  "saintCatherineOfSienaVirginAndDoctorOfTheChurch",
  "saintCharbelMakhloufPriestAndHermit",
  "saintCharlesBorromeoBishop",
  "saintChristopherMagallanesAndCompanionsMartyrs",
  "saintClareVirgin",
  "saintClementIPopeAndMartyrSaintColumbanReligious",
  "saintCyrilOfAlexandriaBishopAndDoctor",
  "saintCyrilOfJerusalemBishopAndDoctor",
  "saintDamasusIPope",
  "saintDenisAndCompanionsMartyrsSaintJohnLeonardiPriest",
  "saintDominicPriest",
  "saintElizabethOfHungary",
  "saintElizabethOfPortugal",
  "saintEphremDeaconAndDoctor",
  "saintFidelisOfSigmaringenPriestAndMartyr",
  "saintFrancesOfRomeReligious",
  "saintFrancisDeSalesBishopAndDoctor",
  "saintFrancisXavierPriest",
  "saintGeorgeMartyrSaintAdalbertBishopAndMartyr",
  "saintGregoryTheGreatPopeAndDoctor",
  "saintHedwigReligiousSaintMargaretMaryAlacoqueVirgin",
  "saintHenryBishopAndMartyr",
  "saintHilaryOfPoitiersBishopAndDoctor",
  "saintIgnatiusOfAntiochBishopAndMartyr",
  "saintIgnatiusOfLoyolaPriest",
  "saintJamesApostle",
  "saintJaneFrancesDeChantalReligious",
  "saintJanuariusBishopAndMartyr",
  "saintJeanVianneyTheCureOfArsPriest",
  "saintJeromePriestAndDoctor",
  "saintJohnBoscoPriest",
  "saintJohnDamascenePriestAndDoctor",
  "saintJohnEudesPriest",
  "saintJohnIPopeAndMartyr",
  "saintJohnOfCapistranoPriest",
  "saintJohnOfKantyPriest",
  "saintJohnOfTheCrossPriestAndDoctor",
  "saintJosaphatBishopAndMartyr",
  "saintJosephTheWorker",
  "saintJuanDiegoCuauhtlatoatzin",
  "saintJustinMartyr",
  "saintLawrenceOfBrindisiPriestAndDoctor",
  "saintLawrenceOfRomeDeaconAndMartyr",
  "saintLeoTheGreatPopeAndDoctor",
  "saintLouisSaintJosephOfCalasanzPriest",
  "saintMargaretOfScotlandSaintGertrudeTheGreatVirgin",
  "saintMariaGorettiVirginAndMartyr",
  "saintMarkTheEvangelist",
  "saintMartha",
  "saintMartinDePorresReligious",
  "saintMartinIPopeAndMartyr",
  "saintMartinOfToursBishop",
  "saintMaryMagdalene",
  "saintMatthewApostleAndEvangelist",
  "saintMaximilianMaryKolbePriestAndMartyr",
  "saintMonica",
  "saintNorbertBishop",
  "saintPatrickBishop",
  "saintPaulMikiAndCompanionsMartyrs",
  "saintPaulinusOfNolaBishopSaintsJohnFisherBishopAndThomasMoreMartyrs",
  "saintPeterCanisiusPriestAndDoctor",
  "saintPeterChanelPriestAndMartyrSaintLouisGrignonDeMontfortPriest",
  "saintPeterChrysologusBishopAndDoctor",
  "saintPeterClaverPriest",
  "saintPeterDamianBishopAndDoctorOfTheChurch",
  "saintPhilipNeriPriest",
  "saintPioOfPietrelcinaPadrePioPriest",
  "saintPiusVPope",
  "saintPiusXPope",
  "saintPolycarpBishopAndMartyr",
  "saintRaymondOfPenyafortPriest",
  "saintRitaOfCascia",
  "saintRobertBellarmineBishopAndDoctor",
  "saintRomualdAbbot",
  "saintScholasticaVirgin",
  "saintSixtusIiPopeAndCompanionsMartyrsSaintCajetanPriest",
  "saintStephenTheFirstMartyr",
  "saintSylvesterIPope",
  "saintTeresaOfJesusVirginAndDoctorOfTheChurch",
  "saintThereseOfTheChildJesusVirginAndDoctor",
  "saintThomasAquinasPriestAndDoctor",
  "saintThomasBecketBishopAndMartyr",
  "saintThomasTheApostle",
  "saintTuribiusOfMogrovejoBishop",
  "saintVincentDeaconAndMartyr",
  "saintWenceslausMartyrSaintsLawrenceRuizAndCompanionsMartyrs",
  "saintsAugustineZhaoRongPriestAndCompanionsMartyrs",
  "saintsBasilTheGreatAndGregoryNazianzenBishopsAndDoctors",
  "saintsCharlesLwangaAndCompanionsMartyrs",
  "saintsCorneliusPopeAndCyprianBishopMartyrs",
  "saintsCosmasAndDamianMartyrs",
  "saintsCyrilMonkAndMethodiusBishop",
  "saintsFabianPopeAndSebastianMartyrs",
  "saintsJeanDeBrebeufAndIsaacJoguesPriestsAndCompanionsMartyrsSaintPaulOfTheCrossPriest",
  "saintsMarcellinusAndPeterMartyrs",
  "saintsMichaelGabrielAndRaphaelArchangels",
  "saintsNereusAndAchilleusMartyrsSaintPancrasMartyr",
  "saintsPerpetuaAndFelicityMartyrs",
  "saintsPontianPopeAndHippolytusPriestMartyrs",
  "saintsSimonAndJudeApostles",
  "saintsTimothyAndTitusBishops",
  "saturdayAfterEpiphany",
  "saturdayOfThe11ThWeekOfOrdinaryTime",
  "saturdayOfThe15thWeekOfOrdinaryTime",
  "saturdayOfThe1stWeekOfAdvent",
  "saturdayOfThe1stWeekOfLent",
  "saturdayOfThe22ndWeekOfOrdinaryTime",
  "saturdayOfThe26thWeekOfOrdinaryTime",
  "saturdayOfThe27thWeekOfOrdinaryTime",
  "saturdayOfThe2ndWeekOfEaster",
  "saturdayOfThe30thWeekOfOrdinaryTime",
  "saturdayOfThe31stWeekOfOrdinaryTime",
  "saturdayOfThe32ndWeekOfOrdinaryTime",
  "saturdayOfThe34thWeekOfOrdinaryTime",
  "saturdayOfThe3rdWeekOfAdvent",
  "saturdayOfThe3rdWeekOfLent",
  "saturdayOfThe4thWeekOfLent",
  "saturdayOfThe4thWeekOfOrdinaryTime",
  "saturdayOfThe5thWeekOfEaster",
  "saturdayOfThe5thWeekOfLent",
  "saturdayOfThe6thWeekOfEaster",
  "saturdayOfThe7thWeekOfEaster",
  "saturdayOfThe8thWeekOfOrdinaryTime",
  "sevenHolyFoundersOfTheServiteOrder",
  "theBeheadingOfSaintJohnTheBaptistMartyr",
  "theExaltationOfTheHolyCross",
  "theMostHolyNameOfJesus",
  "thursdayAfterAshWednesday",
  "thursdayAfterEpiphany",
  "thursdayOfThe11ThWeekOfOrdinaryTime",
  "thursdayOfThe12ThWeekOfOrdinaryTime",
  "thursdayOfThe13ThWeekOfOrdinaryTime",
  "thursdayOfThe1stWeekOfLent",
  "thursdayOfThe1stWeekOfOrdinaryTime",
  "thursdayOfThe23rdWeekOfOrdinaryTime",
  "thursdayOfThe25thWeekOfOrdinaryTime",
  "thursdayOfThe27thWeekOfOrdinaryTime",
  "thursdayOfThe2ndWeekOfEaster",
  "thursdayOfThe2ndWeekOfLent",
  "thursdayOfThe30thWeekOfOrdinaryTime",
  "thursdayOfThe31stWeekOfOrdinaryTime",
  "thursdayOfThe33rdWeekOfOrdinaryTime",
  "thursdayOfThe34thWeekOfOrdinaryTime",
  "thursdayOfThe3rdWeekOfAdvent",
  "thursdayOfThe3rdWeekOfLent",
  "thursdayOfThe3rdWeekOfOrdinaryTime",
  "thursdayOfThe4thWeekOfAdvent",
  "thursdayOfThe5thWeekOfEaster",
  "thursdayOfThe5thWeekOfLent",
  "thursdayOfThe5thWeekOfOrdinaryTime",
  "thursdayOfThe8thWeekOfOrdinaryTime",
  "thursdayOfThe9thWeekOfOrdinaryTime",
  "transfiguration",
  "trinitySunday",
  "tuesdayAfterEpiphany",
  "tuesdayOfHolyWeek",
  "tuesdayOfThe11ThWeekOfOrdinaryTime",
  "tuesdayOfThe12ThWeekOfOrdinaryTime",
  "tuesdayOfThe14thWeekOfOrdinaryTime",
  "tuesdayOfThe17thWeekOfOrdinaryTime",
  "tuesdayOfThe1stWeekOfAdvent",
  "tuesdayOfThe1stWeekOfLent",
  "tuesdayOfThe20thWeekOfOrdinaryTime",
  "tuesdayOfThe22ndWeekOfOrdinaryTime",
  "tuesdayOfThe25thWeekOfOrdinaryTime",
  "tuesdayOfThe28thWeekOfOrdinaryTime",
  "tuesdayOfThe29thWeekOfOrdinaryTime",
  "tuesdayOfThe2ndWeekOfEaster",
  "tuesdayOfThe2ndWeekOfLent",
  "tuesdayOfThe30thWeekOfOrdinaryTime",
  "tuesdayOfThe3rdWeekOfAdvent",
  "tuesdayOfThe3rdWeekOfLent",
  "tuesdayOfThe4thWeekOfAdvent",
  "tuesdayOfThe5thWeekOfEaster",
  "tuesdayOfThe5thWeekOfLent",
  "tuesdayOfThe7thWeekOfEaster",
  "wednesdayOfHolyWeek",
  "wednesdayOfThe10thWeekOfOrdinaryTime",
  "wednesdayOfThe11ThWeekOfOrdinaryTime",
  "wednesdayOfThe13ThWeekOfOrdinaryTime",
  "wednesdayOfThe14thWeekOfOrdinaryTime",
  "wednesdayOfThe1stWeekOfAdvent",
  "wednesdayOfThe1stWeekOfLent",
  "wednesdayOfThe1stWeekOfOrdinaryTime",
  "wednesdayOfThe21stWeekOfOrdinaryTime",
  "wednesdayOfThe22ndWeekOfOrdinaryTime",
  "wednesdayOfThe29thWeekOfOrdinaryTime",
  "wednesdayOfThe2ndWeekOfEaster",
  "wednesdayOfThe3rdWeekOfAdvent",
  "wednesdayOfThe3rdWeekOfEaster",
  "wednesdayOfThe3rdWeekOfLent",
  "wednesdayOfThe4thWeekOfOrdinaryTime",
  "wednesdayOfThe5thWeekOfEaster"
]