Duik in de wereld van databeheer en laat je meevoeren in technieken voor invoerformulieren en rapportages.
Dit is de gebruikte query:
SELECT jos_content.title AS Artikel, |
jos_categories.path AS Categoriepad, |
jos_content.hits AS Hits |
FROM jos_content LEFT JOIN |
jos_categories ON jos_content.catid = jos_categories.id |
ORDER BY jos_categories.path, |
jos_content.title |
De bovenstaande query kan gedraaid worden in phpMyAdmin of met een Windows client voor MySQL zoals bijvoorbeeld HeidiSQL.
PLOTALOT QUERY JOOMLA ARTIKELEN |
SELECT |
#__content.title AS Artikel, |
#__categories.path AS Categoriepad, |
#__content.hits AS Hits |
FROM #__content LEFT JOIN |
#__categories ON #__content.catid = #__categories.id |
WHERE jos_content.state = 1 and jos_content.access = 1 |
ORDER BY #__categories.path, |
#__content.title |
Dit is de gebruikte query:
SELECT |
jos_categories.path AS Pad, |
COUNT(jos_categories.title) AS Aantal |
FROM jos_content LEFT JOIN |
jos_categories ON jos_content.catid = jos_categories.id LEFT JOIN |
jos_categories jos_categories1 ON jos_categories.parent_id = |
jos_categories1.id |
WHERE jos_content.state = 1 and jos_content.access = 1 |
GROUP BY jos_categories.path |
UNION |
SELECT |
'Totaal' AS Pad, |
COUNT(jos_content.title) AS Aantal |
FROM jos_content |
WHERE jos_content.state = 1 and jos_content.access = 1 |
De bovenstaande query kan gedraaid worden in phpMyAdmin of met een Windows client voor MySQL zoals bijvoorbeeld HeidiSQL.
SELECT |
#__categories.path AS Pad, |
COUNT(#__categories.title) AS Aantal |
FROM #__content LEFT JOIN |
#__categories ON #__content.catid = #__categories.id LEFT JOIN |
#__categories #__categories1 ON #__categories.parent_id = |
#__categories1.id |
WHERE #__content.state = 1 and #__content.access = 1 |
GROUP BY #__categories.path |
UNION |
SELECT |
'Totaal' AS Pad, |
COUNT(#__content.title) AS Aantal |
FROM #__content |
WHERE #__content.state = 1 and #__content.access = 1 |
Dit is de gebruikte query:
SELECT jos_content.title AS Artikel, |
jos_categories.path AS Categoriepad, |
jos_content.hits AS Hits |
FROM jos_content LEFT JOIN |
jos_categories ON jos_content.catid = jos_categories.id |
WHERE jos_content.state = 1 and jos_content.access = 1 |
ORDER BY jos_content.hits desc limit 10 |
Ook is het interessant een overzicht te maken van de nieuwste artikelen:
De inhoud van de query is zo:
SELECT |
jos_content.title AS Artikel, |
jos_categories.path AS Categoriepad, |
date(created) AS Gemaakt, |
jos_content.hits AS Hits |
FROM jos_content |
LEFT JOIN jos_categories ON jos_content.catid = jos_categories.id |
ORDER BY created DESC LIMIT 10 |
De bovenstaande query kan gedraaid worden in phpMyAdmin of met een Windows client voor MySQL zoals bijvoorbeeld HeidiSQL.
-- PLOTALOT QUERY JOOMLA ARTIKELEN MEEST POPULAIR |
SELECT |
#__content.titleAS Artikel, |
#__categories.path AS Categoriepad, |
#__content.hits AS Hits |
FROM #__content |
LEFT JOIN #__categories ON #__content.catid = #__categories.id |
WHERE #__content.state = 1 and #__content.access = 1 |
ORDER BY #__content.hits desc limit 10 |
-- PLOTALOT QUERY JOOMLA ARTIKELEN 10 NIEUWSTE |
SELECT |
#__content.title AS Artikel, |
#__categories.path AS Categoriepad, |
date(created) AS Gemaakt, |
#__content.hits AS Hits |
FROM #__content |
LEFT JOIN #__categories ON #__content.catid = #__categories.id |
WHERE #__content.state = 1 and #__content.access = 1 |
ORDER BY created DESC LIMIT 10 |
Link1.nl bestrijkt een groot gebied met desktop- en online toepassingen.
De nadruk ligt op databeheer, Excel en finance.
© 2021 Link1