Guang'an, China: Difference between revisions
(Created page with "{{Region |Description= |geonameId=1810845 |population=858159 |fcode=PPLA2 |coord=30° 28' 26.868" N, 106° 38' 13.056" E }} Category:Region") |
m (InternalAdmin moved page Guang'an to Guang'an, China: Updating page title) |
(No difference)
|
Latest revision as of 11:55, 25 May 2023
Function: CargoSQLQuery::run Query: SELECT COUNT(*) AS `Total Problems` FROM `cargo__Problem` `P` WHERE `P`.`Region`='Guang'an, China' ORDER BY COUNT(*) LIMIT 100
Function: CargoSQLQuery::run Query: SELECT COUNT(*) AS `Total Solution` FROM `cargo__Solution` `S` WHERE `S`.`Region`='Guang'an, China' ORDER BY COUNT(*) LIMIT 100
Function: CargoSQLQuery::run Query: SELECT COUNT(*) AS `Total Projects` FROM `cargo__Project` `P` WHERE `P`.`Region`='Guang'an, China' ORDER BY COUNT(*) LIMIT 100
Top Problems in Guang'an, China
Function: CargoSQLQuery::run Query: SELECT `P`.`_pageID` AS `cargo_backlink_page_id_P`,`P`.`_pageName` AS `Article Name`,`P`.`_pageID` AS `page_id`,CONCAT( LEFT( `P`.`Description`, 350 ), IF( LENGTH( `P`.`Description` ) > 200, '...', ) ) AS `Description`,`P`.`feature_image` AS `feature_image` FROM `cargo__Problem` `P` WHERE `P`.`Region`='Guang'an, China' ORDER BY `P`.`_pageID`,`P`.`_pageName`,`P`.`_pageID`,CONCAT( LEFT( `P`.`Description`, 350 ), IF( LENGTH( `P`.`Description` ) > 200, '...', ) ),`P`.`feature_image` LIMIT 100
Top Solutions in Guang'an, China
Function: CargoSQLQuery::run Query: SELECT `S`.`_pageID` AS `cargo_backlink_page_id_S`,`S`.`_pageName` AS `Article Name`,`S`.`_pageID` AS `page_id`,CONCAT( LEFT( `S`.`Description`, 350 ), IF( LENGTH( `S`.`Description` ) > 200, '...', ) ) AS `Description`,`S`.`feature_image` AS `feature_image` FROM `cargo__Solution` `S` WHERE `S`.`Region`='Guang'an, China' ORDER BY `S`.`_pageID`,`S`.`_pageName`,`S`.`_pageID`,CONCAT( LEFT( `S`.`Description`, 350 ), IF( LENGTH( `S`.`Description` ) > 200, '...', ) ),`S`.`feature_image` LIMIT 100
Top Projects in Guang'an, China
Function: CargoSQLQuery::run Query: SELECT `P`.`_pageID` AS `cargo_backlink_page_id_P`,`P`.`_pageName` AS `Article Name`,`P`.`_pageID` AS `page_id`,CONCAT( LEFT( `P`.`Description`, 200 ), IF( LENGTH( `P`.`Description` ) > 200, '...', ) ) AS `Description`,`P`.`feature_image` AS `feature_image` FROM `cargo__Project` `P` WHERE `P`.`Region`='Guang'an, China' ORDER BY `P`.`_pageID`,`P`.`_pageName`,`P`.`_pageID`,CONCAT( LEFT( `P`.`Description`, 200 ), IF( LENGTH( `P`.`Description` ) > 200, '...', ) ),`P`.`feature_image` LIMIT 100