Symfony Profiler

SELECT
  idcontact
FROM
  contacts
WHERE
  url_clean = 'Gallimard-Editions'

SELECT idcontact FROM contacts WHERE url_clean='Gallimard-Editions' ;

SELECT
  c0_.idcontact AS idcontact_0,
  c0_.type AS type_1,
  c0_.organisation AS organisation_2,
  c0_.nom_suite AS nom_suite_3,
  c0_.lastname AS lastname_4,
  c0_.firstname AS firstname_5,
  c0_.idtypestructure AS idtypestructure_6,
  c0_.license AS license_7,
  c0_.comment AS comment_8,
  c0_.private_comment AS private_comment_9,
  c0_.address1 AS address1_10,
  c0_.address2 AS address2_11,
  c0_.zip AS zip_12,
  c0_.city AS city_13,
  c0_.phone1 AS phone1_14,
  c0_.phone2 AS phone2_15,
  c0_.fax AS fax_16,
  c0_.email1 AS email1_17,
  c0_.email1_online AS email1_online_18,
  c0_.email2_online AS email2_online_19,
  c0_.email2 AS email2_20,
  c0_.url AS url_21,
  c0_.url_ticket AS url_ticket_22,
  c0_.facebook AS facebook_23,
  c0_.twitter AS twitter_24,
  c0_.instagram AS instagram_25,
  c0_.mobile AS mobile_26,
  c0_.geocodable AS geocodable_27,
  c0_.x AS x_28,
  c0_.y AS y_29,
  c0_.idmultimedia AS idmultimedia_30,
  c0_.type_view AS type_view_31,
  c0_.stats_access AS stats_access_32,
  c0_.ga_tracking_id AS ga_tracking_id_33,
  c0_.is_festival AS is_festival_34,
  c0_.link_on_video AS link_on_video_35,
  c0_.is_partenaire AS is_partenaire_36,
  c0_.valid_version AS valid_version_37,
  c0_.other_versions AS other_versions_38,
  c0_.url_redirect AS url_redirect_39,
  c0_.url_clean AS url_clean_40,
  c0_.dateupdate AS dateupdate_41,
  c0_.dateinsert AS dateinsert_42,
  c0_.publish AS publish_43,
  c0_.valid AS valid_44,
  c1_.id AS id_45,
  c1_.fr AS fr_46,
  c1_.en AS en_47,
  c1_.es AS es_48,
  c1_.pt AS pt_49,
  c1_.de AS de_50,
  c1_.ru AS ru_51,
  c1_.orderby AS orderby_52
FROM
  contacts c0_
  LEFT JOIN countries c1_ ON c0_.country = c1_.id
WHERE
  c0_.idcontact = ?

SELECT c0_.idcontact AS idcontact_0, c0_.type AS type_1, c0_.organisation AS organisation_2, c0_.nom_suite AS nom_suite_3, c0_.lastname AS lastname_4, c0_.firstname AS firstname_5, c0_.idtypestructure AS idtypestructure_6, c0_.license AS license_7, c0_.comment AS comment_8, c0_.private_comment AS private_comment_9, c0_.address1 AS address1_10, c0_.address2 AS address2_11, c0_.zip AS zip_12, c0_.city AS city_13, c0_.phone1 AS phone1_14, c0_.phone2 AS phone2_15, c0_.fax AS fax_16, c0_.email1 AS email1_17, c0_.email1_online AS email1_online_18, c0_.email2_online AS email2_online_19, c0_.email2 AS email2_20, c0_.url AS url_21, c0_.url_ticket AS url_ticket_22, c0_.facebook AS facebook_23, c0_.twitter AS twitter_24, c0_.instagram AS instagram_25, c0_.mobile AS mobile_26, c0_.geocodable AS geocodable_27, c0_.x AS x_28, c0_.y AS y_29, c0_.idmultimedia AS idmultimedia_30, c0_.type_view AS type_view_31, c0_.stats_access AS stats_access_32, c0_.ga_tracking_id AS ga_tracking_id_33, c0_.is_festival AS is_festival_34, c0_.link_on_video AS link_on_video_35, c0_.is_partenaire AS is_partenaire_36, c0_.valid_version AS valid_version_37, c0_.other_versions AS other_versions_38, c0_.url_redirect AS url_redirect_39, c0_.url_clean AS url_clean_40, c0_.dateupdate AS dateupdate_41, c0_.dateinsert AS dateinsert_42, c0_.publish AS publish_43, c0_.valid AS valid_44, c1_.id AS id_45, c1_.fr AS fr_46, c1_.en AS en_47, c1_.es AS es_48, c1_.pt AS pt_49, c1_.de AS de_50, c1_.ru AS ru_51, c1_.orderby AS orderby_52 FROM contacts c0_ LEFT JOIN countries c1_ ON c0_.country = c1_.id WHERE c0_.idcontact = '8';

SELECT
  fr
FROM
  countries
WHERE
  id = 'FR'

SELECT fr FROM countries WHERE id='FR';

SELECT
  fr
FROM
  countries
WHERE
  id = 'France'

SELECT fr FROM countries WHERE id='France';

SELECT
  DISTINCT(cl.type)
FROM
  classifications cl
WHERE
  (
    (
      cl.idclassification IN (100)
    )
  )
  AND contacts = 1

SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (100))) AND contacts=1;

SELECT
  *
FROM
  object_file of,
  files f,
  file_classification fc,
  classifications cl,
  typesfiles tf
WHERE
  of.idfile = f.idfile
  AND f.idfile = fc.idfile
  AND of.idobject = '8'
  AND of.object = 'contacts'
  AND cl.idclassification = fc.idclassification
  AND f.publish = 1
  AND (
    (
      cl.idclassification IN (100)
    )
  )
  AND f.idtype = tf.idtype
ORDER BY
  f.`range`,
  f.idfile

SELECT *
                FROM object_file of,
                     files f,
                     file_classification fc,
                     classifications cl,typesfiles tf
                   WHERE of.idfile=f.idfile
                   AND f.idfile=fc.idfile
                   AND of.idobject='8'
                   AND of.object='contacts'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.idclassification IN (100))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile;

SELECT
  DISTINCT(cl.type)
FROM
  classifications cl
WHERE
  (
    (
      cl.classification IN ('class_pp')
    )
  )
  AND contacts = 1

SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_pp'))) AND contacts=1;

SELECT
  *
FROM
  object_file of,
  files f,
  file_classification fc,
  classifications cl,
  typesfiles tf
WHERE
  of.idfile = f.idfile
  AND f.idfile = fc.idfile
  AND of.idobject = '8'
  AND of.object = 'contacts'
  AND cl.idclassification = fc.idclassification
  AND (
    (
      cl.classification IN ('class_pp')
    )
  )
  AND f.idtype = tf.idtype
ORDER BY
  f.`range`,
  f.idfile

SELECT *
                FROM object_file of,
                     files f,
                     file_classification fc,
                     classifications cl,typesfiles tf
                   WHERE of.idfile=f.idfile
                   AND f.idfile=fc.idfile
                   AND of.idobject='8'
                   AND of.object='contacts'
                   AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_pp'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile;

SELECT
  COUNT(
    DISTINCT(m.idmultimedia)
  )
FROM
  object_multimedia om,
  multimedias m
WHERE
  om.idmultimedia = m.idmultimedia
  AND om.idobject = 8
  AND om.object = 'contacts'
  AND m.publish = 1
  AND m.audio_video = 2

SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=8
                AND om.object='contacts'
                AND m.publish=1  AND m.audio_video=2;

SELECT
  COUNT(
    DISTINCT(T1.idperson)
  ) as total
FROM
  persons T1
  JOIN text_author T2 ON T2.`idperson` = T1.`idperson`
  JOIN texts t ON t.`idtext` = T2.`idtext`
WHERE
  1
  AND t.`idcontact_publisher` IN ('8')
  AND T1.`publish` = 1

SELECT COUNT(DISTINCT(T1.idperson)) as total  FROM persons T1 
                    JOIN text_author T2 ON T2.`idperson` = T1.`idperson`
                    JOIN texts t ON t.`idtext`=T2.`idtext` 
                 WHERE 1  AND t.`idcontact_publisher` IN  ('8')  AND T1.`publish`=1 ;

SELECT
  idtext,
  idgenretext
FROM
  texts
WHERE
  type = 0
  AND idcontact_publisher = 8

SELECT idtext, idgenretext FROM texts WHERE type=0 AND idcontact_publisher=8;

SELECT
  idtext
FROM
  texts
WHERE
  type = 1
  AND idcontact_publisher = 8

SELECT idtext FROM texts WHERE type=1 AND idcontact_publisher=8;

SELECT
  tt.idtext
FROM
  text_traduction tt,
  texts t
WHERE
  t.idtext = tt.idtext
  AND (
    t.idgenretext = 1
    OR t.idgenretext IS NULL
  )
  AND tt.idtexttraduction IN (
    958,
    1068,
    1081,
    1189,
    1435,
    1509,
    1552,
    1555,
    1556,
    1634,
    1779,
    1842,
    1843,
    1999,
    2000,
    2026,
    2306,
    2393,
    2438,
    2551,
    2596,
    2634,
    2635,
    2695,
    3077,
    3099,
    3130,
    3157,
    3224,
    3227,
    3250,
    3340,
    3371,
    3604,
    3612,
    3647,
    3683,
    3695,
    4013,
    4027,
    4128,
    4190,
    4223,
    4232,
    4531,
    4881,
    5150,
    5158,
    5163,
    5266,
    6002,
    6266,
    6552,
    6589,
    6631,
    6750,
    6771,
    6786,
    6963,
    7073,
    7516,
    7560,
    7965,
    8120,
    8142,
    8455,
    8730,
    8731,
    8987,
    9063,
    9313,
    9424,
    9602,
    9828,
    9888,
    10240,
    10319,
    10398,
    10481,
    10639,
    10640,
    10649,
    11044,
    11145,
    11146,
    11581,
    12083,
    12520,
    12522,
    14199,
    15403,
    15650,
    16544,
    16597,
    16602,
    17500,
    17630,
    18780,
    19860,
    20858,
    20861,
    21138,
    21531,
    22243,
    22244,
    22433,
    23315,
    23316,
    23389,
    23465,
    23841,
    23997,
    24745,
    24746,
    25872,
    26935,
    27194,
    27465,
    27909,
    29220,
    31679,
    32227,
    32325,
    34702,
    35193,
    35451,
    37176,
    37205,
    37266,
    37372,
    38037,
    38088,
    38367,
    39236,
    39543,
    39654,
    40055,
    40200,
    40575,
    41267,
    41348,
    41495,
    41615,
    41961,
    43161,
    43162,
    43164,
    43195,
    43238,
    43256,
    44296,
    45223,
    45259,
    45535
  )

SELECT tt.idtext FROM text_traduction tt, texts t
                                        WHERE t.idtext=tt.idtext
                                        AND (t.idgenretext=1 OR t.idgenretext IS NULL)
                                        AND tt.idtexttraduction IN (958,1068,1081,1189,1435,1509,1552,1555,1556,1634,1779,1842,1843,1999,2000,2026,2306,2393,2438,2551,2596,2634,2635,2695,3077,3099,3130,3157,3224,3227,3250,3340,3371,3604,3612,3647,3683,3695,4013,4027,4128,4190,4223,4232,4531,4881,5150,5158,5163,5266,6002,6266,6552,6589,6631,6750,6771,6786,6963,7073,7516,7560,7965,8120,8142,8455,8730,8731,8987,9063,9313,9424,9602,9828,9888,10240,10319,10398,10481,10639,10640,10649,11044,11145,11146,11581,12083,12520,12522,14199,15403,15650,16544,16597,16602,17500,17630,18780,19860,20858,20861,21138,21531,22243,22244,22433,23315,23316,23389,23465,23841,23997,24745,24746,25872,26935,27194,27465,27909,29220,31679,32227,32325,34702,35193,35451,37176,37205,37266,37372,38037,38088,38367,39236,39543,39654,40055,40200,40575,41267,41348,41495,41615,41961,43161,43162,43164,43195,43238,43256,44296,45223,45259,45535);

SELECT
  COUNT(
    DISTINCT(T1.`idtext`)
  ) as total
FROM
  texts T1
  LEFT JOIN contacts T2 ON T2.`idcontact` = T1.`idcontact_publisher`
WHERE
  1
  AND T1.`idtext` IN (
    14,
    19,
    25,
    52,
    56,
    157,
    159,
    288,
    290,
    711,
    902,
    1140,
    1171,
    1232,
    1311,
    1477,
    1630,
    1780,
    1802,
    1909,
    1910,
    1940,
    1983,
    2027,
    2073,
    2135,
    2143,
    2187,
    2258,
    2278,
    2313,
    2387,
    2433,
    2434,
    2462,
    2480,
    2541,
    2621,
    2640,
    2641,
    2642,
    2875,
    2963,
    2972,
    3024,
    3031,
    3085,
    3111,
    3124,
    3143,
    3175,
    3184,
    3232,
    3356,
    3386,
    3508,
    3580,
    3627,
    3745,
    3787,
    3934,
    4116,
    4117,
    4380,
    4439,
    4634,
    4635,
    4637,
    4638,
    4640,
    4762,
    5116,
    5175,
    5222,
    5223,
    5224,
    5225,
    5380,
    5549,
    5589,
    5802,
    6031,
    6052,
    6055,
    6056,
    6057,
    6113,
    6225,
    6281,
    6333,
    6346,
    7087,
    7254,
    7636,
    7947,
    7949,
    7967,
    7991,
    8046,
    8096,
    8153,
    8233,
    8239,
    8503,
    8599,
    8629,
    8647,
    8656,
    8657,
    8658,
    8659,
    8808,
    8862,
    9025,
    9096,
    9197,
    9230,
    9231,
    9517,
    9622,
    9775,
    10004,
    10005,
    10006,
    10007,
    10102,
    10320,
    10917,
    11042,
    11065,
    11143,
    11189,
    11239,
    12159,
    12819,
    13137,
    13651,
    13939,
    14280,
    14792,
    14812,
    14877,
    15046,
    15047,
    15664,
    15666,
    15736,
    15853,
    15854,
    16296,
    18012,
    18142,
    18564,
    18650,
    18721,
    19176,
    21091,
    21286,
    21311,
    22675,
    23806,
    23829,
    23859,
    23988,
    24649,
    25671,
    26208,
    26238,
    28003,
    28102,
    30296,
    30340,
    30396,
    32176,
    32561,
    32929,
    33383,
    34389,
    35445,
    35766,
    36125,
    36379,
    37039,
    39927,
    40424,
    41318,
    42492,
    42715,
    43181,
    44997
  )
ORDER BY
  CAST(
    CONCAT(
      T1.`publication_year`, '-', T1.`publication_month`,
      '-00'
    ) AS DATE
  ) ASC

SELECT COUNT(DISTINCT(T1.`idtext`)) as total  FROM texts T1
                                LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher`  WHERE 1  AND T1.`idtext` IN (14,19,25,52,56,157,159,288,290,711,902,1140,1171,1232,1311,1477,1630,1780,1802,1909,1910,1940,1983,2027,2073,2135,2143,2187,2258,2278,2313,2387,2433,2434,2462,2480,2541,2621,2640,2641,2642,2875,2963,2972,3024,3031,3085,3111,3124,3143,3175,3184,3232,3356,3386,3508,3580,3627,3745,3787,3934,4116,4117,4380,4439,4634,4635,4637,4638,4640,4762,5116,5175,5222,5223,5224,5225,5380,5549,5589,5802,6031,6052,6055,6056,6057,6113,6225,6281,6333,6346,7087,7254,7636,7947,7949,7967,7991,8046,8096,8153,8233,8239,8503,8599,8629,8647,8656,8657,8658,8659,8808,8862,9025,9096,9197,9230,9231,9517,9622,9775,10004,10005,10006,10007,10102,10320,10917,11042,11065,11143,11189,11239,12159,12819,13137,13651,13939,14280,14792,14812,14877,15046,15047,15664,15666,15736,15853,15854,16296,18012,18142,18564,18650,18721,19176,21091,21286,21311,22675,23806,23829,23859,23988,24649,25671,26208,26238,28003,28102,30296,30340,30396,32176,32561,32929,33383,34389,35445,35766,36125,36379,37039,39927,40424,41318,42492,42715,43181,44997)  ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC ;

SELECT
  COUNT(
    DISTINCT(T1.`idtext`)
  ) as total
FROM
  texts T1
  LEFT JOIN contacts T2 ON T2.`idcontact` = T1.`idcontact_publisher`
WHERE
  1
  AND T1.`idtext` IN (
    14,
    19,
    25,
    52,
    56,
    157,
    159,
    288,
    290,
    711,
    902,
    1140,
    1171,
    1232,
    1311,
    1477,
    1630,
    1780,
    1802,
    1909,
    1910,
    1940,
    1983,
    2027,
    2073,
    2135,
    2143,
    2187,
    2258,
    2278,
    2313,
    2387,
    2433,
    2434,
    2462,
    2480,
    2541,
    2621,
    2640,
    2641,
    2642,
    2875,
    2963,
    2972,
    3024,
    3031,
    3085,
    3111,
    3124,
    3143,
    3175,
    3184,
    3232,
    3356,
    3386,
    3508,
    3580,
    3627,
    3745,
    3787,
    3934,
    4116,
    4117,
    4380,
    4439,
    4634,
    4635,
    4637,
    4638,
    4640,
    4762,
    5116,
    5175,
    5222,
    5223,
    5224,
    5225,
    5380,
    5549,
    5589,
    5802,
    6031,
    6052,
    6055,
    6056,
    6057,
    6113,
    6225,
    6281,
    6333,
    6346,
    7087,
    7254,
    7636,
    7947,
    7949,
    7967,
    7991,
    8046,
    8096,
    8153,
    8233,
    8239,
    8503,
    8599,
    8629,
    8647,
    8656,
    8657,
    8658,
    8659,
    8808,
    8862,
    9025,
    9096,
    9197,
    9230,
    9231,
    9517,
    9622,
    9775,
    10004,
    10005,
    10006,
    10007,
    10102,
    10320,
    10917,
    11042,
    11065,
    11143,
    11189,
    11239,
    12159,
    12819,
    13137,
    13651,
    13939,
    14280,
    14792,
    14812,
    14877,
    15046,
    15047,
    15664,
    15666,
    15736,
    15853,
    15854,
    16296,
    18012,
    18142,
    18564,
    18650,
    18721,
    19176,
    21091,
    21286,
    21311,
    22675,
    23806,
    23829,
    23859,
    23988,
    24649,
    25671,
    26208,
    26238,
    28003,
    28102,
    30296,
    30340,
    30396,
    32176,
    32561,
    32929,
    33383,
    34389,
    35445,
    35766,
    36125,
    36379,
    37039,
    39927,
    40424,
    41318,
    42492,
    42715,
    43181,
    44997
  )
ORDER BY
  CAST(
    CONCAT(
      T1.`publication_year`, '-', T1.`publication_month`,
      '-00'
    ) AS DATE
  ) ASC

SELECT COUNT(DISTINCT(T1.`idtext`)) as total  FROM texts T1
                                LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher`  WHERE 1  AND T1.`idtext` IN (14,19,25,52,56,157,159,288,290,711,902,1140,1171,1232,1311,1477,1630,1780,1802,1909,1910,1940,1983,2027,2073,2135,2143,2187,2258,2278,2313,2387,2433,2434,2462,2480,2541,2621,2640,2641,2642,2875,2963,2972,3024,3031,3085,3111,3124,3143,3175,3184,3232,3356,3386,3508,3580,3627,3745,3787,3934,4116,4117,4380,4439,4634,4635,4637,4638,4640,4762,5116,5175,5222,5223,5224,5225,5380,5549,5589,5802,6031,6052,6055,6056,6057,6113,6225,6281,6333,6346,7087,7254,7636,7947,7949,7967,7991,8046,8096,8153,8233,8239,8503,8599,8629,8647,8656,8657,8658,8659,8808,8862,9025,9096,9197,9230,9231,9517,9622,9775,10004,10005,10006,10007,10102,10320,10917,11042,11065,11143,11189,11239,12159,12819,13137,13651,13939,14280,14792,14812,14877,15046,15047,15664,15666,15736,15853,15854,16296,18012,18142,18564,18650,18721,19176,21091,21286,21311,22675,23806,23829,23859,23988,24649,25671,26208,26238,28003,28102,30296,30340,30396,32176,32561,32929,33383,34389,35445,35766,36125,36379,37039,39927,40424,41318,42492,42715,43181,44997)  ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC ;

SELECT
  COUNT(
    DISTINCT(T1.`idtext`)
  ) as total
FROM
  texts T1
  LEFT JOIN contacts T2 ON T2.`idcontact` = T1.`idcontact_publisher`
WHERE
  1
  AND T1.`idtext` IN (
    958,
    1068,
    1081,
    1189,
    1435,
    1509,
    1552,
    1555,
    1556,
    1634,
    1779,
    1842,
    1843,
    1999,
    2000,
    2026,
    2306,
    2393,
    2438,
    2551,
    2596,
    2634,
    2635,
    2695,
    3077,
    3099,
    3130,
    3157,
    3224,
    3227,
    3250,
    3340,
    3371,
    3604,
    3612,
    3647,
    3683,
    3695,
    4013,
    4027,
    4128,
    4190,
    4223,
    4232,
    4531,
    4881,
    5150,
    5158,
    5163,
    5266,
    6002,
    6266,
    6552,
    6589,
    6631,
    6750,
    6771,
    6786,
    6963,
    7073,
    7516,
    7560,
    7965,
    8120,
    8142,
    8455,
    8730,
    8731,
    8987,
    9063,
    9313,
    9424,
    9602,
    9828,
    9888,
    10240,
    10319,
    10398,
    10481,
    10639,
    10640,
    10649,
    11044,
    11145,
    11146,
    11581,
    12083,
    12520,
    12522,
    14199,
    15403,
    15650,
    16544,
    16597,
    16602,
    17500,
    17630,
    18780,
    19860,
    20858,
    20861,
    21138,
    21531,
    22243,
    22244,
    22433,
    23315,
    23316,
    23389,
    23465,
    23841,
    23997,
    24745,
    24746,
    25872,
    26935,
    27194,
    27465,
    27909,
    29220,
    31679,
    32227,
    32325,
    34702,
    35193,
    35451,
    37176,
    37205,
    37266,
    37372,
    38037,
    38088,
    38367,
    39236,
    39543,
    39654,
    40055,
    40200,
    40575,
    41267,
    41348,
    41495,
    41615,
    41961,
    43161,
    43162,
    43164,
    43195,
    43238,
    43256,
    44296,
    45223,
    45259,
    45535
  )
ORDER BY
  CAST(
    CONCAT(
      T1.`publication_year`, '-', T1.`publication_month`,
      '-00'
    ) AS DATE
  ) ASC

SELECT COUNT(DISTINCT(T1.`idtext`)) as total  FROM texts T1
                                LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher`  WHERE 1  AND T1.`idtext` IN (958,1068,1081,1189,1435,1509,1552,1555,1556,1634,1779,1842,1843,1999,2000,2026,2306,2393,2438,2551,2596,2634,2635,2695,3077,3099,3130,3157,3224,3227,3250,3340,3371,3604,3612,3647,3683,3695,4013,4027,4128,4190,4223,4232,4531,4881,5150,5158,5163,5266,6002,6266,6552,6589,6631,6750,6771,6786,6963,7073,7516,7560,7965,8120,8142,8455,8730,8731,8987,9063,9313,9424,9602,9828,9888,10240,10319,10398,10481,10639,10640,10649,11044,11145,11146,11581,12083,12520,12522,14199,15403,15650,16544,16597,16602,17500,17630,18780,19860,20858,20861,21138,21531,22243,22244,22433,23315,23316,23389,23465,23841,23997,24745,24746,25872,26935,27194,27465,27909,29220,31679,32227,32325,34702,35193,35451,37176,37205,37266,37372,38037,38088,38367,39236,39543,39654,40055,40200,40575,41267,41348,41495,41615,41961,43161,43162,43164,43195,43238,43256,44296,45223,45259,45535)  ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC ;