SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROMvmej5_extensionsWHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1,5)
ORDERBY ordering

SELECT e.*, e.name AS contact_name, e.email AS contact_email,c.id AS cat_id, c.title AS cat_title, c.color AS cat_color, c.desc AS cat_desc,feat.count AS features
FROM `vmej5_icagenda_events` AS e
LEFTJOINvmej5_icagenda_categoryAS c ON c.id = e.catid
LEFTJOIN (
SELECT fx.event_id, COUNT(*) AS count
FROM `vmej5_icagenda_feature_xref` AS fx
INNERJOIN `vmej5_icagenda_feature` AS f ON fx.feature_id=f.id AND f.state=1 AND f.icon<>'-1'
GROUPBY fx.event_id) AS feat ON e.id=feat.event_id
WHERE c.state = 1 ANDTRUEAND (e.state IN (0, 1)) AND e.approval <> 1

SELECT `id`,`name`,`rules`,`parent_id`
FROM `vmej5_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_icagenda','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

SELECT next AS tNext, dates AS tDates, startdate AS tStartdate, enddate AS tEnddate,
weekdays AS tWeekdays, id AS tId, state AS tState, access AS tAccess
FROM `vmej5_icagenda_events` AS e
WHERE e.state = 1 AND e.next < '2018-08-14 21:41:43' AND e.next > (DATE(NOW() - INTERVAL 2 MONTH))

25 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

5 × SELECT*FROMvmej5_banners

5 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions FROMvmej5_banners as a LEFTJOINvmej5_banner_clientsAS cl ON cl.id = a.cid

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `vmej5_extensions`

1 × SELECT e.*, e.name AS contact_name, e.email AS contact_email,c.id AS cat_id, c.title AS cat_title, c.color AS cat_color, c.desc AS cat_desc,feat.count AS features FROM `vmej5_icagenda_events` AS e LEFTJOINvmej5_icagenda_categoryAS c ON c.id = e.catid LEFTJOIN ( SELECT fx.event_id, COUNT(*) AS count FROM `vmej5_icagenda_feature_xref` AS fx INNERJOIN `vmej5_icagenda_feature` AS f ON fx.feature_id=f.id AND f.state=1 AND f.icon<>'-1' GROUPBY fx.event_id) AS feat ON e.id=feat.event_id