---------------------------
1428
---------------------------
Array ( [_edit_lock] => Array ( [0] => 1658083611:432 ) [_edit_last] => Array ( [0] => 432 ) [total_sales] => Array ( [0] => 38 ) [_tax_status] => Array ( [0] => taxable ) [_tax_class] => Array ( [0] => ) [_manage_stock] => Array ( [0] => yes ) [_backorders] => Array ( [0] => no ) [_sold_individually] => Array ( [0] => no ) [_virtual] => Array ( [0] => no ) [_downloadable] => Array ( [0] => no ) [_download_limit] => Array ( [0] => -1 ) [_download_expiry] => Array ( [0] => -1 ) [_stock] => Array ( [0] => 0 ) [_stock_status] => Array ( [0] => outofstock ) [_wc_average_rating] => Array ( [0] => 0 ) [_wc_review_count] => Array ( [0] => 0 ) [_product_attributes] => Array ( [0] => a:1:{s:20:"pa_diffuser-cap-type";a:6:{s:4:"name";s:20:"pa_diffuser-cap-type";s:5:"value";s:0:"";s:8:"position";i:0;s:10:"is_visible";i:1;s:12:"is_variation";i:1;s:11:"is_taxonomy";i:1;}} ) [_product_version] => Array ( [0] => 6.8.0 ) [product_subtitle] => Array ( [0] => ) [mobile_image] => Array ( [0] => ) [_thumbnail_id] => Array ( [0] => 1122 ) [_sku] => Array ( [0] => RM-DIFF-CAPS ) [_pos_visibility] => Array ( [0] => pos_online ) [desktop_image] => Array ( [0] => ) [_yoast_wpseo_content_score] => Array ( [0] => 60 ) [_atum_attachments] => Array ( [0] => [] ) [woocommerce_custom_product_prefix] => Array ( [0] => ) [turn_on_image] => Array ( [0] => ) [light_out_image] => Array ( [0] => ) [mobile_turn_on_image] => Array ( [0] => ) [mobile_light_out_image] => Array ( [0] => ) [picknmelt_container_scent_id] => Array ( [0] => ) [you_may_interested_in_] => Array ( [0] => ) [_you_may_interested_in_] => Array ( [0] => field_61522b0890ec5 ) [_safety_title] => Array ( [0] => ) [_safety_wysiwyg] => Array ( [0] => ) [_yoast_wpseo_estimated-reading-time-minutes] => Array ( [0] => ) [_price] => Array ( [0] => 0 ) )
---------------------------
1418
---------------------------
Array ( [_edit_lock] => Array ( [0] => 1664459041:66 ) [_edit_last] => Array ( [0] => 66 ) [total_sales] => Array ( [0] => 38 ) [_tax_status] => Array ( [0] => taxable ) [_tax_class] => Array ( [0] => ) [_manage_stock] => Array ( [0] => yes ) [_backorders] => Array ( [0] => no ) [_sold_individually] => Array ( [0] => no ) [_virtual] => Array ( [0] => no ) [_downloadable] => Array ( [0] => no ) [_download_limit] => Array ( [0] => -1 ) [_download_expiry] => Array ( [0] => -1 ) [_stock] => Array ( [0] => 0 ) [_stock_status] => Array ( [0] => outofstock ) [_wc_average_rating] => Array ( [0] => 0 ) [_wc_review_count] => Array ( [0] => 0 ) [_product_attributes] => Array ( [0] => a:1:{s:13:"pa_reed-types";a:6:{s:4:"name";s:13:"pa_reed-types";s:5:"value";s:0:"";s:8:"position";i:0;s:10:"is_visible";i:1;s:12:"is_variation";i:1;s:11:"is_taxonomy";i:1;}} ) [_product_version] => Array ( [0] => 6.8.0 ) [_thumbnail_id] => Array ( [0] => 1122 ) [product_subtitle] => Array ( [0] => ) [mobile_image] => Array ( [0] => ) [_sku] => Array ( [0] => RM-REEDS ) [_pos_visibility] => Array ( [0] => pos_online ) [desktop_image] => Array ( [0] => ) [_atum_attachments] => Array ( [0] => [] ) [woocommerce_custom_product_prefix] => Array ( [0] => ) [you_may_interested_in_] => Array ( [0] => ) [_you_may_interested_in_] => Array ( [0] => field_61522b0890ec5 ) [_safety_title] => Array ( [0] => ) [_safety_wysiwyg] => Array ( [0] => ) [_yoast_wpseo_estimated-reading-time-minutes] => Array ( [0] => 0 ) [product_promo] => Array ( [0] => ) [_yoast_wpseo_wordproof_timestamp] => Array ( [0] => ) [_price] => Array ( [0] => 0 ) [turn_on_image] => Array ( [0] => ) [light_out_image] => Array ( [0] => ) [mobile_turn_on_image] => Array ( [0] => ) [mobile_light_out_image] => Array ( [0] => ) [picknmelt_container_scent_id] => Array ( [0] => ) )
---------------------------
35898
---------------------------
Array ( [total_sales] => Array ( [0] => 37 ) [_tax_status] => Array ( [0] => taxable ) [_tax_class] => Array ( [0] => ) [_manage_stock] => Array ( [0] => no ) [_backorders] => Array ( [0] => no ) [_sold_individually] => Array ( [0] => no ) [_virtual] => Array ( [0] => no ) [_downloadable] => Array ( [0] => no ) [_download_limit] => Array ( [0] => -1 ) [_download_expiry] => Array ( [0] => -1 ) [_stock] => Array ( [0] => ) [_stock_status] => Array ( [0] => onbackorder ) [_wc_average_rating] => Array ( [0] => 5.00 ) [_wc_review_count] => Array ( [0] => 2 ) [_product_version] => Array ( [0] => 6.8.0 ) [product_subtitle] => Array ( [0] => Pick your bottle, pick your cap, pick your reeds, pick your scent! ) [mobile_image] => Array ( [0] => https://www.picknmelt.com/wp-content/uploads/2020/09/Luxury-Scented-Reed-Diffusers-Mobile.jpg ) [_edit_lock] => Array ( [0] => 1663578680:2 ) [_edit_last] => Array ( [0] => 2 ) [_product_attributes] => Array ( [0] => a:1:{s:17:"pa_container-type";a:6:{s:4:"name";s:17:"pa_container-type";s:5:"value";s:0:"";s:8:"position";i:0;s:10:"is_visible";i:1;s:12:"is_variation";i:1;s:11:"is_taxonomy";i:1;}} ) [desktop_image] => Array ( [0] => https://www.picknmelt.com/wp-content/uploads/2020/09/Luxury-Scented-Reed-Diffusers-Desktop.jpg ) [turn_off_image] => Array ( [0] => ) [mobile_turn_off_image] => Array ( [0] => ) [_pos_visibility] => Array ( [0] => pos_online ) [_yoast_wpseo_primary_product_cat] => Array ( [0] => 372 ) [_wp_old_slug] => Array ( [0] => reed-diffusers ) [_yoast_wpseo_focuskw] => Array ( [0] => Luxury Scented Reed Diffusers ) [_yoast_wpseo_metadesc] => Array ( [0] => Pick your container, Pick your cap, Pick your reeds, Pick you scent and the personalise your bottle. Luxury Scented Reed Diffusers by Pick n Melt. ) [_yoast_wpseo_linkdex] => Array ( [0] => 73 ) [_yoast_wpseo_content_score] => Array ( [0] => 90 ) [_wc_rating_count] => Array ( [0] => a:1:{i:5;i:2;} ) [woocommerce_custom_product_prefix] => Array ( [0] => Diffusers ) [you_may_interested_in_] => Array ( [0] => a:3:{i:0;s:5:"35900";i:1;s:5:"35899";i:2;s:5:"37731";} ) [_you_may_interested_in_] => Array ( [0] => field_61522b0890ec5 ) [_safety_wysiwyg] => Array ( [0] => To get the best out of your diffuser you should flip the reeds every couple of days. Please make sure to wash your hands immediately after touching the reeds. Please be careful not to spill the liquid on your bottle if it is painted. Some of the oils will react with some of the paints on the bottles.Keep out the reach of children and pets. ) [_product_fonts] => Array ( [0] => a:0:{} ) [_atum_attachments] => Array ( [0] => [] ) [_safety_title] => Array ( [0] => Diffuser Safety Information ) [_yoast_wpseo_estimated-reading-time-minutes] => Array ( [0] => 1 ) [product_promo] => Array ( [0] => Personalisation available ) [_yoast_wpseo_wordproof_timestamp] => Array ( [0] => ) [_thumbnail_id] => Array ( [0] => 48951 ) [turn_on_image] => Array ( [0] => ) [light_out_image] => Array ( [0] => ) [mobile_turn_on_image] => Array ( [0] => ) [mobile_light_out_image] => Array ( [0] => ) [picknmelt_container_scent_id] => Array ( [0] => ) [_price] => Array ( [0] => 14.9916 [1] => 20.825 [2] => 24.991667 ) ) Diffusers
------------CONTAINER---------------
diffuser-refill-100ml
------------CONTAINER---------------

------------QUERY---------------
SELECT ID FROM db_posts p LEFT JOIN db_postmeta pm ON p.ID = pm.post_id WHERE p.post_parent=45080 AND pm.meta_key='attribute_pa_container-type' AND pm.meta_value LIKE '{9c42b3b4a5e2eb2f159dd3b8a5e4f3f32c5c0dde3af8d628ca0607e1b9049c9a}diffuser-refill-100ml{9c42b3b4a5e2eb2f159dd3b8a5e4f3f32c5c0dde3af8d628ca0607e1b9049c9a}';
------------QUERY---------------

---------------------------

---------------------------