Fotométerek (Klór, Mangán, Vas, stb..)
5–8 termék, összesen 8 db
WordPress adatbázis hiba: [Table 'labornit_lab211.wp76_woocommerce_tax_rate_locations' doesn't exist]SELECT tax_rate_id, location_code FROM wp76_woocommerce_tax_rate_locations WHERE location_type = 'postcode' AND location_code LIKE '%...%';
WordPress adatbázis hiba: [Table 'labornit_lab211.wp76_woocommerce_tax_rate_locations' doesn't exist]
SELECT tax_rates.*, COUNT( locations.location_id ) as postcode_count, COUNT( locations2.location_id ) as city_count
FROM wp76_woocommerce_tax_rates as tax_rates
LEFT OUTER JOIN wp76_woocommerce_tax_rate_locations as locations ON tax_rates.tax_rate_id = locations.tax_rate_id
LEFT OUTER JOIN wp76_woocommerce_tax_rate_locations as locations2 ON tax_rates.tax_rate_id = locations2.tax_rate_id
WHERE 1=1 AND tax_rate_country IN ( 'HU', '' ) AND tax_rate_state IN ( '', '' ) AND tax_rate_class = '' AND ( ( locations.location_type IS NULL ) OR (
locations.location_type = 'postcode' AND locations.location_code IN ('','*')
AND (
( locations2.location_type = 'city' AND locations2.location_code = '' )
OR NOT EXISTS (
SELECT sub.tax_rate_id FROM wp76_woocommerce_tax_rate_locations as sub
WHERE sub.location_type = 'city'
AND sub.tax_rate_id = tax_rates.tax_rate_id
)
)
) OR (
locations.location_type = 'city' AND locations.location_code = ''
AND NOT EXISTS (
SELECT sub.tax_rate_id FROM wp76_woocommerce_tax_rate_locations as sub
WHERE sub.location_type = 'postcode'
AND sub.tax_rate_id = tax_rates.tax_rate_id
)
) )
GROUP BY tax_rates.tax_rate_id
ORDER BY tax_rates.tax_rate_priority
5–8 termék, összesen 8 db