Département de l'Artibonite: Difference between revisions
(Created page with " {{Region |Description= |geonameId=3731053 |population=1727524 |fcode=ADM1 |coord=19° 19' 59.988" N, 72° 8670' 1040400.0" W }} Category:Region Category:Département de l'Artibonite") |
No edit summary |
||
Line 1: | Line 1: | ||
{{Region | |||
|Description= | |||
|geonameId=3731053 | |||
|population=1727524 | |||
|fcode=ADM1 | |||
|coord=19° 19' 59.988" N, 72° 8670' 1040400.0" W | |||
}} | |||
[[Category:Region]] | |||
[[Category:Département de l'Artibonite]] | |||
Latest revision as of 13:42, 18 May 2023
Function: CargoSQLQuery::run Query: SELECT COUNT(*) AS `Total Problems` FROM `cargo__Problem` `P` WHERE `P`.`Region`='Département de l'Artibonite' ORDER BY COUNT(*) LIMIT 100
Function: CargoSQLQuery::run Query: SELECT COUNT(*) AS `Total Solution` FROM `cargo__Solution` `S` WHERE `S`.`Region`='Département de l'Artibonite' ORDER BY COUNT(*) LIMIT 100
Function: CargoSQLQuery::run Query: SELECT COUNT(*) AS `Total Projects` FROM `cargo__Project` `P` WHERE `P`.`Region`='Département de l'Artibonite' ORDER BY COUNT(*) LIMIT 100
Top Problems in Département de l'Artibonite
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`='Département de l'Artibonite' 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 Département de l'Artibonite
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`='Département de l'Artibonite' 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 Département de l'Artibonite
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`='Département de l'Artibonite' ORDER BY `P`.`_pageID`,`P`.`_pageName`,`P`.`_pageID`,CONCAT( LEFT( `P`.`Description`, 200 ), IF( LENGTH( `P`.`Description` ) > 200, '...', ) ),`P`.`feature_image` LIMIT 100