Duik in de wereld van databeheer en laat je meevoeren in technieken voor invoerformulieren en rapportages.
Dit is de gebruikte query:
SELECT |
jos_jea_properties.title AS Omschrijving, |
jos_jea_properties.rooms AS Kamers, |
jos_jea_properties.price AS Huurprijs, |
jos_jea_properties.charges AS Servicekosten |
FROM jos_jea_properties |
LEFT JOIN jos_jea_types ON jos_jea_properties.type_id = jos_jea_types.id |
LEFT JOIN jos_jea_towns ON jos_jea_properties.town_id = jos_jea_towns.id |
WHERE jos_jea_properties.published = 1 AND jos_jea_properties.access = 1 |
ORDER BY Omschrijving |
De JEA component is te downloaden via jea.sphilip.com.
De bovenstaande query kan gedraaid worden in phpMyAdmin of met een Windows client voor MySQL zoals bijvoorbeeld HeidiSQL.
PLOTALOT QUERY JOOMLA ESTATE AGENCY |
SELECT |
#__jea_properties.title AS Omschrijving, |
#__jea_properties.rooms AS Kamers, |
#__jea_properties.price AS Huurprijs, |
#__jea_properties.charges AS Servicekosten |
FROM #__jea_properties |
LEFT JOIN #__jea_types ON #__jea_properties.type_id = #__jea_types.id |
LEFT JOIN #__jea_towns ON #__jea_properties.town_id = #__jea_towns.id |
WHERE #__jea_properties.published = 1 AND #__jea_properties.access = 1 |
ORDER BY Omschrijving |
Dit is de gebruikte query:
SELECT jos_jdownloads_categories.cat_dir_parent AS Hoofdcategorie, |
jos_jdownloads_categories.cat_dir AS Categorie, |
jos_jdownloads_files.file_title AS Titel, |
jos_jdownloads_files.`release` AS Versie, |
jos_jdownloads_files.size AS Grootte, |
jos_jdownloads_files.downloads AS Downloads, |
jos_jdownloads_files.language AS Taal |
FROM jos_jdownloads_files |
LEFT JOIN jos_jdownloads_categories On jos_jdownloads_files.cat_id = jos_jdownloads_categories.id |
ORDER BY Hoofdcategorie, |
Categorie |
De component jDownlaods is gratis en kan gedownload worden via jdownloads.com.
De bovenstaande query kan gedraaid worden in phpMyAdmin of met een Windows client voor MySQL zoals bijvoorbeeld HeidiSQL.
PLOTALOT QUERY JOOMLA JDOWNLOADS |
SELECT #__jdownloads_categories.cat_dir_parent AS Hoofdcategorie, |
#__jdownloads_categories.cat_dir AS Categorie, |
#__jdownloads_files.file_title AS Titel, |
#__jdownloads_files.`release` AS Versie, |
#__jdownloads_files.size AS Grootte, |
#__jdownloads_files.downloads AS Downloads |
FROM #__jdownloads_files |
LEFT JOIN #__jdownloads_categories On #__jdownloads_files.cat_id = #__jdownloads_categories.id |
ORDER BY Hoofdcategorie, Categorie |
Dit is de gebruikte query:
JOOMLA CORE SAMENVATTING |
SELECT 'Template' AS Omschrijving, template AS Waarde |
FROM jos_template_styles |
WHERE client_id=0 AND home=1 |
UNION |
SELECT 'Aantal componenten' AS Omschrijving, COUNT(name) AS Waarde |
FROM jos_extensions |
WHERE type = 'component' |
UNION |
SELECT 'Aantal modules' AS Omschrijving, |
SUM(CASE WHEN published = 1 THEN 1 ELSE 0 END) AS Waarde |
FROM jos_modules |
UNION |
SELECT 'Aantal actieve plugins' AS Omschrijving, COUNT(name) AS Waarde |
FROM jos_extensions |
WHERE type = 'plugin' AND enabled = 1 |
UNION |
SELECT "Aantal artikelen" AS "Omschrijving",COUNT(title) AS Waarde |
FROM jos_content |
UNION |
SELECT "Openbare artikelen" AS "Omschrijving",COUNT(title) AS Waarde |
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.
PLOTALOT QUERY JOOMLA CORE SAMENVATTING |
SELECT 'Template' AS Omschrijving, template AS Waarde |
FROM #__template_styles |
WHERE client_id=0 AND home=1 |
UNION |
SELECT 'Aantal componenten' AS Omschrijving, COUNT(name) AS Waarde |
FROM #__extensions |
WHERE type = 'component' |
UNION |
SELECT 'Aantal modules' AS Omschrijving, |
SUM(CASE WHEN published = 1 THEN 1 ELSE 0 END) AS Waarde |
FROM #__modules |
UNION |
SELECT 'Aantal actieve plugins' AS Omschrijving, COUNT(name) AS Waarde |
FROM #__extensions |
WHERE type = 'plugin' AND enabled = 1 |
UNION |
SELECT "Aantal artikelen" AS "Omschrijving",COUNT(title) AS Waarde |
FROM #__content |
UNION |
SELECT "Openbare artikelen" AS "Omschrijving",COUNT(title) AS Waarde |
FROM #__content |
WHERE #__content.state = 1 and #__content.access = 1 |
Link1.nl bestrijkt een groot gebied met desktop- en online toepassingen.
De nadruk ligt op databeheer, Excel en finance.
© 2021 Link1