خطای پایگاهدادهٔ وردپرس : [Unknown column 'attr.pa_made' in 'SELECT']
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,
image.guid AS image_url,
pm.priceValidUntil,
pm.availability,
pm.price,
pm.weight,
pm.length,
pm.width,
pm.height,
cat.category,
cat.category_slug,
cat.category_id,
CONCAT(
pm.length,
' × ',
pm.width,
' × ',
pm.height,
' سانتیمتر'
) AS dimension,
attr.brand,
attr.brand_slug,
attr.manufacturer,
attr.countryOfOrigin,
attr.gtin,
attr.size,
attr.pa_karaei,
attr.pa_rayehe,
attr.pa_tam,
attr.pa_color,
attr.pa_identifier,
attr.pa_rade_seni,
attr.pa_sexuality,
attr.pa_model,
attr.`pa_noe-hafeze`,
attr.`pa_forme-mahsul`,
attr.pa_made-shakhes,
attr.pa_vitaminha,
attr.pa_osare,
attr.pa_dose,
attr.pa_spf,
attr.`pa_noe-pust`,
attr.`pa_noe-mu`,
attr.`pa_tahte-lisans`,
attr.pa_warranty,
attr.`pa_color-display`,
attr.`pa_voice-notification`,
attr.`pa_touch-screen`,
attr.pa_memory,
attr.`pa_heart-rate`,
attr.`pa_sherkat-vared`,
attr.pa_ph
FROM wp_posts p
/* -------------------------
PRODUCT META
------------------------- */
LEFT JOIN (
SELECT
post_id,
MAX(CASE WHEN meta_key = '_ia_expireDate' THEN meta_value END) AS priceValidUntil,
MAX(CASE WHEN meta_key = '_stock_status' THEN meta_value END) AS availability,
MAX(CASE WHEN meta_key = '_price' THEN meta_value END) AS price,
MAX(CASE WHEN meta_key = '_weight' THEN meta_value END) AS weight,
MAX(CASE WHEN meta_key = '_length' THEN meta_value END) AS length,
MAX(CASE WHEN meta_key = '_width' THEN meta_value END) AS width,
MAX(CASE WHEN meta_key = '_height' THEN meta_value END) AS height
FROM wp_postmeta
WHERE meta_key IN (
'_ia_expireDate',
'_stock_status',
'_price',
'_weight',
'_length',
'_width',
'_height'
)
GROUP BY post_id
) pm
ON pm.post_id = p.ID
/* -------------------------
THUMBNAIL
------------------------- */
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'
/* -------------------------
CATEGORY
------------------------- */
LEFT JOIN (
SELECT
tr.object_id,
MAX(t.name) AS category,
MAX(t.slug) AS category_slug,
MAX(t.term_id) AS category_id
FROM wp_term_relationships tr
JOIN wp_term_taxonomy tt
ON tt.term_taxonomy_id = tr.term_taxonomy_id
AND tt.taxonomy = 'product_cat'
JOIN wp_terms t
ON t.term_id = tt.term_id
GROUP BY tr.object_id
) cat
ON cat.object_id = p.ID
/* -------------------------
ATTRIBUTES
------------------------- */
LEFT JOIN (
SELECT
tr.object_id,
MAX(CASE
WHEN tt.taxonomy = 'pa_brand'
THEN t.name
END) AS brand,
MAX(CASE
WHEN tt.taxonomy = 'pa_brand'
THEN t.slug
END) AS brand_slug,
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 IN (
'pa_barcode-beynolmelali',
'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 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,
MAX(CASE WHEN tt.taxonomy = 'pa_color'
THEN t.name END) AS pa_color,
MAX(CASE WHEN tt.taxonomy = 'pa_kode-behdasht'
THEN t.name END) AS pa_identifier,
MAX(CASE WHEN tt.taxonomy = 'pa_sexuality'
THEN t.name END) AS pa_sexuality,
MAX(CASE WHEN tt.taxonomy = 'pa_rade_seni' OR tt.taxonomy = 'pa_rade-seni'
THEN t.name END) AS pa_rade_seni,
MAX(CASE WHEN tt.taxonomy = 'pa_model'
THEN t.name END) AS pa_model,
MAX(CASE WHEN tt.taxonomy = 'pa_noe-hafeze'
THEN t.name END) AS `pa_noe-hafeze`,
MAX(CASE WHEN tt.taxonomy = 'pa_forme-mahsul'
THEN t.name END) AS `pa_forme-mahsul`,
MAX(CASE WHEN tt.taxonomy = 'pa_made-shakhes'
THEN t.name END) AS `pa_made-shakhes`,
GROUP_CONCAT(DISTINCT CASE
WHEN tt.taxonomy = 'pa_vitaminha'
THEN t.name
END ORDER BY t.name SEPARATOR '، ') AS pa_vitaminha,
MAX(CASE WHEN tt.taxonomy = 'pa_osare'
THEN t.name END) AS pa_osare,
MAX(CASE WHEN tt.taxonomy = 'pa_dose'
THEN t.name END) AS pa_dose,
MAX(CASE WHEN tt.taxonomy = 'pa_spf'
THEN t.name END) AS pa_spf,
MAX(CASE WHEN tt.taxonomy = 'pa_noe-pust'
THEN t.name END) AS `pa_noe-pust`,
MAX(CASE WHEN tt.taxonomy = 'pa_noe-mu'
THEN t.name END) AS `pa_noe-mu`,
MAX(CASE WHEN tt.taxonomy = 'pa_tahte-lisans'
THEN t.name END) AS `pa_tahte-lisans`,
MAX(CASE WHEN tt.taxonomy = 'pa_warranty'
THEN t.name END) AS pa_warranty,
MAX(CASE WHEN tt.taxonomy = 'pa_color-display'
THEN t.name END) AS `pa_color-display`,
MAX(CASE WHEN tt.taxonomy = 'pa_voice-notification'
THEN t.name END) AS `pa_voice-notification`,
MAX(CASE WHEN tt.taxonomy = 'pa_touch-screen'
THEN t.name END) AS `pa_touch-screen`,
MAX(CASE WHEN tt.taxonomy = 'pa_memory'
THEN t.name END) AS pa_memory,
MAX(CASE WHEN tt.taxonomy = 'pa_heart-rate'
THEN t.name END) AS `pa_heart-rate`,
MAX(CASE WHEN tt.taxonomy = 'pa_sherkat-vared'
THEN t.name END) AS `pa_sherkat-vared`,
MAX(CASE WHEN tt.taxonomy = 'pa_ph'
THEN t.name END) AS pa_ph
FROM wp_term_relationships tr
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 tt.taxonomy LIKE 'pa_%'
GROUP BY tr.object_id
) attr
ON attr.object_id = p.ID
WHERE p.ID = 14733
AND p.post_type = 'product'
AND p.post_status = 'publish';
(0 دیدگاه) برای کاندوم شادو مدل Max Delay بسته 3 عددی