- Sort by Default Order
- Display 21 Products per page
WordPress database error: [Table 'azevahu1_rockp.wp_woocommerce_tax_rate_locations' doesn't exist]
SELECT tax_rates.*
FROM wp_woocommerce_tax_rates as tax_rates
LEFT OUTER JOIN wp_woocommerce_tax_rate_locations as locations ON tax_rates.tax_rate_id = locations.tax_rate_id
LEFT OUTER JOIN wp_woocommerce_tax_rate_locations as locations2 ON tax_rates.tax_rate_id = locations2.tax_rate_id
WHERE tax_rate_country IN ( 'HU', '' )
AND tax_rate_state IN ( 'FE', '' )
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 0 = (
SELECT COUNT(*) FROM wp_woocommerce_tax_rate_locations as sublocations
WHERE sublocations.location_type = 'city'
AND sublocations.tax_rate_id = tax_rates.tax_rate_id
)
)
)
OR (
locations.location_type = 'city'
AND locations.location_code = ''
AND 0 = (
SELECT COUNT(*) FROM wp_woocommerce_tax_rate_locations as sublocations
WHERE sublocations.location_type = 'postcode'
AND sublocations.tax_rate_id = tax_rates.tax_rate_id
)
)
)
GROUP BY tax_rate_id
ORDER BY tax_rate_priority, tax_rate_order