```php
<?php

require_once '../../core/api_bootstrap.php';

$data = Request::get();

try {

$db = new Database();
$conn = $db->connect();

$query="

SELECT

scp.id,
scp.slug,
scp.title,
scp.status,
scp.created_at,

c.name AS category_name,
sc.name AS sub_category_name,
ci.name AS city_name

FROM service_city_pages scp

LEFT JOIN categories c
ON scp.category_id = c.id

LEFT JOIN sub_categories sc
ON scp.sub_category_id = sc.id

LEFT JOIN cities ci
ON scp.city_id = ci.id

ORDER BY scp.created_at DESC

";

$stmt=$conn->prepare($query);
$stmt->execute();

$pages=$stmt->fetchAll();

Response::success($pages);

}
catch(Exception $e){

Logger::log("system.log",$e->getMessage());
Response::error("Server error",500);

}