Personalised Candles

WordPress database error: [Table 'wp_2c3wd.wps3_woocommerce_tax_rate_locations' doesn't exist]
SELECT tax_rate_id, location_code FROM wps3_woocommerce_tax_rate_locations WHERE location_type = 'postcode' AND location_code LIKE '%...%';

WordPress database error: [Table 'wp_2c3wd.wps3_woocommerce_tax_rates' doesn't exist]
SELECT tax_rates.*, COUNT( locations.location_id ) as postcode_count, COUNT( locations2.location_id ) as city_count FROM wps3_woocommerce_tax_rates as tax_rates LEFT OUTER JOIN wps3_woocommerce_tax_rate_locations as locations ON tax_rates.tax_rate_id = locations.tax_rate_id LEFT OUTER JOIN wps3_woocommerce_tax_rate_locations as locations2 ON tax_rates.tax_rate_id = locations2.tax_rate_id WHERE 1=1 AND tax_rate_country IN ( 'IE', '' ) AND tax_rate_state IN ( 'KK', '' ) 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 wps3_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 wps3_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: [Table 'wp_2c3wd.wps3_woocommerce_tax_rates' doesn't exist]
SELECT tax_rates.*, COUNT( locations.location_id ) as postcode_count, COUNT( locations2.location_id ) as city_count FROM wps3_woocommerce_tax_rates as tax_rates LEFT OUTER JOIN wps3_woocommerce_tax_rate_locations as locations ON tax_rates.tax_rate_id = locations.tax_rate_id LEFT OUTER JOIN wps3_woocommerce_tax_rate_locations as locations2 ON tax_rates.tax_rate_id = locations2.tax_rate_id WHERE 1=1 AND tax_rate_country IN ( 'IE', '' ) AND tax_rate_state IN ( 'KK', '' ) AND tax_rate_class = '' AND ( ( locations.location_type IS NULL ) OR ( locations.location_type = 'postcode' AND locations.location_code IN ('R95NV8V','R95 NV8V','R95 NV8V*','R95 NV8*','R95 NV*','R95 N*','R95 *','R95*','R9*','R*','*') AND ( ( locations2.location_type = 'city' AND locations2.location_code = 'KILKENNY, CO. KILKENNY' ) OR NOT EXISTS ( SELECT sub.tax_rate_id FROM wps3_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 = 'KILKENNY, CO. KILKENNY' AND NOT EXISTS ( SELECT sub.tax_rate_id FROM wps3_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

25.00

Start Design

Add to basket