Difference between revisions of "List of controllers that use USB-Mini connectors"
(Created page with "This is an in-progress automated list of PC controllers that are believed to use USB-Mini cables, i.e. with USB-Mini male (Only a 2.0 version was ever created) on at least one...") |
|||
Line 5: | Line 5: | ||
tables=Controller | tables=Controller | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
− | |where=Controller.Connection_method HOLDS LIKE 'USB-Mini%' OR Controller.Connection_method HOLDS LIKE 'Mini-USB%' | + | |where=Controller.Connection_method HOLDS LIKE 'USB-Mini%' OR Controller.Connection_method HOLDS LIKE 'Mini-USB%' OR Controller.Connection_method HOLDS LIKE 'USB Mini%' |
|format=text | |format=text | ||
}} | }} | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Controller | tables=Controller | ||
− | |where=Controller.Connection_method HOLDS LIKE 'USB-Mini%' OR Controller.Connection_method HOLDS LIKE 'Mini-USB%' | + | |where=Controller.Connection_method HOLDS LIKE 'USB-Mini%' OR Controller.Connection_method HOLDS LIKE 'Mini-USB%' OR Controller.Connection_method HOLDS LIKE 'USB Mini%' |
|fields=Controller._pageName | |fields=Controller._pageName | ||
|format=template | |format=template |
Revision as of 09:14, 21 May 2023
This is an in-progress automated list of PC controllers that are believed to use USB-Mini cables, i.e. with USB-Mini male (Only a 2.0 version was ever created) on at least one end of the cable. Sometimes such a detachable cable may be included with the controller's packaging, while other cases may require having a USB-Mini cable available or that such a cable is bought.
Total number of controllers:
Function: CargoSQLQuery::run Query: SELECT `cargo__Controller`.`_pageID` AS `cargo_backlink_page_id_Controller`,COUNT(*) FROM `cargo__Controller` WHERE `cargo__Controller`.`_ID` IN (SELECT `_rowID` FROM `cargo__Controller__Connection_Method` WHERE `_value`LIKE 'USB-Mini%') OR `cargo__Controller`.`_ID` IN (SELECT `_rowID` FROM `cargo__Controller__Connection_Method` WHERE `_value`LIKE 'Mini-USB%') OR `cargo__Controller`.`_ID` IN (SELECT `_rowID` FROM `cargo__Controller__Connection_Method` WHERE `_value`LIKE 'USB Mini%') ORDER BY `cargo__Controller`.`_pageID`,COUNT(*) LIMIT 100