<?php
$conn = new mysqli('host117523.hostido.net.pl', 'host117523_wyszynskiego12pagedevpl', 'yZs52KdErtTk9KmZ8XGq', 'host117523_wyszynskiego12pagedevpl');
if ($conn->connect_error) { die('Blad: ' . $conn->connect_error); }

echo "=== APARTAMENTY z ceną ===\n";
$sql = "SELECT p.ID, p.post_title,
    MAX(CASE WHEN pm.meta_key = 'information_price' THEN pm.meta_value END) as price,
    MAX(CASE WHEN pm.meta_key = 'information_price_m2' THEN pm.meta_value END) as price_m2,
    MAX(CASE WHEN pm.meta_key = 'information_floor_space' THEN pm.meta_value END) as floor_space
    FROM wp_posts p
    JOIN wp_postmeta pm ON p.ID = pm.post_id
    WHERE p.post_type = 'apartamenty'
    AND p.post_status = 'publish'
    GROUP BY p.ID, p.post_title
    ORDER BY p.post_title LIMIT 10";
$r = $conn->query($sql);
while($row = $r->fetch_assoc()) {
    echo $row['ID'] . ' | ' . $row['post_title'] . ' | price: ' . $row['price'] . ' | price_m2: ' . $row['price_m2'] . ' | m2: ' . $row['floor_space'] . "\n";
}

$conn->close();