K'alak'i T'bilisi: Difference between revisions
(Created page with " {{Region |Description= |geonameId=611716 |population=1106539 |fcode=ADM1 |coord=41° 43' 0.012" N, 44° 49' 59.988" E }} Category:Region Category:K'alak'i T'bilisi") |
No edit summary |
||
Line 1: | Line 1: | ||
{{Region | |||
|Description= | |||
|geonameId=611716 | |||
|population=1106539 | |||
|fcode=ADM1 | |||
|coord=41° 43' 0.012" N, 44° 49' 59.988" E | |||
}} | |||
[[Category:Region]] | |||
[[Category:K'alak'i T'bilisi]] | |||
Latest revision as of 11:56, 18 May 2023
Function: CargoSQLQuery::run Query: SELECT COUNT(*) AS `Total Problems` FROM `cargo__Problem` `P` WHERE `P`.`Region`='K'alak'i T'bilisi' ORDER BY COUNT(*) LIMIT 100
Function: CargoSQLQuery::run Query: SELECT COUNT(*) AS `Total Solution` FROM `cargo__Solution` `S` WHERE `S`.`Region`='K'alak'i T'bilisi' ORDER BY COUNT(*) LIMIT 100
Function: CargoSQLQuery::run Query: SELECT COUNT(*) AS `Total Projects` FROM `cargo__Project` `P` WHERE `P`.`Region`='K'alak'i T'bilisi' ORDER BY COUNT(*) LIMIT 100
Top Problems in K'alak'i T'bilisi
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`='K'alak'i T'bilisi' 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 K'alak'i T'bilisi
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`='K'alak'i T'bilisi' 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 K'alak'i T'bilisi
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`='K'alak'i T'bilisi' ORDER BY `P`.`_pageID`,`P`.`_pageName`,`P`.`_pageID`,CONCAT( LEFT( `P`.`Description`, 200 ), IF( LENGTH( `P`.`Description` ) > 200, '...', ) ),`P`.`feature_image` LIMIT 100