WordPress veri tabanı sorunu: [Table 'admin_omnicrea.Fk989DeQl_woocommerce_tax_rate_locations' doesn't exist]
SELECT tax_rate_id, location_code FROM Fk989DeQl_woocommerce_tax_rate_locations WHERE location_type = 'postcode' AND location_code LIKE '%...%';
WordPress veri tabanı sorunu: [Table 'admin_omnicrea.Fk989DeQl_woocommerce_tax_rates' doesn't exist]
SELECT tax_rates.*, COUNT( locations.location_id ) as postcode_count, COUNT( locations2.location_id ) as city_count
FROM Fk989DeQl_woocommerce_tax_rates as tax_rates
LEFT OUTER JOIN Fk989DeQl_woocommerce_tax_rate_locations as locations ON tax_rates.tax_rate_id = locations.tax_rate_id
LEFT OUTER JOIN Fk989DeQl_woocommerce_tax_rate_locations as locations2 ON tax_rates.tax_rate_id = locations2.tax_rate_id
WHERE 1=1 AND tax_rate_country IN ( 'TR', '' ) AND tax_rate_state IN ( 'TR35', '' ) 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 Fk989DeQl_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 Fk989DeQl_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
Değerlendirmeler
Henüz değerlendirme yapılmadı.