خطای پایگاهدادهٔ وردپرس : [Unknown column 'p.ID' in 'ON']
SELECT
v.ID,
v.post_parent,
v.post_title,
image.guid AS image,
MAX( CASE WHEN pm.meta_key = '_ia_expireDate' THEN pm.meta_value END ) AS expire_date,
MAX( CASE WHEN pm.meta_key = '_stock_status'THEN pm.meta_value END) AS stock_status,
MAX( CASE WHEN pm.meta_key = '_price' THEN pm.meta_value END) AS price,
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,
REPLACE(pm1.meta_key, 'attribute_pa_', '') AS attribute_key,
pm1.meta_value AS attribute_value,
t.name AS attribute_name
FROM wp_posts v
JOIN wp_postmeta pm
ON pm.post_id = v.ID
AND pm.meta_key IN (
'_ia_expireDate',
'_stock_status',
'_price',
'_weight',
'_length',
'_width',
'_height'
)
JOIN wp_postmeta pm1
ON pm1.post_id = v.ID
AND pm1.meta_key LIKE 'attribute_%'
JOIN wp_term_taxonomy tt
ON tt.taxonomy = REPLACE(pm1.meta_key, 'attribute_', '')
JOIN wp_terms t
ON tt.term_id = t.term_id
AND t.slug = pm1.meta_value
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'
WHERE v.post_parent = 2206516
AND v.post_type = 'product_variation'
AND v.post_status = 'publish'
GROUP BY
v.ID,
v.post_parent,
pm1.meta_key,
pm1.meta_value,
t.name;
{
"@context": "https://schema.org",
"@graph": [
{
"@type": "Organization",
"@id": "https://mosbatsefid.ir/#organization",
"name": "داروخانه آنلاین مثبت سبز",
"sameAs": [
"https://www.facebook.com/mosbatesabz",
"https://t.me/mosbatesabz_pharmacy/",
"https://www.aparat.com/mosbatesabz",
"https://eitaa.com/mosbatesabz_pharmacy/",
"https://youtube.com/channel/UCXTihABU1ZQAo7Jau5sJllg/"
],
"logo": {
"@type": "ImageObject",
"@id": "https://mosbatsefid.ir/#logo",
"url": "https://mosbatesabz.com/wp-content/uploads/2025/02/Logo-Site.svg",
"contentUrl": "https://mosbatesabz.com/wp-content/uploads/2025/02/Logo-Site.svg",
"caption": "داروخانه آنلاین مثبت سبز",
"inLanguage": "fa-IR",
"width": 188,
"height": 56
}
},
{
"@type": "WebSite",
"@id": "https://mosbatsefid.ir/#website",
"url": "https://mosbatsefid.ir",
"name": "داروخانه آنلاین مثبت سبز",
"alternateName": "Mosbatesabz",
"publisher": {
"@id": "https://mosbatsefid.ir/#organization"
},
"inLanguage": "fa-IR"
},
{
"@type": "ImageObject",
"@id": "https://mosbatsefid.ir/wp-content/uploads/2024/06/OPD-Pharma-Magnesium-300-Mg-20-Sachets.jpg",
"url": "https://mosbatsefid.ir/wp-content/uploads/2024/06/OPD-Pharma-Magnesium-300-Mg-20-Sachets.jpg",
"width": 1024,
"height": 1024,
"caption": "قیمت ساشه منیزیم 300 میلی گرم او پی دی فارما",
"inLanguage": "fa-IR"
},
{
"@type": "BreadcrumbList",
"@id": "https://mosbatsefid.ir/product/opd-pharma-magnesium-300-mg-sachets/#breadcrumb",
"itemListElement": [
{
"@type": "ListItem",
"position": 1,
"item": {
"@id": "https://mosbatesabz.com",
"name": "داروخانه آنلاین مثبت سبز"
}
},
{
"@type": "ListItem",
"position": 2,
"item": {
"@id": "https://mosbatsefid.ir/product-category/supplements-2/mineral/magnesium/",
"name": "منیزیم"
}
},
{
"@type": "ListItem",
"position": 3,
"item": {
"@id": "https://mosbatsefid.ir/product/opd-pharma-magnesium-300-mg-sachets/",
"name": "ساشه منیزیم 300 میلی گرم او پی دی فارما 20 عدد"
}
}
]
},
{
"@type": "WebPage",
"@id": "https://mosbatsefid.ir/product/opd-pharma-magnesium-300-mg-sachets/#webpage",
"url": "https://mosbatsefid.ir/product/opd-pharma-magnesium-300-mg-sachets/",
"name": "خرید و قیمت ساشه منیزیم 300 میلی گرم او پی دی فارما",
"datePublished": "2024-06-19T12:00:37+03:30",
"dateModified": "2026-08-16T03:35:35+03:30",
"isPartOf": {
"@id": "https://mosbatsefid.ir/#website"
},
"primaryImageOfPage": {
"@id": "https://mosbatsefid.ir/wp-content/uploads/2024/06/OPD-Pharma-Magnesium-300-Mg-20-Sachets.jpg"
},
"inLanguage": "fa-IR",
"breadcrumb": {
"@id": "https://mosbatsefid.ir/product/opd-pharma-magnesium-300-mg-sachets/#breadcrumb"
}
},
{
"publisher": {
"@type": "Organization",
"@id": "https://mosbatsefid.ir/#organization",
"name": "داروخانه آنلاین مثبت سبز",
"sameAs": [
"https://www.facebook.com/mosbatesabz",
"https://t.me/mosbatesabz_pharmacy/",
"https://www.aparat.com/mosbatesabz",
"https://eitaa.com/mosbatesabz_pharmacy/",
"https://youtube.com/channel/UCXTihABU1ZQAo7Jau5sJllg/"
],
"logo": {
"@type": "ImageObject",
"@id": "https://mosbatsefid.ir/#logo",
"url": "https://mosbatesabz.com/wp-content/uploads/2025/02/Logo-Site.svg",
"contentUrl": "https://mosbatesabz.com/wp-content/uploads/2025/02/Logo-Site.svg",
"caption": "داروخانه آنلاین مثبت سبز",
"inLanguage": "fa-IR",
"width": 188,
"height": 56
}
},
"WebSite": {
"@type": "WebSite",
"@id": "https://mosbatsefid.ir/#website",
"url": "https://mosbatsefid.ir",
"name": "داروخانه آنلاین مثبت سبز",
"alternateName": "Mosbatesabz",
"publisher": {
"@id": "https://mosbatsefid.ir/#organization"
},
"inLanguage": "fa-IR"
},
"primaryImage": {
"@type": "ImageObject",
"@id": "https://mosbatsefid.ir/wp-content/uploads/2024/06/OPD-Pharma-Magnesium-300-Mg-20-Sachets.jpg",
"url": "https://mosbatsefid.ir/wp-content/uploads/2024/06/OPD-Pharma-Magnesium-300-Mg-20-Sachets.jpg",
"width": 1024,
"height": 1024,
"caption": "قیمت ساشه منیزیم 300 میلی گرم او پی دی فارما",
"inLanguage": "fa-IR"
},
"BreadcrumbList": {
"@type": "BreadcrumbList",
"@id": "https://mosbatsefid.ir/product/opd-pharma-magnesium-300-mg-sachets/#breadcrumb",
"itemListElement": [
{
"@type": "ListItem",
"position": 1,
"item": {
"@id": "https://mosbatesabz.com",
"name": "داروخانه آنلاین مثبت سبز"
}
},
{
"@type": "ListItem",
"position": 2,
"item": {
"@id": "https://mosbatsefid.ir/product-category/supplements-2/mineral/magnesium/",
"name": "منیزیم"
}
},
{
"@type": "ListItem",
"position": 3,
"item": {
"@id": "https://mosbatsefid.ir/product/opd-pharma-magnesium-300-mg-sachets/",
"name": "ساشه منیزیم 300 میلی گرم او پی دی فارما 20 عدد"
}
}
]
},
"WebPage": {
"@type": "WebPage",
"@id": "https://mosbatsefid.ir/product/opd-pharma-magnesium-300-mg-sachets/#webpage",
"url": "https://mosbatsefid.ir/product/opd-pharma-magnesium-300-mg-sachets/",
"name": "خرید و قیمت ساشه منیزیم 300 میلی گرم او پی دی فارما",
"datePublished": "2024-06-19T12:00:37+03:30",
"dateModified": "2026-08-16T03:35:35+03:30",
"isPartOf": {
"@id": "https://mosbatsefid.ir/#website"
},
"primaryImageOfPage": {
"@id": "https://mosbatsefid.ir/wp-content/uploads/2024/06/OPD-Pharma-Magnesium-300-Mg-20-Sachets.jpg"
},
"inLanguage": "fa-IR",
"breadcrumb": {
"@id": "https://mosbatsefid.ir/product/opd-pharma-magnesium-300-mg-sachets/#breadcrumb"
}
},
"ProfilePage": {
"@type": "Person",
"@id": "https://mosbatsefid.ir/product/opd-pharma-magnesium-300-mg-sachets/#author",
"name": "کاربر مثبت سبز",
"description": "",
"url": "",
"image": {
"@type": "ImageObject",
"@id": "https://mosbatsefid.ir/wp-content/uploads/default-avatar.png",
"url": "https://mosbatsefid.ir/wp-content/uploads/default-avatar.png",
"caption": "کاربر مثبت سبز",
"inLanguage": "fa-IR"
},
"worksFor": {
"@id": "https://mosbatsefid.ir/#organization"
}
},
"richSnippet": {
"@type": "ProductGroup",
"name": "خرید و قیمت ساشه منیزیم 300 میلی گرم او پی دی فارما",
"description": "ساشه منیزیم 300 میلی گرم او پی دی فارما به حفظ سلامت سیستم عصبی، سیستم عضلانی، استحکام استخوان و کاهش گرفتگی عضلات کمک نموده و باعث بهبود عملکرد ورزشکار می شود",
"sku": "2206516",
"category": "مکمل غذایی > مواد معدنی > منیزیم",
"mainEntityOfPage": {
"@id": "https://mosbatsefid.ir/product/opd-pharma-magnesium-300-mg-sachets/#webpage"
},
"weight": {
"@type": "QuantitativeValue",
"unitCode": "GRM",
"value": ""
},
"height": {
"@type": "QuantitativeValue",
"unitCode": "CMT",
"value": ""
},
"width": {
"@type": "QuantitativeValue",
"unitCode": "CMT",
"value": ""
},
"depth": {
"@type": "QuantitativeValue",
"unitCode": "CMT",
"value": ""
},
"image": {
"@id": "https://mosbatsefid.ir/wp-content/uploads/2024/06/OPD-Pharma-Magnesium-300-Mg-20-Sachets.jpg"
},
"aggregateRating": {
"@type": "AggregateRating",
"ratingValue": "5.00",
"bestRating": "5",
"ratingCount": 2,
"reviewCount": 2
},
"review": [
{
"@type": "Review",
"@id": "https://mosbatsefid.ir/product/opd-pharma-magnesium-300-mg-sachets/#li-comment-39552597",
"description": "عالی 👍",
"datePublished": "2026-04-18 23:22:55",
"reviewRating": {
"@type": "Rating",
"ratingValue": 5,
"bestRating": "5",
"worstRating": "1"
},
"author": {
"@type": "Person",
"name": "کاربر 1376860",
"url": ""
}
},
{
"@type": "Review",
"@id": "https://mosbatsefid.ir/product/opd-pharma-magnesium-300-mg-sachets/#li-comment-39318801",
"description": "بسیارعالی",
"datePublished": "2026-04-12 22:50:00",
"reviewRating": {
"@type": "Rating",
"ratingValue": 5,
"bestRating": "5",
"worstRating": "1"
},
"author": {
"@type": "Person",
"name": "کاربر 1365590",
"url": ""
}
}
],
"additionalProperty": [
{
"@type": "PropertyValue",
"name": "pa_brand",
"value": "او پی دی فارما (OPD Pharma)"
},
{
"@type": "PropertyValue",
"name": "pa_karaei",
"value": "تسکین دردهای عضلانی, تقویت سیستم عصبی"
},
{
"@type": "PropertyValue",
"name": "pa_forme-mahsul",
"value": "پودر"
},
{
"@type": "PropertyValue",
"name": "pa_noe-hafeze",
"value": "وکیوم"
},
{
"@type": "PropertyValue",
"name": "pa_jense-mahfaze",
"value": "پلاستیکی"
},
{
"@type": "PropertyValue",
"name": "pa_keshvare-tolid",
"value": "ایران"
},
{
"@type": "PropertyValue",
"name": "pa_sherkate-tolid",
"value": "امید پارسینا دماوند"
}
],
"url": "https://mosbatsefid.ir/product/opd-pharma-magnesium-300-mg-sachets/",
"productGroupID": "2206516",
"hasVariant": [
{
"@type": "Product",
"sku": "4994942",
"name": "ساشه منیزیم 300 میلی گرم او پی دی فارما 20 عدد",
"description": "ساشه منیزیم 300 میلی گرم او پی دی فارما با تامین منیزیم مورد نیاز بدن به سلامت سیستم عصبی، سیستم عضلانی، استحکام استخوان، کاهش گرفتگی عضلات، بهبود خواب و بهبود عملکرد ورزشکاران کمک موثری میکند.",
"image": "https://mosbatsefid.ir/wp-content/uploads/2024/06/OPD-Pharma-Magnesium-300-Mg-20-Sachets-strawberry-150x150.webp",
"offers": {
"@type": "Offer",
"description": "ساشه منیزیم 300 میلی گرم او پی دی فارما با تامین منیزیم مورد نیاز بدن به سلامت سیستم عصبی، سیستم عضلانی، استحکام استخوان، کاهش گرفتگی عضلات، بهبود خواب و بهبود عملکرد ورزشکاران کمک موثری میکند.",
"price": 3475000,
"priceCurrency": "IRR",
"availability": "http://schema.org/OutOfStock",
"itemCondition": "NewCondition",
"priceValidUntil": "1406-10-10",
"url": "https://mosbatsefid.ir/product/opd-pharma-magnesium-300-mg-sachets/?attribute_pa_tam=strawberry&attribute_pa_tedad-dar-baste=20"
}
},
{
"@type": "Product",
"sku": "4994945",
"name": "ساشه منیزیم 300 میلی گرم او پی دی فارما 20 عدد",
"description": "ساشه منیزیم 300 میلی گرم او پی دی فارما با تامین منیزیم مورد نیاز بدن به سلامت سیستم عصبی، سیستم عضلانی، استحکام استخوان، کاهش گرفتگی عضلات، بهبود خواب و بهبود عملکرد ورزشکاران کمک موثری میکند.",
"image": "https://mosbatsefid.ir/wp-content/uploads/2024/06/OPD-Pharma-Magnesium-300-Mg-20-Sachets-150x150.jpg",
"offers": {
"@type": "Offer",
"description": "ساشه منیزیم 300 میلی گرم او پی دی فارما با تامین منیزیم مورد نیاز بدن به سلامت سیستم عصبی، سیستم عضلانی، استحکام استخوان، کاهش گرفتگی عضلات، بهبود خواب و بهبود عملکرد ورزشکاران کمک موثری میکند.",
"price": 2048000,
"priceCurrency": "IRR",
"availability": "http://schema.org/InStock",
"itemCondition": "NewCondition",
"priceValidUntil": "1406-10-10",
"url": "https://mosbatsefid.ir/product/opd-pharma-magnesium-300-mg-sachets/?attribute_pa_tam=orange&attribute_pa_tedad-dar-baste=20"
}
}
],
"@id": "https://mosbatsefid.ir/product/opd-pharma-magnesium-300-mg-sachets/#richSnippet"
},
"safetyConsideration": "عوارض و تداخلات: در صورت حساسیت به مواد تشکیل دهنده از مصرف این فرآورده خودداری شود.\r\n\r\nدر صورت مصرف دارو یا مکملهای دیگر، قبل از مصرف این فرآورده با پزشک یا داروساز مشورت نمایید.",
"review": [
{
"@type": "Review",
"reviewBody": "عالی 👍",
"author": {
"@type": "Person",
"name": "کاربر 1376860"
},
"reviewRating": {
"@type": "Rating",
"ratingValue": "5",
"bestRating": "5",
"worstRating": "1"
}
}
]
}
]
}