
|
Profi přístroje - EXATHERMNabídka půdních teploměrů značky EXATHERM. SELECT pf.type, ptf.filter_id, ptf.value_id, ptf.value, ptf.value_from, ptf.value_to, pfvd.title, pfvd.description FROM products_to_filters ptf LEFT JOIN products_filters_values_description pfvd ON ptf.value_id = pfvd.value_id AND pfvd.language_id = '1' LEFT JOIN products_filters pf ON ptf.filter_id = pf.filter_id WHERE ptf.product_id IN (SELECT product_id FROM products WHERE product_id = ) |