Ji'nan, China: Difference between revisions
(Created page with "{{Region |Description= |geonameId=1805753 |population=0 |fcode=ADM2 |coord=36° 38' 51.36" N, 117° 7' 23.448" E }} Category:Region") |
m (InternalAdmin moved page Ji'nan to Ji'nan, China: Updating page title) |
Latest revision as of 11:58, 25 May 2023
Function: CargoSQLQuery::run Query: SELECT COUNT(*) AS `Total Problems` FROM `cargo__Problem` `P` WHERE `P`.`Region`='Ji'nan, China' ORDER BY COUNT(*) LIMIT 100
Function: CargoSQLQuery::run Query: SELECT COUNT(*) AS `Total Solution` FROM `cargo__Solution` `S` WHERE `S`.`Region`='Ji'nan, China' ORDER BY COUNT(*) LIMIT 100
Function: CargoSQLQuery::run Query: SELECT COUNT(*) AS `Total Projects` FROM `cargo__Project` `P` WHERE `P`.`Region`='Ji'nan, China' ORDER BY COUNT(*) LIMIT 100
Top Problems in Ji'nan, 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`='Ji'nan, 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 Ji'nan, 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`='Ji'nan, 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 Ji'nan, 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`='Ji'nan, China' ORDER BY `P`.`_pageID`,`P`.`_pageName`,`P`.`_pageID`,CONCAT( LEFT( `P`.`Description`, 200 ), IF( LENGTH( `P`.`Description` ) > 200, '...', ) ),`P`.`feature_image` LIMIT 100