WordPress database error: [File './arpresso_wp779/wprqmp_woocommerce_tax_rate_locations.MYD' not found (Errcode: 2 - No such file or directory)]
SELECT tax_rate_id, location_code FROM wprqmp_woocommerce_tax_rate_locations WHERE location_type = 'postcode' AND location_code LIKE '%...%';
WordPress database error: [File './arpresso_wp779/wprqmp_woocommerce_tax_rates.MYD' not found (Errcode: 2 - No such file or directory)]
SELECT tax_rates.*, COUNT( locations.location_id ) as postcode_count, COUNT( locations2.location_id ) as city_count
FROM wprqmp_woocommerce_tax_rates as tax_rates
LEFT OUTER JOIN wprqmp_woocommerce_tax_rate_locations as locations ON tax_rates.tax_rate_id = locations.tax_rate_id
LEFT OUTER JOIN wprqmp_woocommerce_tax_rate_locations as locations2 ON tax_rates.tax_rate_id = locations2.tax_rate_id
WHERE 1=1 AND tax_rate_country IN ( 'US', '' ) AND tax_rate_state IN ( 'IL', '' ) 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 wprqmp_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 wprqmp_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
WordPress database error: [File './arpresso_wp779/wprqmp_woocommerce_tax_rate_locations.MYD' not found (Errcode: 2 - No such file or directory)]
SELECT tax_rate_id, location_code FROM wprqmp_woocommerce_tax_rate_locations WHERE location_type = 'postcode' AND location_code LIKE '%...%';
WordPress database error: [File './arpresso_wp779/wprqmp_woocommerce_tax_rates.MYD' not found (Errcode: 2 - No such file or directory)]
SELECT tax_rates.*, COUNT( locations.location_id ) as postcode_count, COUNT( locations2.location_id ) as city_count
FROM wprqmp_woocommerce_tax_rates as tax_rates
LEFT OUTER JOIN wprqmp_woocommerce_tax_rate_locations as locations ON tax_rates.tax_rate_id = locations.tax_rate_id
LEFT OUTER JOIN wprqmp_woocommerce_tax_rate_locations as locations2 ON tax_rates.tax_rate_id = locations2.tax_rate_id
WHERE 1=1 AND tax_rate_country IN ( 'US', '' ) AND tax_rate_state IN ( 'IL', '' ) AND tax_rate_class = '' AND ( ( locations.location_type IS NULL ) OR (
locations.location_type = 'postcode' AND locations.location_code IN ('60139','60139*','6013*','601*','60*','6*','*')
AND (
( locations2.location_type = 'city' AND locations2.location_code = 'CHICAGO' )
OR NOT EXISTS (
SELECT sub.tax_rate_id FROM wprqmp_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 = 'CHICAGO'
AND NOT EXISTS (
SELECT sub.tax_rate_id FROM wprqmp_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
Reviews
There are no reviews yet.