Sito istituzionale del Centro di Istruzione e Formazione Professionale del Piambello - Bisuschio (VA)
Ente che eroga corsi di formazione profesionale in vari ambiti
SELECT folder ASTYPE, element AS name, params FROM jos_plugins WHERE published >=1 AND access <=0 ORDERBY ordering
SELECT m.*, c.`option`AS component FROM jos_menu AS m LEFTJOIN jos_components AS c ON m.componentid = c.id WHERE m.published =1 ORDERBY m.sublevel, m.parent, m.ordering
SELECT template FROM jos_templates_menu WHERE client_id =0 AND(menuid =0OR menuid =1) ORDERBY menuid DESC LIMIT0,1
SELECT id, title, module,POSITION, content, showtitle, control, params FROM jos_modules AS m LEFTJOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published =1 AND m.access <=0 AND m.client_id =0 AND( mm.menuid =1OR mm.menuid =0) ORDERBYPOSITION, ordering
SELECT c.id
FROM jos_categories AS c LEFTJOIN jos_categories AS p ON p.id=c.parent_id LEFTJOIN jos_categories AS gp ON gp.id=p.parent_id LEFTJOIN jos_categories AS ggp ON ggp.id=gp.parent_id
WHERE c.access <=0
AND c.published =1
AND c.SECTION='com_jevents'
SELECT rpt.*, ev.*, rr.*, det.*, ev.state AS published, ev.created AS created ,YEAR(rpt.startrepeat)AS yup,MONTH(rpt.startrepeat )AS mup, DAYOFMONTH(rpt.startrepeat )AS dup ,YEAR(rpt.endrepeat )AS ydn,MONTH(rpt.endrepeat )AS mdn, DAYOFMONTH(rpt.endrepeat )AS ddn ,HOUR(rpt.startrepeat)AS hup,MINUTE(rpt.startrepeat )AS minup,SECOND(rpt.startrepeat )AS sup ,HOUR(rpt.endrepeat )AS hdn,MINUTE(rpt.endrepeat )AS mindn,SECOND(rpt.endrepeat )AS sdn
FROM jos_jevents_repetition AS rpt
LEFTJOIN jos_jevents_vevent AS ev ON rpt.eventid = ev.ev_id
LEFTJOIN jos_jevents_icsfile AS icsf ON icsf.ics_id=ev.icsid
LEFTJOIN jos_jevents_vevdetail AS det ON det.evdet_id = rpt.eventdetail_id
LEFTJOIN jos_jevents_rrule AS rr ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,4)
AND rpt.endrepeat >='2024-06-08 00:00:00' AND rpt.startrepeat <='2024-06-08 23:59:59' AND ev.state=1
AND ev.access <=0 AND icsf.state=1 AND icsf.access <=0
SELECT rpt.*, ev.*, rr.*, det.*, ev.state AS published, ev.created AS created ,YEAR(rpt.startrepeat)AS yup,MONTH(rpt.startrepeat )AS mup, DAYOFMONTH(rpt.startrepeat )AS dup ,YEAR(rpt.endrepeat )AS ydn,MONTH(rpt.endrepeat )AS mdn, DAYOFMONTH(rpt.endrepeat )AS ddn ,HOUR(rpt.startrepeat)AS hup,MINUTE(rpt.startrepeat )AS minup,SECOND(rpt.startrepeat )AS sup ,HOUR(rpt.endrepeat )AS hdn,MINUTE(rpt.endrepeat )AS mindn,SECOND(rpt.endrepeat )AS sdn
FROM jos_jevents_repetition AS rpt
LEFTJOIN jos_jevents_vevent AS ev ON rpt.eventid = ev.ev_id
LEFTJOIN jos_jevents_icsfile AS icsf ON icsf.ics_id=ev.icsid
LEFTJOIN jos_jevents_vevdetail AS det ON det.evdet_id = rpt.eventdetail_id
LEFTJOIN jos_jevents_rrule AS rr ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,4)
AND rpt.endrepeat >='2024-06-01 00:00:00' AND rpt.startrepeat <='2024-06-30 23:59:59' AND ev.state=1
AND ev.access <=0 AND icsf.state=1 AND icsf.access <=0