خطای پایگاهدادهٔ وردپرس : [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 'pa_brand',
'pa_sherkat-tolid',
...' at line 85]
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 pa_karaei,
GROUP_CONCAT(
DISTINCT CASE
WHEN tt.taxonomy = 'pa_rayehe'
THEN t.name
END
ORDER BY t.name
SEPARATOR '، '
) AS pa_rayehe,
GROUP_CONCAT(
DISTINCT CASE
WHEN tt.taxonomy = 'pa_tam'
THEN t.name
END
ORDER BY t.name
SEPARATOR '، '
) AS pa_tam,
GROUP_CONCAT(
DISTINCT CASE
WHEN tt.taxonomy LIKE 'pa\_%' ESCAPE '\'
AND tt.taxonomy NOT IN (
'pa_brand',
'pa_sherkat-tolid',
'pa_sherkate-tolid',
'pa_keshvare-tolid',
'pa_barcode-beynolmelali',
'pa_size',
'pa_meghdar',
'pa_volume',
'pa_tedad-dar-baste',
'pa_quantity'
)
THEN CONCAT(
SUBSTRING(tt.taxonomy, 4),
'=',
t.name
)
END
SEPARATOR '|||'
) AS attributes
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
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;