Online PHP editor | refs for vF8YV

<?php $prod_get_attr = "SELECT oca.product_id, pr.price, pr.image, pd.name FROM oc_product_attribute AS oca LEFT JOIN oc_product AS pr ON pr.product_id = oca.product_id LEFT JOIN oc_product_description AS pd ON pd.product_id = oca.product_id WHERE text IN ('" . $get_material_item . "') AND oca.product_id IN ( SELECT oca2.product_id FROM oc_product_attribute AS oca2 WHERE text IN ('" . $get_ves_item . "') ) GROUP BY oca.product_id"; // получаем id товаров, выбранных атрибутов Вес и материал $query_prod_get_attr = mysqli_query($dbh, $prod_get_attr); var_dump($query_prod_get_attr);