SELECT p.ID, m.value AS dr
      FROM wp_posts p
      LEFT JOIN wp_metrics m ON p.ID = m.post_id AND m.name = 'dr'
	  INNER JOIN wp_postmeta stock_status ON stock_status.post_id = p.ID
      AND stock_status.meta_key = '_stock_status' AND stock_status.meta_value = 'instock'
      WHERE p.post_type = 'product'
        AND p.post_status = 'publish'
        AND p.post_date >= '2025-12-22 00:00:00'
        AND p.post_date <= '2025-12-28 23:59:59'
        AND NOT EXISTS (
          SELECT 1
          FROM wp_term_relationships tr
          INNER JOIN wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
          INNER JOIN wp_terms t ON tt.term_id = t.term_id
          WHERE tr.object_id = p.ID
            AND tt.taxonomy = 'product_cat'
            AND t.slug IN ('uncategorized', 'packages')
        )
        AND NOT EXISTS (
          SELECT 1
          FROM wp_postmeta pm
          WHERE pm.post_id = p.ID
            AND pm.meta_key = '_visibility'
            AND pm.meta_value = 'private'
        )
      ORDER BY m.value DESC
    
      SELECT p.ID, m.value AS dr
      FROM wp_posts p
      LEFT JOIN wp_metrics m ON p.ID = m.post_id AND m.name = 'dr'
	  INNER JOIN wp_postmeta stock_status ON stock_status.post_id = p.ID
      AND stock_status.meta_key = '_stock_status' AND stock_status.meta_value = 'instock'
      WHERE p.post_type = 'product'
        AND p.post_status = 'publish'
        AND p.post_date >= '2025-12-22 00:00:00'
        AND p.post_date <= '2025-12-28 23:59:59'
        AND NOT EXISTS (
          SELECT 1
          FROM wp_term_relationships tr
          INNER JOIN wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
          INNER JOIN wp_terms t ON tt.term_id = t.term_id
          WHERE tr.object_id = p.ID
            AND tt.taxonomy = 'product_cat'
            AND t.slug IN ('uncategorized', 'packages')
        )
        AND NOT EXISTS (
          SELECT 1
          FROM wp_postmeta pm
          WHERE pm.post_id = p.ID
            AND pm.meta_key = '_visibility'
            AND pm.meta_value = 'private'
        )
      ORDER BY m.value DESC
    array(2) {
  ["total"]=>
  int(405)
  ["product"]=>
  array(16) {
    [0]=>
    array(5) {
      ["website"]=>
      string(12) "pixieset.com"
      ["niche_text"]=>
      string(12) "Education +2"
      ["dr"]=>
      string(2) "92"
      ["price"]=>
      string(4) "88.9"
      ["buy_link"]=>
      string(62) "https://guestpostlinks.net/product/guest-post-on-pixieset-com/"
    }
    [1]=>
    array(5) {
      ["website"]=>
      string(13) "hasthemes.com"
      ["niche_text"]=>
      string(10) "E-commerce"
      ["dr"]=>
      string(2) "80"
      ["price"]=>
      string(5) "361.9"
      ["buy_link"]=>
      string(63) "https://guestpostlinks.net/product/guest-post-on-hasthemes-com/"
    }
    [2]=>
    array(5) {
      ["website"]=>
      string(15) "es.modalova.com"
      ["niche_text"]=>
      string(11) "Business +3"
      ["dr"]=>
      string(2) "74"
      ["price"]=>
      string(5) "292.9"
      ["buy_link"]=>
      string(65) "https://guestpostlinks.net/product/guest-post-on-es-modalova-com/"
    }
    [3]=>
    array(5) {
      ["website"]=>
      string(15) "it.modalova.com"
      ["niche_text"]=>
      string(11) "Business +3"
      ["dr"]=>
      string(2) "74"
      ["price"]=>
      string(5) "198.9"
      ["buy_link"]=>
      string(65) "https://guestpostlinks.net/product/guest-post-on-it-modalova-com/"
    }
    [4]=>
    array(5) {
      ["website"]=>
      string(18) "wallstreetmojo.com"
      ["niche_text"]=>
      string(24) "Banking &amp; Finance +1"
      ["dr"]=>
      string(2) "74"
      ["price"]=>
      string(5) "289.9"
      ["buy_link"]=>
      string(68) "https://guestpostlinks.net/product/guest-post-on-wallstreetmojo-com/"
    }
    [5]=>
    array(5) {
      ["website"]=>
      string(15) "de.modalova.com"
      ["niche_text"]=>
      string(11) "Business +3"
      ["dr"]=>
      string(2) "74"
      ["price"]=>
      string(5) "292.9"
      ["buy_link"]=>
      string(65) "https://guestpostlinks.net/product/guest-post-on-de-modalova-com/"
    }
    [6]=>
    array(5) {
      ["website"]=>
      string(15) "uk.modalova.com"
      ["niche_text"]=>
      string(11) "Business +3"
      ["dr"]=>
      string(2) "74"
      ["price"]=>
      string(5) "292.9"
      ["buy_link"]=>
      string(65) "https://guestpostlinks.net/product/guest-post-on-uk-modalova-com/"
    }
    [7]=>
    array(5) {
      ["website"]=>
      string(17) "zpravy.tiscali.cz"
      ["niche_text"]=>
      string(24) "Banking &amp; Finance +3"
      ["dr"]=>
      string(2) "73"
      ["price"]=>
      string(5) "295.9"
      ["buy_link"]=>
      string(67) "https://guestpostlinks.net/product/guest-post-on-zpravy-tiscali-cz/"
    }
    [8]=>
    array(5) {
      ["website"]=>
      string(10) "knowff.com"
      ["niche_text"]=>
      string(24) "Banking &amp; Finance +3"
      ["dr"]=>
      string(2) "72"
      ["price"]=>
      string(4) "34.9"
      ["buy_link"]=>
      string(60) "https://guestpostlinks.net/product/guest-post-on-knowff-com/"
    }
    [9]=>
    array(5) {
      ["website"]=>
      string(15) "annivercary.com"
      ["niche_text"]=>
      string(11) "Business +3"
      ["dr"]=>
      string(2) "72"
      ["price"]=>
      string(4) "34.9"
      ["buy_link"]=>
      string(65) "https://guestpostlinks.net/product/guest-post-on-annivercary-com/"
    }
    [10]=>
    array(5) {
      ["website"]=>
      string(19) "thegeekinsights.com"
      ["niche_text"]=>
      string(11) "Business +3"
      ["dr"]=>
      string(2) "72"
      ["price"]=>
      string(5) "109.9"
      ["buy_link"]=>
      string(69) "https://guestpostlinks.net/product/guest-post-on-thegeekinsights-com/"
    }
    [11]=>
    array(5) {
      ["website"]=>
      string(14) "swifttech3.com"
      ["niche_text"]=>
      string(24) "Banking &amp; Finance +2"
      ["dr"]=>
      string(2) "72"
      ["price"]=>
      string(4) "88.9"
      ["buy_link"]=>
      string(64) "https://guestpostlinks.net/product/guest-post-on-swifttech3-com/"
    }
    [12]=>
    array(5) {
      ["website"]=>
      string(15) "qoutermenia.com"
      ["niche_text"]=>
      string(25) "Automobiles &amp; Cars +3"
      ["dr"]=>
      string(2) "71"
      ["price"]=>
      string(4) "34.9"
      ["buy_link"]=>
      string(65) "https://guestpostlinks.net/product/guest-post-on-qoutermenia-com/"
    }
    [13]=>
    array(5) {
      ["website"]=>
      string(13) "nameshive.com"
      ["niche_text"]=>
      string(27) "Gadgets &amp; Technology +3"
      ["dr"]=>
      string(2) "71"
      ["price"]=>
      string(4) "28.9"
      ["buy_link"]=>
      string(63) "https://guestpostlinks.net/product/guest-post-on-nameshive-com/"
    }
    [14]=>
    array(5) {
      ["website"]=>
      string(16) "grammarpaths.com"
      ["niche_text"]=>
      string(25) "Automobiles &amp; Cars +3"
      ["dr"]=>
      string(2) "71"
      ["price"]=>
      string(4) "34.9"
      ["buy_link"]=>
      string(66) "https://guestpostlinks.net/product/guest-post-on-grammarpaths-com/"
    }
    [15]=>
    array(5) {
      ["website"]=>
      string(13) "brightnis.com"
      ["niche_text"]=>
      string(9) "Beauty +3"
      ["dr"]=>
      string(2) "71"
      ["price"]=>
      string(4) "34.9"
      ["buy_link"]=>
      string(63) "https://guestpostlinks.net/product/guest-post-on-brightnis-com/"
    }
  }
}