Plus de 3,665,041 sirens d'entreprise disponibles à consulter
WordPress database error: [Unknown column 'code_postal' in 'field list']SELECT code_postal, name, count
FROM ss565688_cities AS villes
RIGHT JOIN (
SELECT code_postal, count
FROM `ss565688_cache_ville_count`
ORDER BY count DESC
LIMIT 32
) AS ville_count ON villes.zip_code = ville_count.code_postal
ORDER BY count DESC
WordPress database error: [Unknown column 'code' in 'field list']SELECT code, name, count FROM ss565688_cache_departement_count
WordPress database error: [Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '=']SELECT unite.siren AS siren, etab.siret, etab.date_creation AS date_creation, unite.tranche_effectifs AS tranche_effectifs, unite.annee_effectifs AS annee_effectifs,
unite.date_dernier_traitement AS date_dernier_traitement, categorie_entreprise, unite.annee_categorie_entreprise AS annee_categorie_entreprise, unite.categorie_juridique AS categorie_juridique,
activite_principale_title, categorie_juridique_title, longitude, latitude,
unite.date_debut AS date_debut, unite.denomination AS denomination, numero_voie, type_voie, libelle_voie, code_postal, libelle_commune, prenom_1, nom, sexe, etab.updated_at as updated_at
FROM (SELECT sirets.siret AS siret, siren, numero_voie, type_voie, libelle_voie, code_postal, libelle_commune, longitude, latitude, date_creation, activite_principale, updated_at
FROM `ss565688_etablissements` AS etab
INNER JOIN (
SELECT siret
FROM `ss565688_etablissements`
WHERE etablissement_siege = 1 AND statut_diffusion = 1 AND activite_principale LIKE '%10%'
/*ORDER BY created_at_unix DESC*/
LIMIT 12 OFFSET 12
) AS sirets ON etab.siret = sirets.siret
) AS etab
LEFT JOIN ss565688_unites_legales AS unite ON etab.siren = unite.siren
LEFT JOIN ss565688_categories_juridiques AS cj ON unite.categorie_juridique = cj.categorie_juridique
LEFT JOIN ss565688_codes_naf AS cn ON etab.activite_principale = cn.naf_code
WHERE unite.statut_diffusion = 1
/*ORDER BY date_creation DESC*/