```php
<?php

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

$data = Request::get();

try {

Validator::required($data,['slug']);

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

$query="

SELECT

scp.*,
c.name AS category_name,
ci.name AS city_name

FROM service_city_pages scp

JOIN categories c
ON scp.category_id = c.id

JOIN cities ci
ON scp.city_id = ci.id

WHERE scp.slug=:slug
AND scp.status=1

LIMIT 1

";

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

$stmt->execute([
':slug'=>$data['slug']
]);

$page=$stmt->fetch();

Response::success($page);

}
catch(Exception $e){

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

}