---------------------------
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---------------

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

---------------------------
×

Enjoy 10% off!

Join our mailing list to receive your discount!