Die Panasonic Marketing Europe GmbH, Wiesbaden, bietet den Plug-and-Play CO2-Verflüssigungssatz "Cr400" für die Gewerbekälte an. (Abb. © Panasonic Marketing Europe GmbH)
18.03.2022
Die Güntner Group Europe GmbH, Fürstenfeldbruck, bietet den Lüftkühler "Mini Compact" an. Der Lüftkühler ist an den Kühlbedarf von Lebensmittelhändlern, Restaurants, Kantinen und ähnlichen Anwendungsbereichen ausgerichtet. (Abb. © Güntner GmbH)
21.01.2022
Wärmeübertrager – Ventilatorbelüftete Kältemittelverflüssiger und Trockenkühltürme – Schallmessung
05.03.2018
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = 'wertig' ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )
WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (13450)
) AND (
wp_postmeta.post_id IS NULL
OR
( mt1.meta_key = 'wertig' AND mt1.meta_value = '1' )
OR
( mt1.meta_key = 'wertig' AND mt1.meta_value = '0' )
) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'tribe-ea-success' OR wp_posts.post_status = 'tribe-ea-failed' OR wp_posts.post_status = 'tribe-ea-schedule' OR wp_posts.post_status = 'tribe-ea-pending' OR wp_posts.post_status = 'tribe-ea-draft')))
GROUP BY wp_posts.ID
ORDER BY wp_postmeta.meta_value+0 DESC, wp_posts.post_date DESC
LIMIT 0, 12
