Default
WP_Query Object
(
[query] => Array
(
[post_type] => product
[post_status] => publish
[posts_per_page] => -1
[product_cat] => defaultcat
[meta_key] => _discount_amount
[orderby] => meta_value_num
[order] => DESC
)
[query_vars] => Array
(
[post_type] => product
[post_status] => publish
[posts_per_page] => -1
[product_cat] => defaultcat
[meta_key] => _discount_amount
[orderby] => meta_value_num
[order] => DESC
[error] =>
[m] =>
[p] => 0
[post_parent] =>
[subpost] =>
[subpost_id] =>
[attachment] =>
[attachment_id] => 0
[name] =>
[pagename] =>
[page_id] => 0
[second] =>
[minute] =>
[hour] =>
[day] => 0
[monthnum] => 0
[year] => 0
[w] => 0
[category_name] =>
[tag] =>
[cat] =>
[tag_id] =>
[author] =>
[author_name] =>
[feed] =>
[tb] =>
[paged] => 0
[meta_value] =>
[preview] =>
[s] =>
[sentence] =>
[title] =>
[fields] => all
[menu_order] =>
[embed] =>
[category__in] => Array
(
)
[category__not_in] => Array
(
)
[category__and] => Array
(
)
[post__in] => Array
(
)
[post__not_in] => Array
(
)
[post_name__in] => Array
(
)
[tag__in] => Array
(
)
[tag__not_in] => Array
(
)
[tag__and] => Array
(
)
[tag_slug__in] => Array
(
)
[tag_slug__and] => Array
(
)
[post_parent__in] => Array
(
)
[post_parent__not_in] => Array
(
)
[author__in] => Array
(
)
[author__not_in] => Array
(
)
[search_columns] => Array
(
)
[tax_query] => Array
(
[0] =>
[1] => Array
(
[taxonomy] => product_cat
[field] => slug
[terms] => Array
(
[0] => qgel-mattress
[1] => ortho-wellness-collection
[2] => sleepables
[3] => foamtastic-collection
[4] => hybrid-collection
[5] => my-power-matt
[6] => comfort-collection
[7] => beddy
[8] => beddy-blossom
[9] => baby-mattresses
[10] => kids-mattress
)
[operator] => IN
)
)
[ignore_sticky_posts] =>
[suppress_filters] =>
[cache_results] => 1
[update_post_term_cache] => 1
[update_menu_item_cache] =>
[lazy_load_term_meta] => 1
[update_post_meta_cache] => 1
[nopaging] => 1
[comments_per_page] => 50
[no_found_rows] =>
[taxonomy] => product_cat
[term] => qgel-mattress
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[0] => Array
(
[taxonomy] => product_cat
[terms] => Array
(
[0] => qgel-mattress
[1] => ortho-wellness-collection
[2] => sleepables
[3] => foamtastic-collection
[4] => hybrid-collection
[5] => my-power-matt
[6] => comfort-collection
[7] => beddy
[8] => beddy-blossom
[9] => baby-mattresses
[10] => kids-mattress
)
[field] => slug
[operator] => IN
[include_children] => 1
)
[1] => Array
(
[taxonomy] => product_cat
[terms] => Array
(
[0] => defaultcat
)
[field] => slug
[operator] => IN
[include_children] => 1
)
)
[relation] => AND
[table_aliases:protected] => Array
(
[0] => wpcind_term_relationships
[1] => tt1
)
[queried_terms] => Array
(
[product_cat] => Array
(
[terms] => Array
(
[0] => qgel-mattress
[1] => ortho-wellness-collection
[2] => sleepables
[3] => foamtastic-collection
[4] => hybrid-collection
[5] => my-power-matt
[6] => comfort-collection
[7] => beddy
[8] => beddy-blossom
[9] => baby-mattresses
[10] => kids-mattress
)
[field] => slug
)
)
[primary_table] => wpcind_posts
[primary_id_column] => ID
)
[meta_query] => WP_Meta_Query Object
(
[queries] => Array
(
[0] => Array
(
[key] => _discount_amount
)
[relation] => OR
)
[relation] => AND
[meta_table] => wpcind_postmeta
[meta_id_column] => post_id
[primary_table] => wpcind_posts
[primary_id_column] => ID
[table_aliases:protected] => Array
(
[0] => wpcind_postmeta
)
[clauses:protected] => Array
(
[wpcind_postmeta] => Array
(
[key] => _discount_amount
[compare] => =
[compare_key] => =
[alias] => wpcind_postmeta
[cast] => CHAR
)
)
[has_or_relation:protected] =>
)
[date_query] =>
[request] => SELECT wpcind_posts.*
FROM wpcind_posts LEFT JOIN wpcind_term_relationships ON (wpcind_posts.ID = wpcind_term_relationships.object_id) LEFT JOIN wpcind_term_relationships AS tt1 ON (wpcind_posts.ID = tt1.object_id) INNER JOIN wpcind_postmeta ON ( wpcind_posts.ID = wpcind_postmeta.post_id )
WHERE 1=1 AND (
wpcind_term_relationships.term_taxonomy_id IN (605,576,314,59,313,307,308,315,316,317,565)
AND
tt1.term_taxonomy_id IN (634)
) AND (
wpcind_postmeta.meta_key = '_discount_amount'
) AND wpcind_posts.post_type = 'product' AND ((wpcind_posts.post_status = 'publish'))
GROUP BY wpcind_posts.ID
ORDER BY wpcind_postmeta.meta_value+0 DESC
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 115340
[post_author] => 1
[post_date] => 2025-12-03 18:07:07
[post_date_gmt] => 2025-12-03 12:37:07
[post_content] => Mattress Type- Pocket Spring Mattress
Collection Name – My Power-Matt
Thicknesses – 8”
Firmness Level – Medium Firm
Warranty – 10 Years
Finish – Box Top
USPs -
2K Motion Isolation Pocketed Coil Technology
CertiPUR certified HR Foam with X-Bounce Antisag Technology
CNC Contour Cut Airflow Foam
Ortho Foam Encasing with Activ-Edge Support
High GSM Stretch Knit Breathable Fabric
Grip+ Antiskid Fabric
[post_title] => Centuary Wave Pro – Orthopedic Hybrid Pocket Spring Mattress
[post_excerpt] => Mattress Type- Pocket Spring Mattress
Collection Name – My Power-Matt
Thicknesses – 8”
Firmness Level – Medium Firm
Warranty – 10 Years
Finish – Box Top
USPs -
- 2K Motion Isolation Pocketed Coil Technology
- CertiPUR certified HR Foam with X-Bounce Antisag Technology
- CNC Contour Cut Airflow Foam
- Ortho Foam Encasing with Activ-Edge Support
- High GSM Stretch Knit Breathable Fabric
- Grip+ Antiskid Fabric
- 2K Motion Isolation Pocketed Coil Technology
- CertiPUR certified HR Foam with X-Bounce Antisag Technology
- CNC Contour Cut Airflow Foam
- Ortho Foam Encasing with Activ-Edge Support
- High GSM Stretch Knit Breathable Fabric
- Grip+ Antiskid Fabric