خطای پایگاهدادهٔ وردپرس : [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 = 5411664
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/2026/08/Vitalogic-Wellbody-Lycopene-30-Tablets.webp",
"url": "https://mosbatsefid.ir/wp-content/uploads/2026/08/Vitalogic-Wellbody-Lycopene-30-Tablets.webp",
"width": 1024,
"height": 1024,
"caption": "قیمت قرص ول بادی لیکوپن ویتالوژیک",
"inLanguage": "fa-IR"
},
{
"@type": "BreadcrumbList",
"@id": "https://mosbatsefid.ir/product/vitalogic-wellbody-lycopene-tablets/#breadcrumb",
"itemListElement": [
{
"@type": "ListItem",
"position": 1,
"item": {
"@id": "https://mosbatesabz.com",
"name": "داروخانه آنلاین مثبت سبز"
}
},
{
"@type": "ListItem",
"position": 2,
"item": {
"@id": "https://mosbatsefid.ir/product-category/specialist-supplements/cardiovascular-supplements/",
"name": "مکمل قلب"
}
},
{
"@type": "ListItem",
"position": 3,
"item": {
"@id": "https://mosbatsefid.ir/product/vitalogic-wellbody-lycopene-tablets/",
"name": "قرص ول بادی لیکوپن ویتالوژیک 30 عدد"
}
}
]
},
{
"@type": "ItemPage",
"@id": "https://mosbatsefid.ir/product/vitalogic-wellbody-lycopene-tablets/#webpage",
"url": "https://mosbatsefid.ir/product/vitalogic-wellbody-lycopene-tablets/",
"name": "قرص ول بادی لیکوپن ویتالوژیک 30 عدد",
"datePublished": "2026-08-11T09:00:47+03:30",
"dateModified": "2026-08-14T08:11:56+03:30",
"isPartOf": {
"@id": "https://mosbatsefid.ir/#website"
},
"primaryImageOfPage": {
"@id": "https://mosbatsefid.ir/wp-content/uploads/2026/08/Vitalogic-Wellbody-Lycopene-30-Tablets.webp"
},
"inLanguage": "fa-IR",
"breadcrumb": {
"@id": "https://mosbatsefid.ir/product/vitalogic-wellbody-lycopene-tablets/#breadcrumb"
}
},
{
"@type": "DietarySupplement",
"name": "قرص ول بادی لیکوپن ویتالوژیک 30 عدد",
"description": "قرص ول بادی لیکوپن ویتالوژیک حاوی 15 میلی گرم لیکوپن با خاصیت آنتی اکسیدانی که به سلامت سیستم قلبی و عروقی کمک می کند.",
"sku": "5411664",
"category": "مکمل های تخصصی > مکمل قلب",
"mainEntityOfPage": {
"@id": "https://mosbatsefid.ir/product/vitalogic-wellbody-lycopene-tablets/#webpage"
},
"weight": {
"@type": "QuantitativeValue",
"unitCode": "GRM",
"value": "48"
},
"height": {
"@type": "QuantitativeValue",
"unitCode": "CMT",
"value": "12"
},
"width": {
"@type": "QuantitativeValue",
"unitCode": "CMT",
"value": "3"
},
"depth": {
"@type": "QuantitativeValue",
"unitCode": "CMT",
"value": "9"
},
"image": [
{
"@type": "ImageObject",
"url": "https://mosbatsefid.ir/wp-content/uploads/2026/08/Vitalogic-Wellbody-Lycopene-30-Tablets.webp",
"height": 1024,
"width": 1024
},
{
"@type": "ImageObject",
"url": "https://mosbatsefid.ir/wp-content/uploads/2026/08/Vitalogic-Wellbody-Lycopene-30-Tab.webp",
"height": 1024,
"width": 1024
},
{
"@type": "ImageObject",
"url": "https://mosbatsefid.ir/wp-content/uploads/2026/08/Vitalogic-Wellbody-Lycopene-.webp",
"height": 1024,
"width": 1024
}
],
"offers": {
"@type": "Offer",
"price": "510000",
"priceCurrency": "IRR",
"priceValidUntil": "2028-05-23",
"availability": "https://schema.org/outofstock",
"itemCondition": "https://schema.org/NewCondition",
"url": "https://mosbatsefid.ir/product/vitalogic-wellbody-lycopene-tablets/",
"seller": {
"@id": "https://mosbatsefid.ir/#organization"
},
"priceSpecification": {
"price": "510000",
"priceCurrency": "IRR",
"valueAddedTaxIncluded": "false"
}
},
"additionalProperty": [
{
"@type": "PropertyValue",
"name": "pa_brand",
"value": "ویتالوژیک (Vitalogic)"
},
{
"@type": "PropertyValue",
"name": "pa_karaei",
"value": "آنتی اکسیدان, سلامت قلب و عروق"
},
{
"@type": "PropertyValue",
"name": "pa_forme-mahsul",
"value": "قرص روکشدار"
},
{
"@type": "PropertyValue",
"name": "pa_made-shakhes",
"value": "لیکوپن"
},
{
"@type": "PropertyValue",
"name": "pa_dose-made-shakhes",
"value": "15 میلی گرم"
},
{
"@type": "PropertyValue",
"name": "pa_nutritional-characteristics",
"value": "فاقد رنگ, فاقد گلوتن, فاقد لاکتوز, فاقد مخمر, فاقد نگهدارنده, فاقد نمک, مناسب افراد گیاه خوار"
},
{
"@type": "PropertyValue",
"name": "pa_rade-seni",
"value": "بزرگسالان"
},
{
"@type": "PropertyValue",
"name": "pa_sexuality",
"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": "ویتا آریا"
},
{
"@type": "PropertyValue",
"name": "pa_tedad-dar-baste",
"value": "30"
}
],
"@id": "https://mosbatsefid.ir/product/vitalogic-wellbody-lycopene-tablets/#richSnippet",
"targetPopulation": "بزرگسالان",
"audience": {
"@type": "Audience",
"name": "خانم ها"
},
"safetyConsideration": "عوارض و تداخلات: تاکنون هیچگونه عارضه جانبی خاصی پس از مصرف این فراورده مشاهده نگردیده است. در صورت بروز هرگونه عارضه جانبی به پزشک یا داروساز خود اطلاع دهید.\r\n\r\nبه طورت کلی ول بادی لیکوپن را میتوانید به همراه سایر داروها استفاده کنید؛ زیرا فاقد هرگونه دارو یا هورمون است.\r\n\r\nبرای توصیههای خاص در مورد مصرف ول بادی لیکوپن با سایر داروها ابتدا با پزشک یا داروساز خود مشورت نمایید.\r\n\r\nدر صورت استفاده از سایر داروها:\r\n\r\nتاکنون هیچگونه تداخل دارویی خاصی برای این محصول مشاهده نگردیده است."
}
]
}