<?php

if( php_sapi_name() !== 'cli' ) {
    die("Meant to be run from command line");
}

if (!empty($argv[1])) {
    define('APPLICATION_ENV', $argv[1]);
} else {
    define('APPLICATION_ENV', 'production');
}

define( 'BASE_PATH', './public/' );
define('WP_USE_THEMES', false);
global $wp, $wp_query, $wp_the_query, $wp_rewrite, $wp_did_header, $wpdb;
require(BASE_PATH . 'wp-load.php');

$rows = $wpdb->get_results('SELECT * FROM products WHERE category_id = 1 AND brand_id = 2');

$words = [];
foreach($rows as $row) {
    $data = $wpdb->get_results('SELECT * FROM params WHERe product_id = ' . $row->id);
    foreach($data as $subRow) {
        $words[] = $subRow->name;
        $words[] = $subRow->value;
    }
    $words[] = $row->title;
    $group = json_decode($row->group);
    foreach($group as $groupName => $params) {
        $words[] = $groupName;
        foreach($params as $paramName => $paramDimensions) {
            $words[] = $paramName;
            $words[] = $paramDimensions;
        }
    }
}

echo implode(PHP_EOL, array_unique($words));