Deprecated: Use of MediaWiki\Parser\Parser::$mTemplatePath was deprecated in MediaWiki 1.42. [Called from MediaWiki\Extension\DynamicPageList3\Parse::parse in /home/httpd/vhosts/unix.fish/raysoft.ch/w/extensions/DynamicPageList3/includes/Parse.php at line 105] in /home/httpd/vhosts/unix.fish/raysoft.ch/w/includes/debug/MWDebug.php on line 372 Deprecated: Asking for a replica from groups except dump/vslow is deprecated: dpl [Called from Wikimedia\Rdbms\LoadBalancer::getConnectionInternal in /home/httpd/vhosts/unix.fish/raysoft.ch/w/includes/libs/rdbms/loadbalancer/LoadBalancer.php at line 805] in /home/httpd/vhosts/unix.fish/raysoft.ch/w/includes/debug/MWDebug.php on line 372 Deprecated: Caller from MediaWiki\Extension\DynamicPageList3\Query::buildAndSelect - Structured_Query_Language ignored an error originally raised from MediaWiki\Extension\DynamicPageList3\Query::buildAndSelect - Structured_Query_Language: [1054] Unknown column 'ecl1.cl_to' in 'where clause' in /home/httpd/vhosts/unix.fish/raysoft.ch/w/includes/debug/MWDebug.php on line 372 Deprecated: Caller from MediaWiki\Page\PageStore::getPageByNameViaLinkCache ignored an error originally raised from MediaWiki\Extension\DynamicPageList3\Query::buildAndSelect - Structured_Query_Language: [1054] Unknown column 'ecl1.cl_to' in 'where clause' in /home/httpd/vhosts/unix.fish/raysoft.ch/w/includes/debug/MWDebug.php on line 372 Structured Query Language - RaySoft Jump to content

Structured Query Language

From RaySoft

Structured Query Language (SQL) is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling structured data, i.e., data incorporating relations among entities and variables.[1]

Implementations

Server

Extension:DynamicPageList3 (DPL3), version 3.6.4: Error: Error 1054: Unknown column 'ecl1.cl_to' in 'where clause' Function: MediaWiki\Extension\DynamicPageList3\Query::buildAndSelect - Structured_Query_Language Query: SET STATEMENT max_statement_time=10 FOR SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `wp_page`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'RaySoft:' WHEN 5 THEN 'RaySoft_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' END, `wp_page`.page_title), '_', ' ')) AS `sortkey`,`wp_page`.page_namespace AS `page_namespace`,`wp_page`.page_id AS `page_id`,`wp_page`.page_title AS `page_title` FROM `wp_page` `wp_page` JOIN `wp_categorylinks` `cl1` ON ((`wp_page`.page_id = cl1.cl_from AND cl1.cl_to = 'Structured_Query_Language')) JOIN `wp_categorylinks` `cl2` ON ((`wp_page`.page_id = cl2.cl_from AND (cl2.cl_to = 'Suite' OR cl2.cl_to = 'Server'))) LEFT OUTER JOIN `wp_categorylinks` `ecl1` ON ((`wp_page`.page_id = ecl1.cl_from AND ecl1.cl_to ='Component')) WHERE `wp_page`.page_is_redirect = 0 AND `wp_page`.page_namespace = 0 AND ecl1.cl_to IS NULL ORDER BY sortkey ASC LIMIT 500

Client

Extension:DynamicPageList3 (DPL3), version 3.6.4: Error: Error 1054: Unknown column 'ecl1.cl_to' in 'where clause' Function: MediaWiki\Extension\DynamicPageList3\Query::buildAndSelect - Structured_Query_Language Query: SET STATEMENT max_statement_time=10 FOR SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `wp_page`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'RaySoft:' WHEN 5 THEN 'RaySoft_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' END, `wp_page`.page_title), '_', ' ')) AS `sortkey`,`wp_page`.page_namespace AS `page_namespace`,`wp_page`.page_id AS `page_id`,`wp_page`.page_title AS `page_title` FROM `wp_page` `wp_page` JOIN `wp_categorylinks` `cl1` ON ((`wp_page`.page_id = cl1.cl_from AND cl1.cl_to = 'Structured_Query_Language')) JOIN `wp_categorylinks` `cl2` ON ((`wp_page`.page_id = cl2.cl_from AND cl2.cl_to = 'Application')) LEFT OUTER JOIN `wp_categorylinks` `ecl1` ON ((`wp_page`.page_id = ecl1.cl_from AND ecl1.cl_to ='Component')) WHERE `wp_page`.page_is_redirect = 0 AND `wp_page`.page_namespace = 0 AND ecl1.cl_to IS NULL ORDER BY sortkey ASC LIMIT 500

References

  1. ↑ Wikipedia contributors. "SQL." Wikipedia. https://en.wikipedia.org/wiki/SQL (accessed 27.03.2025)
Retrieved from "https://www.raysoft.ch/w/index.php?title=Structured_Query_Language&oldid=44906"