SELECT folder AS type, 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 = 198) 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 = 198OR mm.menuid = 0) ORDERBY position, ordering
8 Abfragen im Legacy-Modus protokolliert
SELECT * FROM jos_joomleague WHERE id = '12'
SELECT pp.id FROM jos_joomleague_predictiongame_project AS pp
LEFTJOIN jos_joomleague_predictiongame AS p ON p.id = pp.prediction_id
WHERE pp.project_id = 12 AND p.published = 1
SELECT * FROM jos_joomleague_team_joomleague WHERE id = '118'
SELECT params FROM jos_joomleague_template_config WHERE template = 'overall.tpl'
AND project_id = 12
SELECT params FROM jos_joomleague_template_config WHERE template = 'show_players.tpl'
AND project_id = 12
SELECT * FROM jos_joomleague_teams WHERE id = '51'
SELECT pt.*, p.*, p.id AS pid, pos.name AS position
FROM jos_joomleague_playertool pt
INNERJOIN jos_joomleague_players p ON pt.player_id = p.id
INNERJOIN jos_joomleague_positions pos ON pos.id = pt.position_id
