Symfony Profiler

SELECT
  DISTINCT(c.idcontact),
  c.organisation,
  c.country,
  c.city,
  c.url_clean
FROM
  contacts c
WHERE
  1
  AND c.idcontact IN (
    SELECT
      DISTINCT(texts.idcontact_publisher)
    FROM
      texts
    WHERE
      texts.publish = 1
  )

SELECT DISTINCT(c.idcontact), c.organisation, c.country, c.city, c.url_clean FROM contacts c WHERE 1
            AND c.idcontact IN
                (SELECT DISTINCT(texts.idcontact_publisher) FROM texts WHERE texts.publish=1);

SELECT
  DISTINCT(c.idcontact),
  c.organisation,
  c.country,
  c.city,
  c.url_clean
FROM
  contacts c
WHERE
  1
  AND c.idcontact IN (
    SELECT
      DISTINCT(texts.idcontact_publisher)
    FROM
      texts
    WHERE
      texts.publish = 1
  )
  AND c.organisation REGEXP '^L'
ORDER BY
  c.organisation

SELECT DISTINCT(c.idcontact), c.organisation, c.country, c.city, c.url_clean FROM contacts c WHERE 1
            AND c.idcontact IN
                (SELECT DISTINCT(texts.idcontact_publisher) FROM texts WHERE texts.publish=1) AND c.organisation REGEXP '^L'  ORDER BY c.organisation;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 14661

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=14661;

SELECT
  fr
FROM
  countries
WHERE
  id = 'FR'

SELECT fr FROM countries WHERE id='FR';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1503

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1503;

SELECT
  fr
FROM
  countries
WHERE
  id = 'CH'

SELECT fr FROM countries WHERE id='CH';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1863

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1863;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 35457

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=35457;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2768

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2768;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 23

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=23;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 23036

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=23036;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 13

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=13;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 6691

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=6691;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 166

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=166;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 21

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=21;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 16411

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=16411;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 10510

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=10510;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 124

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=124;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1206

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1206;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2255

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2255;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 35195

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=35195;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2485

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2485;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 177

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=177;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2527

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2527;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 21941

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=21941;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1967

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1967;

SELECT
  fr
FROM
  countries
WHERE
  id = 'CA'

SELECT fr FROM countries WHERE id='CA';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 33039

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=33039;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2150

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2150;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 35586

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=35586;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2236

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2236;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 6674

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=6674;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 12362

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=12362;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 5105

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=5105;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1884

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1884;

SELECT
  fr
FROM
  countries
WHERE
  id = 'IT'

SELECT fr FROM countries WHERE id='IT';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 17197

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=17197;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 309

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=309;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 23528

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=23528;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2725

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2725;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 9170

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=9170;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1983

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1983;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 20124

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=20124;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 20125

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=20125;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 18090

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=18090;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2694

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2694;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 30134

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=30134;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 19877

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=19877;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 13805

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=13805;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 5535

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=5535;

SELECT
  fr
FROM
  countries
WHERE
  id = 'ML'

SELECT fr FROM countries WHERE id='ML';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 16775

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=16775;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 28308

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=28308;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 20230

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=20230;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 17189

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=17189;

SELECT
  fr
FROM
  countries
WHERE
  id = 'ES'

SELECT fr FROM countries WHERE id='ES';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1329

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1329;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 20053

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=20053;

SELECT
  fr
FROM
  countries
WHERE
  id = 'DE'

SELECT fr FROM countries WHERE id='DE';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 56

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=56;

SELECT
  fr
FROM
  countries
WHERE
  id = 'BE'

SELECT fr FROM countries WHERE id='BE';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 29122

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=29122;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 6651

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=6651;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1520

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1520;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 18713

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=18713;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 18120

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=18120;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2654

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2654;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 17722

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=17722;