<?php
$pdo = require 'config/database.php';
$res = $pdo->query('SELECT COUNT(*) FROM seo_landings')->fetchColumn();
echo "Total Landings: $res\n";

$res = $pdo->query('SELECT COUNT(*) FROM seo_landings WHERE focus_keyword IS NOT NULL AND focus_keyword != ""')->fetchColumn();
echo "Optimized Landings: $res\n";

$res = $pdo->query('SELECT id, slug, focus_keyword FROM seo_landings WHERE focus_keyword IS NULL OR focus_keyword = "" LIMIT 10')->fetchAll();
print_r($res);
