string(492) "SELECT COUNT(p.ID) FROM wpatm_posts as p LEFT JOIN wpatm_postmeta as pm ON pm.post_id = p.ID  LEFT JOIN wpatm_postmeta as pmr ON pmr.post_id = p.ID  WHERE p.post_type = 'company' AND p.post_status = 'publish' AND pm.meta_key = 'public_display' AND pm.meta_value = '1'  AND (  pmr.meta_key = 'Produits_fabriqu_s' AND (  pmr.meta_value LIKE '{7fd75c134ae7ef75baa748cda8bf71f9168711c56c97d48ab73741adfc65cc1f}Biostimulants{7fd75c134ae7ef75baa748cda8bf71f9168711c56c97d48ab73741adfc65cc1f}'  ) );"
  • object(stdClass)#9647 (12) {
      ["name"]=>
      string(18) "TRUFFAUT SELECTION"
      ["website"]=>
      string(24) "https://www.truffaut.com"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      object(stdClass)#9661 (2) {
        ["internationalFormat"]=>
        string(12) "+33169915370"
        ["frenchFormat"]=>
        string(14) "01 69 91 53 70"
      }
      ["zoho_id"]=>
      string(18) "246999000000253295"
      ["address"]=>
      object(stdClass)#9648 (4) {
        ["street"]=>
        NULL
        ["postalcode"]=>
        NULL
        ["city"]=>
        NULL
        ["country"]=>
        NULL
      }
      ["adherents"]=>
      array(1) {
        [0]=>
        string(9) "Adhérent"
      }
      ["produits_fabriques"]=>
      array(6) {
        [0]=>
        string(19) "Supports de culture"
        [1]=>
        string(9) "Paillages"
        [2]=>
        string(22) "Amendements organiques"
        [3]=>
        string(18) "Engrais organiques"
        [4]=>
        string(24) "Engrais organo-minéraux"
        [5]=>
        string(13) "Biostimulants"
      }
      ["contributeurs_statistiques"]=>
      string(0) ""
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      object(stdClass)#9532 (3) {
        ["full"]=>
        object(stdClass)#9531 (3) {
          ["src"]=>
          string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-truffaut.png"
          ["width"]=>
          int(134)
          ["height"]=>
          int(57)
        }
        ["medium"]=>
        object(stdClass)#9530 (3) {
          ["src"]=>
          string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-truffaut.png"
          ["width"]=>
          int(134)
          ["height"]=>
          int(57)
        }
        ["thumbnail"]=>
        object(stdClass)#9529 (3) {
          ["src"]=>
          string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-truffaut.png"
          ["width"]=>
          int(134)
          ["height"]=>
          int(57)
        }
      }
    }
    
    TRUFFAUT SELECTION
    TRUFFAUT SELECTION Supports de culture, Paillages, Amendements organiques, Engrais organiques, Engrais organo-minéraux, Biostimulants https://www.truffaut.com
  • object(stdClass)#9528 (12) {
      ["name"]=>
      string(8) "VERAGROW"
      ["website"]=>
      string(20) "https://veragrow.fr/"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      object(stdClass)#9527 (2) {
        ["internationalFormat"]=>
        string(12) "+33646797477"
        ["frenchFormat"]=>
        string(14) "06 46 79 74 77"
      }
      ["zoho_id"]=>
      string(18) "246999000007791087"
      ["address"]=>
      object(stdClass)#9526 (4) {
        ["street"]=>
        string(50) "1 Voie des Vendaises - Parc d'activité du Vauvray"
        ["postalcode"]=>
        string(5) "27100"
        ["city"]=>
        string(12) "Val De Reuil"
        ["country"]=>
        string(6) "France"
      }
      ["adherents"]=>
      array(1) {
        [0]=>
        string(9) "Adhérent"
      }
      ["produits_fabriques"]=>
      array(2) {
        [0]=>
        string(22) "Amendements organiques"
        [1]=>
        string(13) "Biostimulants"
      }
      ["contributeurs_statistiques"]=>
      string(0) ""
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      object(stdClass)#9676 (3) {
        ["full"]=>
        object(stdClass)#9633 (3) {
          ["src"]=>
          string(65) "https://extranet.afaia.fr/wp-content/uploads/2022/03/veragrow.png"
          ["width"]=>
          int(108)
          ["height"]=>
          int(96)
        }
        ["medium"]=>
        object(stdClass)#9562 (3) {
          ["src"]=>
          string(65) "https://extranet.afaia.fr/wp-content/uploads/2022/03/veragrow.png"
          ["width"]=>
          int(108)
          ["height"]=>
          int(96)
        }
        ["thumbnail"]=>
        object(stdClass)#9703 (3) {
          ["src"]=>
          string(65) "https://extranet.afaia.fr/wp-content/uploads/2022/03/veragrow.png"
          ["width"]=>
          int(108)
          ["height"]=>
          int(96)
        }
      }
    }
    
    VERAGROW
    VERAGROW Amendements organiques, Biostimulants https://veragrow.fr/
  • object(stdClass)#9704 (12) {
      ["name"]=>
      string(6) "VERTAL"
      ["website"]=>
      string(22) "https://www.vertal.fr/"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      object(stdClass)#9705 (2) {
        ["internationalFormat"]=>
        string(12) "+33251426255"
        ["frenchFormat"]=>
        string(14) "02 51 42 62 55"
      }
      ["zoho_id"]=>
      string(18) "246999000000253315"
      ["address"]=>
      object(stdClass)#9706 (4) {
        ["street"]=>
        string(23) "11 rue de l’industrie"
        ["postalcode"]=>
        string(5) "85250"
        ["city"]=>
        string(14) "LA RABATELIERE"
        ["country"]=>
        string(6) "FRANCE"
      }
      ["adherents"]=>
      array(1) {
        [0]=>
        string(9) "Adhérent"
      }
      ["produits_fabriques"]=>
      array(1) {
        [0]=>
        string(13) "Biostimulants"
      }
      ["contributeurs_statistiques"]=>
      string(0) ""
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      object(stdClass)#9708 (3) {
        ["full"]=>
        object(stdClass)#9707 (3) {
          ["src"]=>
          string(64) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vertal1.jpg"
          ["width"]=>
          int(222)
          ["height"]=>
          int(80)
        }
        ["medium"]=>
        object(stdClass)#9709 (3) {
          ["src"]=>
          string(64) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vertal1.jpg"
          ["width"]=>
          int(222)
          ["height"]=>
          int(80)
        }
        ["thumbnail"]=>
        object(stdClass)#9710 (3) {
          ["src"]=>
          string(71) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vertal1-150x80.jpg"
          ["width"]=>
          int(150)
          ["height"]=>
          int(80)
        }
      }
    }
    
    VERTAL
    VERTAL Biostimulants https://www.vertal.fr/
  • object(stdClass)#9711 (12) {
      ["name"]=>
      string(7) "VIVAGRO"
      ["website"]=>
      string(14) "www.vivagro.eu"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      object(stdClass)#9712 (2) {
        ["internationalFormat"]=>
        string(12) "+33557783268"
        ["frenchFormat"]=>
        string(14) "05 57 78 32 68"
      }
      ["zoho_id"]=>
      string(18) "246999000003338040"
      ["address"]=>
      object(stdClass)#9713 (4) {
        ["street"]=>
        string(50) "Technopole Montesquieu - 5 allée Jacques Latrille"
        ["postalcode"]=>
        string(5) "33650"
        ["city"]=>
        string(9) "MARTILLAC"
        ["country"]=>
        string(6) "FRANCE"
      }
      ["adherents"]=>
      array(1) {
        [0]=>
        string(9) "Adhérent"
      }
      ["produits_fabriques"]=>
      array(3) {
        [0]=>
        string(18) "Engrais organiques"
        [1]=>
        string(24) "Engrais organo-minéraux"
        [2]=>
        string(13) "Biostimulants"
      }
      ["contributeurs_statistiques"]=>
      string(0) ""
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      object(stdClass)#9715 (3) {
        ["full"]=>
        object(stdClass)#9714 (3) {
          ["src"]=>
          string(64) "https://extranet.afaia.fr/wp-content/uploads/2021/03/vivagro.jpg"
          ["width"]=>
          int(257)
          ["height"]=>
          int(141)
        }
        ["medium"]=>
        object(stdClass)#9716 (3) {
          ["src"]=>
          string(64) "https://extranet.afaia.fr/wp-content/uploads/2021/03/vivagro.jpg"
          ["width"]=>
          int(257)
          ["height"]=>
          int(141)
        }
        ["thumbnail"]=>
        object(stdClass)#9717 (3) {
          ["src"]=>
          string(72) "https://extranet.afaia.fr/wp-content/uploads/2021/03/vivagro-150x141.jpg"
          ["width"]=>
          int(150)
          ["height"]=>
          int(141)
        }
      }
    }
    
    VIVAGRO
    VIVAGRO Engrais organiques, Engrais organo-minéraux, Biostimulants http://www.vivagro.eu
  • object(stdClass)#9718 (12) {
      ["name"]=>
      string(6) "YNSECT"
      ["website"]=>
      string(14) "www.ynsect.com"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(160) "df4de2d15fbebd14c8e0fc89d4344fbdd2ad25d0ff3516682603c361c167c4b55d38337bc4a7a1acb408bdd6f9fad92ab8fb17bff367e618fa6ad793767a14b727ad297857fe64b1bec4dcf13500de75"
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253316"
      ["address"]=>
      object(stdClass)#9719 (4) {
        ["street"]=>
        NULL
        ["postalcode"]=>
        NULL
        ["city"]=>
        NULL
        ["country"]=>
        NULL
      }
      ["adherents"]=>
      array(1) {
        [0]=>
        string(9) "Adhérent"
      }
      ["produits_fabriques"]=>
      array(3) {
        [0]=>
        string(22) "Amendements organiques"
        [1]=>
        string(18) "Engrais organiques"
        [2]=>
        string(13) "Biostimulants"
      }
      ["contributeurs_statistiques"]=>
      string(0) ""
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      object(stdClass)#9721 (3) {
        ["full"]=>
        object(stdClass)#9720 (3) {
          ["src"]=>
          string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-ynsect3.png"
          ["width"]=>
          int(200)
          ["height"]=>
          int(250)
        }
        ["medium"]=>
        object(stdClass)#9722 (3) {
          ["src"]=>
          string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-ynsect3.png"
          ["width"]=>
          int(200)
          ["height"]=>
          int(250)
        }
        ["thumbnail"]=>
        object(stdClass)#9723 (3) {
          ["src"]=>
          string(77) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-ynsect3-150x150.png"
          ["width"]=>
          int(150)
          ["height"]=>
          int(150)
        }
      }
    }
    
    YNSECT
    YNSECT Amendements organiques, Engrais organiques, Biostimulants http://www.ynsect.com