<?php
// Temporary query script - DELETE AFTER USE
include_once dirname(__FILE__) . '/../../config/config.inc.php';

$sql = "SELECT p.id_product, pl.name AS product_name, fl.name AS feature_name, fvl.value AS feature_value
FROM ps_feature_product fp
JOIN ps_feature_lang fl ON fp.id_feature = fl.id_feature AND fl.id_lang = 1
JOIN ps_feature_value_lang fvl ON fp.id_feature_value = fvl.id_feature_value AND fvl.id_lang = 1
JOIN ps_product p ON fp.id_product = p.id_product
JOIN ps_product_lang pl ON p.id_product = pl.id_product AND pl.id_lang = 1
WHERE fl.name = 'Seria' AND fvl.value = 'Simon 10'
ORDER BY p.id_product
LIMIT 20";

header('Content-Type: text/plain; charset=utf-8');
$results = Db::getInstance()->executeS($sql);
if ($results) {
    foreach ($results as $row) {
        echo $row['id_product'] . ' | ' . $row['product_name'] . ' | ' . $row['feature_name'] . ' -> ' . $row['feature_value'] . "\n";
    }
} else {
    echo "Brak wynikow\n";
}