SELECT *
FROM jos_session
WHERE session_id = 'bh665h09ujnj12ndd3e9m1s7r3'
DELETE
FROM jos_session
WHERE ( TIME < '1714338891' )
SELECT *
FROM jos_session
WHERE session_id = 'bh665h09ujnj12ndd3e9m1s7r3'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'bh665h09ujnj12ndd3e9m1s7r3','1714339791','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT MAX(TIME)
FROM jos_vvcounter_logs
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 101)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT c.*, s.id AS sectionid, s.title AS sectiontitle, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS slug
FROM jos_categories AS c
INNER JOIN jos_sections AS s
ON s.id = c.SECTION
WHERE c.id = 68
LIMIT 0, 1
SELECT cc.title AS category, a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON a.catid = cc.id
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.catid = 68
AND a.state = 1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-28 21:29:51' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-28 21:29:51' )
ORDER BY cc.ordering, a.ordering, a.created DESC
LIMIT 15, 9
SELECT cc.title AS category, a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON a.catid = cc.id
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.catid = 68
AND a.state = 1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-28 21:29:51' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-28 21:29:51' )
ORDER BY cc.ordering, a.ordering, a.created DESC
SELECT id, title, module, POSITION, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN 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 = 101 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT parent, menutype, ordering
FROM jos_menu
WHERE id = 101
LIMIT 1
SELECT parent, menutype, ordering
FROM jos_menu
WHERE id = 99
LIMIT 1
SELECT parent, menutype, ordering
FROM jos_menu
WHERE id = 77
LIMIT 1
SELECT COUNT(*)
FROM jos_menu AS m
WHERE menutype='actividade_projecto'
AND published=1
AND parent=0
AND ordering < 1
AND access <= '0'
SELECT *, RAND() AS ordering
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 1
AND catid = 13
ORDER BY sticky DESC, ordering
LIMIT 0, 1
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 1
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-28 21:29:51' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-28 21:29:51' )
AND cc.id = 3
AND cc.SECTION = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
A turma do 10º ano do curso profissional de vendas foi visitar o centro cultural de Belém, em Lisboa.
Sob a orientação de vários professores, cerca de uma centena de aventureiros alunos, da Escola Sede do Agrupamento Professor Ruy Luís Gomes, saíram por volta das oito horas da manhã, em dois autocarros, rumo a Azeitão, para que se iniciasse a Travessia da Serra da Arrábida, que se concluiu cerca de catorze quilómetros depois, na praia do Portinho da Arrábida.
