خطای پایگاهدادهٔ وردپرس : [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.taxonomy,
GROUP_CONCAT(
DISTINCT CASE
...' at line 63]
SELECT
p.ID,
CASE
WHEN EXISTS (
SELECT 1
FROM wp_term_relationships ptr
WHERE ptr.object_id = p.ID
AND ptr.term_taxonomy_id = 4
)
THEN 'variable'
ELSE 'simple'
END AS type,
p.post_title,
MAX(image.guid) AS image_url,
MAX( CASE WHEN pm.meta_key = '_ia_expireDate' THEN pm.meta_value END) AS priceValidUntil,
MAX( CASE WHEN pm.meta_key = '_stock_status' THEN pm.meta_value END) AS availability,
MAX( CASE WHEN pm.meta_key = '_price' THEN pm.meta_value END) AS price,
MAX(CASE WHEN tt.taxonomy = 'product_cat' THEN t.name END) AS category,
MAX(CASE WHEN tt.taxonomy = 'product_cat' THEN t.slug END) AS category_slug,
MAX(CASE WHEN tt.taxonomy = 'product_cat' THEN t.term_id END) AS category_id,
MAX( CASE WHEN pm.meta_key = '_weight' THEN pm.meta_value END) AS weight,
CONCAT(
MAX(CASE WHEN pm.meta_key = '_length' THEN pm.meta_value END),
' × ',
MAX(CASE WHEN pm.meta_key = '_width' THEN pm.meta_value END),
' × ',
MAX(CASE WHEN pm.meta_key = '_height' THEN pm.meta_value END),
' سانتیمتر'
) AS dimension,
MAX( CASE WHEN tt.taxonomy = 'pa_brand' THEN t.name END) AS brand,
MAX( CASE WHEN tt.taxonomy IN ('pa_sherkat-tolid','pa_sherkate-tolid') THEN t.name END ) AS manufacturer,
MAX( CASE WHEN tt.taxonomy = 'pa_keshvare-tolid' THEN t.name END ) AS countryOfOrigin,
MAX( CASE WHEN tt.taxonomy = 'pa_barcode_-beynolmelali'THEN t.name END) AS gtin,
MAX(
CASE
WHEN tt.taxonomy IN (
'pa_size',
'pa_meghdar',
'pa_volume',
'pa_tedad-dar-baste',
'pa_quantity'
)
THEN t.name
END
) AS pa_size,
GROUP_CONCAT(
DISTINCT CASE WHEN tt.taxonomy = 'pa_karaei' THEN t.name END
ORDER BY t.name
SEPARATOR '، '
) AS tt.taxonomy,
GROUP_CONCAT(
DISTINCT CASE
WHEN tt.taxonomy = 'pa_rayehe'
THEN t.name
END
ORDER BY t.name
SEPARATOR '، '
) AS tt.taxonomy,
GROUP_CONCAT(
DISTINCT CASE
WHEN tt.taxonomy = 'pa_tam'
THEN t.name
END
ORDER BY t.name
SEPARATOR '، '
) AS tt.taxonomy,
MAX(CASE WHEN tt.taxonomy = 'pa_color' THEN t.name END) AS tt.taxonomy,
MAX(CASE WHEN tt.taxonomy = 'pa_kode-behdasht' THEN t.name END) AS tt.taxonomy,
MAX(CASE WHEN tt.taxonomy = 'pa_sexuality' THEN t.name END) AS tt.taxonomy,
MAX(CASE WHEN tt.taxonomy = 'pa_model' THEN t.name END) AS tt.taxonomy,
MAX(CASE WHEN tt.taxonomy = 'pa_noe-hafeze' THEN t.name END) AS tt.taxonomy,
MAX(CASE WHEN tt.taxonomy = 'pa_forme-mahsul' THEN t.name END) AS tt.taxonomy,
MAX(CASE WHEN tt.taxonomy = 'pa_vitaminha' THEN t.name END) AS tt.taxonomy,
MAX(CASE WHEN tt.taxonomy = 'pa_osare' THEN t.name END) AS tt.taxonomy,
MAX(CASE WHEN tt.taxonomy = 'pa_dose' THEN t.name END) AS tt.taxonomy,
MAX(CASE WHEN tt.taxonomy = 'pa_spf' THEN t.name END) AS tt.taxonomy,
MAX(CASE WHEN tt.taxonomy = 'pa_noe-pust' THEN t.name END) AS tt.taxonomy,
MAX(CASE WHEN tt.taxonomy = 'pa_noe-mu' THEN t.name END) AS tt.taxonomy,
MAX(CASE WHEN tt.taxonomy = 'pa_tahte-lisans' THEN t.name END) AS tt.taxonomy,
MAX(CASE WHEN tt.taxonomy = 'pa_warranty' THEN t.name END) AS tt.taxonomy,
MAX(CASE WHEN tt.taxonomy = 'pa_color-display' THEN t.name END) AS tt.taxonomy,
MAX(CASE WHEN tt.taxonomy = 'pa_voice-notification' THEN t.name END) AS tt.taxonomy,
MAX(CASE WHEN tt.taxonomy = 'pa_touch-screen' THEN t.name END) AS tt.taxonomy,
MAX(CASE WHEN tt.taxonomy = 'pa_memory' THEN t.name END) AS tt.taxonomy,
MAX(CASE WHEN tt.taxonomy = 'pa_heart-rate' THEN t.name END) AS tt.taxonomy,
MAX(CASE WHEN tt.taxonomy = 'pa_sherkat-vared' THEN t.name END) AS tt.taxonomy,
MAX(CASE WHEN tt.taxonomy = 'pa_ph' THEN t.name END) AS tt.taxonomy
FROM wp_posts p
LEFT JOIN wp_postmeta pm
ON pm.post_id = p.ID
AND pm.meta_key IN (
'_weight',
'_length',
'_width',
'_height',
'_stock_status',
'_ia_expireDate',
'_price'
)
JOIN wp_postmeta thumb
ON thumb.post_id = p.ID
AND thumb.meta_key = '_thumbnail_id'
JOIN wp_posts image
ON image.ID = CAST(thumb.meta_value AS UNSIGNED)
AND image.post_type = 'attachment'
JOIN wp_term_relationships tr
ON tr.object_id = p.ID
JOIN wp_term_taxonomy tt
ON tt.term_taxonomy_id = tr.term_taxonomy_id
AND tt.taxonomy IN (
'product_cat',
'pa_brand',
'pa_sherkat-tolid',
'pa_sherkate-tolid',
'pa_keshvare-tolid',
'pa_barcode-beynolmelali',
'pa_size',
'pa_color',
'pa_meghdar',
'pa_volume',
'pa_tedad-dar-baste',
'pa_quantity',
'pa_kode-behdasht',
'pa_rade-seni',
'pa_made-shakhes',
'pa_sexuality',
'pa_model',
'pa_noe-hafeze',
'pa_karaei',
'pa_forme-mahsul',
'pa_vitaminha',
'pa_osare',
'pa_dose',
'pa_karaei',
'pa_tam',
'pa_rayehe',
'pa_spf',
'pa_noe-pust',
'pa_noe-mu',
'pa_tahte-lisans',
'pa_warranty',
'pa_color-display',
'pa_voice-notification',
'pa_touch-screen',
'pa_memory',
'pa_heart-rate',
'pa_sherkat-vared',
'pa_heart-rate',
'pa_ph',
'pa_weight'
)
JOIN wp_terms t
ON t.term_id = tt.term_id
WHERE p.post_type = 'product'
AND p.post_status = 'publish'
GROUP BY p.ID, p.post_title;