Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.string_confirm_email AS string_confirm_email_2,
  t0.string_confirm_recovery AS string_confirm_recovery_3,
  t0.provider AS provider_4,
  t0.provider_client_id AS provider_client_id_5,
  t0.access_token AS access_token_6,
  t0.refresh_token AS refresh_token_7,
  t0.token_secret AS token_secret_8,
  t0.expires_in AS expires_in_9,
  t0.civility AS civility_10,
  t0.nickname AS nickname_11,
  t0.lastname AS lastname_12,
  t0.firstname AS firstname_13,
  t0.email AS email_14,
  t0.password AS password_15,
  t0.oldpassword AS oldpassword_16,
  t0.salt AS salt_17,
  t0.roles AS roles_18,
  t0.address AS address_19,
  t0.zipcode AS zipcode_20,
  t0.city AS city_21,
  t0.country AS country_22,
  t0.lat AS lat_23,
  t0.lng AS lng_24,
  t0.coordinates AS coordinates_25,
  t0.connected AS connected_26,
  t0.date_last_connected AS date_last_connected_27,
  t0.last_connect_mode AS last_connect_mode_28,
  t0.smartphone_type AS smartphone_type_29,
  t0.smartphone_os_version AS smartphone_os_version_30,
  t0.smartphone_resolution AS smartphone_resolution_31,
  t0.device_tokens AS device_tokens_32,
  t0.date_created AS date_created_33,
  t0.date_updated AS date_updated_34,
  t0.active AS active_35,
  t0.email_validate AS email_validate_36,
  t0.deleted AS deleted_37,
  t0.date_deleted AS date_deleted_38,
  t0.vat_number AS vat_number_39,
  t0.old_id AS old_id_40,
  t0.avatar AS avatar_41,
  t0.url_avatar_provider AS url_avatar_provider_42,
  t0.smartphone_app_version AS smartphone_app_version_43,
  t44.id AS id_45,
  t44.platform AS platform_46,
  t44.build AS build_47,
  t44.label AS label_48,
  t44.date_version AS date_version_49,
  t50.id AS id_51,
  t50.gender AS gender_52,
  t50.gimmick AS gimmick_53,
  t50.birthdate AS birthdate_54,
  t50.best_ranking_date AS best_ranking_date_55,
  t50.hand AS hand_56,
  t50.game_level AS game_level_57,
  t50.nb_play_by_week AS nb_play_by_week_58,
  t50.favorite_player_m AS favorite_player_m_59,
  t50.favorite_player_f AS favorite_player_f_60,
  t50.best_performance AS best_performance_61,
  t50.best_performance_date AS best_performance_date_62,
  t50.best_match_viewed AS best_match_viewed_63,
  t50.other_club AS other_club_64,
  t50.tam_user AS tam_user_65,
  t50.ranking_system AS ranking_system_66,
  t50.current_ranking AS current_ranking_67,
  t50.best_ranking AS best_ranking_68,
  t50.player_type AS player_type_69,
  t50.brand_racket AS brand_racket_70,
  t50.brand_shoe AS brand_shoe_71,
  t50.nb_tournament_by_year AS nb_tournament_by_year_72,
  t50.club AS club_73,
  t74.id AS id_75,
  t74.website AS website_76,
  t74.phone AS phone_77,
  t74.nbcourt AS nbcourt_78,
  t74.contact_name AS contact_name_79,
  t74.contact_phone AS contact_phone_80,
  t74.contact_email AS contact_email_81,
  t74.description AS description_82,
  t74.clubhouse AS clubhouse_83,
  t74.restaurant AS restaurant_84,
  t74.reception_tam_player AS reception_tam_player_85,
  t74.price_session_tam AS price_session_tam_86,
  t74.nb_licensee AS nb_licensee_87,
  t74.nb_licensee_under_eighteen AS nb_licensee_under_eighteen_88,
  t74.year_created AS year_created_89,
  t74.distributor_gc AS distributor_gc_90,
  t74.distributor_ch AS distributor_ch_91,
  t74.date_ask_access AS date_ask_access_92,
  t74.date_ask_access_granted AS date_ask_access_granted_93,
  t74.tam_user AS tam_user_94,
  t95.id AS id_96,
  t95.website AS website_97,
  t95.phone AS phone_98,
  t95.description AS description_99,
  t95.distributor_gc AS distributor_gc_100,
  t95.distributor_ch AS distributor_ch_101,
  t95.date_ask_access AS date_ask_access_102,
  t95.date_ask_access_granted AS date_ask_access_granted_103,
  t95.date_signin AS date_signin_104,
  t95.tam_user AS tam_user_105,
  t95.type_pro AS type_pro_106,
  t107.id AS id_108,
  t107.old_id AS old_id_109,
  t107.website AS website_110,
  t107.phone AS phone_111,
  t107.description AS description_112,
  t107.distributor_gc AS distributor_gc_113,
  t107.distributor_ch AS distributor_ch_114,
  t107.date_ask_access AS date_ask_access_115,
  t107.date_ask_access_granted AS date_ask_access_granted_116,
  t107.tam_user AS tam_user_117
FROM
  tam_users t0
  LEFT JOIN tam_app_version t44 ON t0.smartphone_app_version = t44.id
  LEFT JOIN tam_players t50 ON t50.tam_user = t0.id
  LEFT JOIN tam_clubs t74 ON t74.tam_user = t0.id
  LEFT JOIN tam_pros t95 ON t95.tam_user = t0.id
  LEFT JOIN tam_leagues t107 ON t107.tam_user = t0.id
WHERE
  t0.roles = ?
ORDER BY
  t0.date_created DESC
LIMIT
  4

SELECT t0.id AS id_1, t0.string_confirm_email AS string_confirm_email_2, t0.string_confirm_recovery AS string_confirm_recovery_3, t0.provider AS provider_4, t0.provider_client_id AS provider_client_id_5, t0.access_token AS access_token_6, t0.refresh_token AS refresh_token_7, t0.token_secret AS token_secret_8, t0.expires_in AS expires_in_9, t0.civility AS civility_10, t0.nickname AS nickname_11, t0.lastname AS lastname_12, t0.firstname AS firstname_13, t0.email AS email_14, t0.password AS password_15, t0.oldpassword AS oldpassword_16, t0.salt AS salt_17, t0.roles AS roles_18, t0.address AS address_19, t0.zipcode AS zipcode_20, t0.city AS city_21, t0.country AS country_22, t0.lat AS lat_23, t0.lng AS lng_24, t0.coordinates AS coordinates_25, t0.connected AS connected_26, t0.date_last_connected AS date_last_connected_27, t0.last_connect_mode AS last_connect_mode_28, t0.smartphone_type AS smartphone_type_29, t0.smartphone_os_version AS smartphone_os_version_30, t0.smartphone_resolution AS smartphone_resolution_31, t0.device_tokens AS device_tokens_32, t0.date_created AS date_created_33, t0.date_updated AS date_updated_34, t0.active AS active_35, t0.email_validate AS email_validate_36, t0.deleted AS deleted_37, t0.date_deleted AS date_deleted_38, t0.vat_number AS vat_number_39, t0.old_id AS old_id_40, t0.avatar AS avatar_41, t0.url_avatar_provider AS url_avatar_provider_42, t0.smartphone_app_version AS smartphone_app_version_43, t44.id AS id_45, t44.platform AS platform_46, t44.build AS build_47, t44.label AS label_48, t44.date_version AS date_version_49, t50.id AS id_51, t50.gender AS gender_52, t50.gimmick AS gimmick_53, t50.birthdate AS birthdate_54, t50.best_ranking_date AS best_ranking_date_55, t50.hand AS hand_56, t50.game_level AS game_level_57, t50.nb_play_by_week AS nb_play_by_week_58, t50.favorite_player_m AS favorite_player_m_59, t50.favorite_player_f AS favorite_player_f_60, t50.best_performance AS best_performance_61, t50.best_performance_date AS best_performance_date_62, t50.best_match_viewed AS best_match_viewed_63, t50.other_club AS other_club_64, t50.tam_user AS tam_user_65, t50.ranking_system AS ranking_system_66, t50.current_ranking AS current_ranking_67, t50.best_ranking AS best_ranking_68, t50.player_type AS player_type_69, t50.brand_racket AS brand_racket_70, t50.brand_shoe AS brand_shoe_71, t50.nb_tournament_by_year AS nb_tournament_by_year_72, t50.club AS club_73, t74.id AS id_75, t74.website AS website_76, t74.phone AS phone_77, t74.nbcourt AS nbcourt_78, t74.contact_name AS contact_name_79, t74.contact_phone AS contact_phone_80, t74.contact_email AS contact_email_81, t74.description AS description_82, t74.clubhouse AS clubhouse_83, t74.restaurant AS restaurant_84, t74.reception_tam_player AS reception_tam_player_85, t74.price_session_tam AS price_session_tam_86, t74.nb_licensee AS nb_licensee_87, t74.nb_licensee_under_eighteen AS nb_licensee_under_eighteen_88, t74.year_created AS year_created_89, t74.distributor_gc AS distributor_gc_90, t74.distributor_ch AS distributor_ch_91, t74.date_ask_access AS date_ask_access_92, t74.date_ask_access_granted AS date_ask_access_granted_93, t74.tam_user AS tam_user_94, t95.id AS id_96, t95.website AS website_97, t95.phone AS phone_98, t95.description AS description_99, t95.distributor_gc AS distributor_gc_100, t95.distributor_ch AS distributor_ch_101, t95.date_ask_access AS date_ask_access_102, t95.date_ask_access_granted AS date_ask_access_granted_103, t95.date_signin AS date_signin_104, t95.tam_user AS tam_user_105, t95.type_pro AS type_pro_106, t107.id AS id_108, t107.old_id AS old_id_109, t107.website AS website_110, t107.phone AS phone_111, t107.description AS description_112, t107.distributor_gc AS distributor_gc_113, t107.distributor_ch AS distributor_ch_114, t107.date_ask_access AS date_ask_access_115, t107.date_ask_access_granted AS date_ask_access_granted_116, t107.tam_user AS tam_user_117 FROM tam_users t0 LEFT JOIN tam_app_version t44 ON t0.smartphone_app_version = t44.id LEFT JOIN tam_players t50 ON t50.tam_user = t0.id LEFT JOIN tam_clubs t74 ON t74.tam_user = t0.id LEFT JOIN tam_pros t95 ON t95.tam_user = t0.id LEFT JOIN tam_leagues t107 ON t107.tam_user = t0.id WHERE t0.roles = 'ROLE_PLAYER' ORDER BY t0.date_created DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.description AS description_3,
  t0.indice AS indice_4,
  t0.old_id AS old_id_5
FROM
  tam_brand_racket t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.indice AS indice_4, t0.old_id AS old_id_5 FROM tam_brand_racket t0 WHERE t0.id IN (6);

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.description AS description_3,
  t0.indice AS indice_4,
  t0.old_id AS old_id_5
FROM
  tam_brand_shoe t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.indice AS indice_4, t0.old_id AS old_id_5 FROM tam_brand_shoe t0 WHERE t0.id IN (10);

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.indice AS indice_3
FROM
  tam_player_nb_tournament_by_year t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.label AS label_2, t0.indice AS indice_3 FROM tam_player_nb_tournament_by_year t0 WHERE t0.id IN (2);

SELECT
  t0.id AS id_1,
  t0.string_confirm_email AS string_confirm_email_2,
  t0.string_confirm_recovery AS string_confirm_recovery_3,
  t0.provider AS provider_4,
  t0.provider_client_id AS provider_client_id_5,
  t0.access_token AS access_token_6,
  t0.refresh_token AS refresh_token_7,
  t0.token_secret AS token_secret_8,
  t0.expires_in AS expires_in_9,
  t0.civility AS civility_10,
  t0.nickname AS nickname_11,
  t0.lastname AS lastname_12,
  t0.firstname AS firstname_13,
  t0.email AS email_14,
  t0.password AS password_15,
  t0.oldpassword AS oldpassword_16,
  t0.salt AS salt_17,
  t0.roles AS roles_18,
  t0.address AS address_19,
  t0.zipcode AS zipcode_20,
  t0.city AS city_21,
  t0.country AS country_22,
  t0.lat AS lat_23,
  t0.lng AS lng_24,
  t0.coordinates AS coordinates_25,
  t0.connected AS connected_26,
  t0.date_last_connected AS date_last_connected_27,
  t0.last_connect_mode AS last_connect_mode_28,
  t0.smartphone_type AS smartphone_type_29,
  t0.smartphone_os_version AS smartphone_os_version_30,
  t0.smartphone_resolution AS smartphone_resolution_31,
  t0.device_tokens AS device_tokens_32,
  t0.date_created AS date_created_33,
  t0.date_updated AS date_updated_34,
  t0.active AS active_35,
  t0.email_validate AS email_validate_36,
  t0.deleted AS deleted_37,
  t0.date_deleted AS date_deleted_38,
  t0.vat_number AS vat_number_39,
  t0.old_id AS old_id_40,
  t0.avatar AS avatar_41,
  t0.url_avatar_provider AS url_avatar_provider_42,
  t0.smartphone_app_version AS smartphone_app_version_43,
  t44.id AS id_45,
  t44.platform AS platform_46,
  t44.build AS build_47,
  t44.label AS label_48,
  t44.date_version AS date_version_49,
  t50.id AS id_51,
  t50.gender AS gender_52,
  t50.gimmick AS gimmick_53,
  t50.birthdate AS birthdate_54,
  t50.best_ranking_date AS best_ranking_date_55,
  t50.hand AS hand_56,
  t50.game_level AS game_level_57,
  t50.nb_play_by_week AS nb_play_by_week_58,
  t50.favorite_player_m AS favorite_player_m_59,
  t50.favorite_player_f AS favorite_player_f_60,
  t50.best_performance AS best_performance_61,
  t50.best_performance_date AS best_performance_date_62,
  t50.best_match_viewed AS best_match_viewed_63,
  t50.other_club AS other_club_64,
  t50.tam_user AS tam_user_65,
  t50.ranking_system AS ranking_system_66,
  t50.current_ranking AS current_ranking_67,
  t50.best_ranking AS best_ranking_68,
  t50.player_type AS player_type_69,
  t50.brand_racket AS brand_racket_70,
  t50.brand_shoe AS brand_shoe_71,
  t50.nb_tournament_by_year AS nb_tournament_by_year_72,
  t50.club AS club_73,
  t74.id AS id_75,
  t74.website AS website_76,
  t74.phone AS phone_77,
  t74.nbcourt AS nbcourt_78,
  t74.contact_name AS contact_name_79,
  t74.contact_phone AS contact_phone_80,
  t74.contact_email AS contact_email_81,
  t74.description AS description_82,
  t74.clubhouse AS clubhouse_83,
  t74.restaurant AS restaurant_84,
  t74.reception_tam_player AS reception_tam_player_85,
  t74.price_session_tam AS price_session_tam_86,
  t74.nb_licensee AS nb_licensee_87,
  t74.nb_licensee_under_eighteen AS nb_licensee_under_eighteen_88,
  t74.year_created AS year_created_89,
  t74.distributor_gc AS distributor_gc_90,
  t74.distributor_ch AS distributor_ch_91,
  t74.date_ask_access AS date_ask_access_92,
  t74.date_ask_access_granted AS date_ask_access_granted_93,
  t74.tam_user AS tam_user_94,
  t95.id AS id_96,
  t95.website AS website_97,
  t95.phone AS phone_98,
  t95.description AS description_99,
  t95.distributor_gc AS distributor_gc_100,
  t95.distributor_ch AS distributor_ch_101,
  t95.date_ask_access AS date_ask_access_102,
  t95.date_ask_access_granted AS date_ask_access_granted_103,
  t95.date_signin AS date_signin_104,
  t95.tam_user AS tam_user_105,
  t95.type_pro AS type_pro_106,
  t107.id AS id_108,
  t107.old_id AS old_id_109,
  t107.website AS website_110,
  t107.phone AS phone_111,
  t107.description AS description_112,
  t107.distributor_gc AS distributor_gc_113,
  t107.distributor_ch AS distributor_ch_114,
  t107.date_ask_access AS date_ask_access_115,
  t107.date_ask_access_granted AS date_ask_access_granted_116,
  t107.tam_user AS tam_user_117
FROM
  tam_users t0
  LEFT JOIN tam_app_version t44 ON t0.smartphone_app_version = t44.id
  LEFT JOIN tam_players t50 ON t50.tam_user = t0.id
  LEFT JOIN tam_clubs t74 ON t74.tam_user = t0.id
  LEFT JOIN tam_pros t95 ON t95.tam_user = t0.id
  LEFT JOIN tam_leagues t107 ON t107.tam_user = t0.id
WHERE
  t0.roles = ?
ORDER BY
  t0.date_created DESC
LIMIT
  4

SELECT t0.id AS id_1, t0.string_confirm_email AS string_confirm_email_2, t0.string_confirm_recovery AS string_confirm_recovery_3, t0.provider AS provider_4, t0.provider_client_id AS provider_client_id_5, t0.access_token AS access_token_6, t0.refresh_token AS refresh_token_7, t0.token_secret AS token_secret_8, t0.expires_in AS expires_in_9, t0.civility AS civility_10, t0.nickname AS nickname_11, t0.lastname AS lastname_12, t0.firstname AS firstname_13, t0.email AS email_14, t0.password AS password_15, t0.oldpassword AS oldpassword_16, t0.salt AS salt_17, t0.roles AS roles_18, t0.address AS address_19, t0.zipcode AS zipcode_20, t0.city AS city_21, t0.country AS country_22, t0.lat AS lat_23, t0.lng AS lng_24, t0.coordinates AS coordinates_25, t0.connected AS connected_26, t0.date_last_connected AS date_last_connected_27, t0.last_connect_mode AS last_connect_mode_28, t0.smartphone_type AS smartphone_type_29, t0.smartphone_os_version AS smartphone_os_version_30, t0.smartphone_resolution AS smartphone_resolution_31, t0.device_tokens AS device_tokens_32, t0.date_created AS date_created_33, t0.date_updated AS date_updated_34, t0.active AS active_35, t0.email_validate AS email_validate_36, t0.deleted AS deleted_37, t0.date_deleted AS date_deleted_38, t0.vat_number AS vat_number_39, t0.old_id AS old_id_40, t0.avatar AS avatar_41, t0.url_avatar_provider AS url_avatar_provider_42, t0.smartphone_app_version AS smartphone_app_version_43, t44.id AS id_45, t44.platform AS platform_46, t44.build AS build_47, t44.label AS label_48, t44.date_version AS date_version_49, t50.id AS id_51, t50.gender AS gender_52, t50.gimmick AS gimmick_53, t50.birthdate AS birthdate_54, t50.best_ranking_date AS best_ranking_date_55, t50.hand AS hand_56, t50.game_level AS game_level_57, t50.nb_play_by_week AS nb_play_by_week_58, t50.favorite_player_m AS favorite_player_m_59, t50.favorite_player_f AS favorite_player_f_60, t50.best_performance AS best_performance_61, t50.best_performance_date AS best_performance_date_62, t50.best_match_viewed AS best_match_viewed_63, t50.other_club AS other_club_64, t50.tam_user AS tam_user_65, t50.ranking_system AS ranking_system_66, t50.current_ranking AS current_ranking_67, t50.best_ranking AS best_ranking_68, t50.player_type AS player_type_69, t50.brand_racket AS brand_racket_70, t50.brand_shoe AS brand_shoe_71, t50.nb_tournament_by_year AS nb_tournament_by_year_72, t50.club AS club_73, t74.id AS id_75, t74.website AS website_76, t74.phone AS phone_77, t74.nbcourt AS nbcourt_78, t74.contact_name AS contact_name_79, t74.contact_phone AS contact_phone_80, t74.contact_email AS contact_email_81, t74.description AS description_82, t74.clubhouse AS clubhouse_83, t74.restaurant AS restaurant_84, t74.reception_tam_player AS reception_tam_player_85, t74.price_session_tam AS price_session_tam_86, t74.nb_licensee AS nb_licensee_87, t74.nb_licensee_under_eighteen AS nb_licensee_under_eighteen_88, t74.year_created AS year_created_89, t74.distributor_gc AS distributor_gc_90, t74.distributor_ch AS distributor_ch_91, t74.date_ask_access AS date_ask_access_92, t74.date_ask_access_granted AS date_ask_access_granted_93, t74.tam_user AS tam_user_94, t95.id AS id_96, t95.website AS website_97, t95.phone AS phone_98, t95.description AS description_99, t95.distributor_gc AS distributor_gc_100, t95.distributor_ch AS distributor_ch_101, t95.date_ask_access AS date_ask_access_102, t95.date_ask_access_granted AS date_ask_access_granted_103, t95.date_signin AS date_signin_104, t95.tam_user AS tam_user_105, t95.type_pro AS type_pro_106, t107.id AS id_108, t107.old_id AS old_id_109, t107.website AS website_110, t107.phone AS phone_111, t107.description AS description_112, t107.distributor_gc AS distributor_gc_113, t107.distributor_ch AS distributor_ch_114, t107.date_ask_access AS date_ask_access_115, t107.date_ask_access_granted AS date_ask_access_granted_116, t107.tam_user AS tam_user_117 FROM tam_users t0 LEFT JOIN tam_app_version t44 ON t0.smartphone_app_version = t44.id LEFT JOIN tam_players t50 ON t50.tam_user = t0.id LEFT JOIN tam_clubs t74 ON t74.tam_user = t0.id LEFT JOIN tam_pros t95 ON t95.tam_user = t0.id LEFT JOIN tam_leagues t107 ON t107.tam_user = t0.id WHERE t0.roles = 'ROLE_CLUB' ORDER BY t0.date_created DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.string_confirm_email AS string_confirm_email_2,
  t0.string_confirm_recovery AS string_confirm_recovery_3,
  t0.provider AS provider_4,
  t0.provider_client_id AS provider_client_id_5,
  t0.access_token AS access_token_6,
  t0.refresh_token AS refresh_token_7,
  t0.token_secret AS token_secret_8,
  t0.expires_in AS expires_in_9,
  t0.civility AS civility_10,
  t0.nickname AS nickname_11,
  t0.lastname AS lastname_12,
  t0.firstname AS firstname_13,
  t0.email AS email_14,
  t0.password AS password_15,
  t0.oldpassword AS oldpassword_16,
  t0.salt AS salt_17,
  t0.roles AS roles_18,
  t0.address AS address_19,
  t0.zipcode AS zipcode_20,
  t0.city AS city_21,
  t0.country AS country_22,
  t0.lat AS lat_23,
  t0.lng AS lng_24,
  t0.coordinates AS coordinates_25,
  t0.connected AS connected_26,
  t0.date_last_connected AS date_last_connected_27,
  t0.last_connect_mode AS last_connect_mode_28,
  t0.smartphone_type AS smartphone_type_29,
  t0.smartphone_os_version AS smartphone_os_version_30,
  t0.smartphone_resolution AS smartphone_resolution_31,
  t0.device_tokens AS device_tokens_32,
  t0.date_created AS date_created_33,
  t0.date_updated AS date_updated_34,
  t0.active AS active_35,
  t0.email_validate AS email_validate_36,
  t0.deleted AS deleted_37,
  t0.date_deleted AS date_deleted_38,
  t0.vat_number AS vat_number_39,
  t0.old_id AS old_id_40,
  t0.avatar AS avatar_41,
  t0.url_avatar_provider AS url_avatar_provider_42,
  t0.smartphone_app_version AS smartphone_app_version_43,
  t44.id AS id_45,
  t44.platform AS platform_46,
  t44.build AS build_47,
  t44.label AS label_48,
  t44.date_version AS date_version_49,
  t50.id AS id_51,
  t50.gender AS gender_52,
  t50.gimmick AS gimmick_53,
  t50.birthdate AS birthdate_54,
  t50.best_ranking_date AS best_ranking_date_55,
  t50.hand AS hand_56,
  t50.game_level AS game_level_57,
  t50.nb_play_by_week AS nb_play_by_week_58,
  t50.favorite_player_m AS favorite_player_m_59,
  t50.favorite_player_f AS favorite_player_f_60,
  t50.best_performance AS best_performance_61,
  t50.best_performance_date AS best_performance_date_62,
  t50.best_match_viewed AS best_match_viewed_63,
  t50.other_club AS other_club_64,
  t50.tam_user AS tam_user_65,
  t50.ranking_system AS ranking_system_66,
  t50.current_ranking AS current_ranking_67,
  t50.best_ranking AS best_ranking_68,
  t50.player_type AS player_type_69,
  t50.brand_racket AS brand_racket_70,
  t50.brand_shoe AS brand_shoe_71,
  t50.nb_tournament_by_year AS nb_tournament_by_year_72,
  t50.club AS club_73,
  t74.id AS id_75,
  t74.website AS website_76,
  t74.phone AS phone_77,
  t74.nbcourt AS nbcourt_78,
  t74.contact_name AS contact_name_79,
  t74.contact_phone AS contact_phone_80,
  t74.contact_email AS contact_email_81,
  t74.description AS description_82,
  t74.clubhouse AS clubhouse_83,
  t74.restaurant AS restaurant_84,
  t74.reception_tam_player AS reception_tam_player_85,
  t74.price_session_tam AS price_session_tam_86,
  t74.nb_licensee AS nb_licensee_87,
  t74.nb_licensee_under_eighteen AS nb_licensee_under_eighteen_88,
  t74.year_created AS year_created_89,
  t74.distributor_gc AS distributor_gc_90,
  t74.distributor_ch AS distributor_ch_91,
  t74.date_ask_access AS date_ask_access_92,
  t74.date_ask_access_granted AS date_ask_access_granted_93,
  t74.tam_user AS tam_user_94,
  t95.id AS id_96,
  t95.website AS website_97,
  t95.phone AS phone_98,
  t95.description AS description_99,
  t95.distributor_gc AS distributor_gc_100,
  t95.distributor_ch AS distributor_ch_101,
  t95.date_ask_access AS date_ask_access_102,
  t95.date_ask_access_granted AS date_ask_access_granted_103,
  t95.date_signin AS date_signin_104,
  t95.tam_user AS tam_user_105,
  t95.type_pro AS type_pro_106,
  t107.id AS id_108,
  t107.old_id AS old_id_109,
  t107.website AS website_110,
  t107.phone AS phone_111,
  t107.description AS description_112,
  t107.distributor_gc AS distributor_gc_113,
  t107.distributor_ch AS distributor_ch_114,
  t107.date_ask_access AS date_ask_access_115,
  t107.date_ask_access_granted AS date_ask_access_granted_116,
  t107.tam_user AS tam_user_117
FROM
  tam_users t0
  LEFT JOIN tam_app_version t44 ON t0.smartphone_app_version = t44.id
  LEFT JOIN tam_players t50 ON t50.tam_user = t0.id
  LEFT JOIN tam_clubs t74 ON t74.tam_user = t0.id
  LEFT JOIN tam_pros t95 ON t95.tam_user = t0.id
  LEFT JOIN tam_leagues t107 ON t107.tam_user = t0.id
WHERE
  t0.roles = ?
ORDER BY
  t0.date_created DESC
LIMIT
  4

SELECT t0.id AS id_1, t0.string_confirm_email AS string_confirm_email_2, t0.string_confirm_recovery AS string_confirm_recovery_3, t0.provider AS provider_4, t0.provider_client_id AS provider_client_id_5, t0.access_token AS access_token_6, t0.refresh_token AS refresh_token_7, t0.token_secret AS token_secret_8, t0.expires_in AS expires_in_9, t0.civility AS civility_10, t0.nickname AS nickname_11, t0.lastname AS lastname_12, t0.firstname AS firstname_13, t0.email AS email_14, t0.password AS password_15, t0.oldpassword AS oldpassword_16, t0.salt AS salt_17, t0.roles AS roles_18, t0.address AS address_19, t0.zipcode AS zipcode_20, t0.city AS city_21, t0.country AS country_22, t0.lat AS lat_23, t0.lng AS lng_24, t0.coordinates AS coordinates_25, t0.connected AS connected_26, t0.date_last_connected AS date_last_connected_27, t0.last_connect_mode AS last_connect_mode_28, t0.smartphone_type AS smartphone_type_29, t0.smartphone_os_version AS smartphone_os_version_30, t0.smartphone_resolution AS smartphone_resolution_31, t0.device_tokens AS device_tokens_32, t0.date_created AS date_created_33, t0.date_updated AS date_updated_34, t0.active AS active_35, t0.email_validate AS email_validate_36, t0.deleted AS deleted_37, t0.date_deleted AS date_deleted_38, t0.vat_number AS vat_number_39, t0.old_id AS old_id_40, t0.avatar AS avatar_41, t0.url_avatar_provider AS url_avatar_provider_42, t0.smartphone_app_version AS smartphone_app_version_43, t44.id AS id_45, t44.platform AS platform_46, t44.build AS build_47, t44.label AS label_48, t44.date_version AS date_version_49, t50.id AS id_51, t50.gender AS gender_52, t50.gimmick AS gimmick_53, t50.birthdate AS birthdate_54, t50.best_ranking_date AS best_ranking_date_55, t50.hand AS hand_56, t50.game_level AS game_level_57, t50.nb_play_by_week AS nb_play_by_week_58, t50.favorite_player_m AS favorite_player_m_59, t50.favorite_player_f AS favorite_player_f_60, t50.best_performance AS best_performance_61, t50.best_performance_date AS best_performance_date_62, t50.best_match_viewed AS best_match_viewed_63, t50.other_club AS other_club_64, t50.tam_user AS tam_user_65, t50.ranking_system AS ranking_system_66, t50.current_ranking AS current_ranking_67, t50.best_ranking AS best_ranking_68, t50.player_type AS player_type_69, t50.brand_racket AS brand_racket_70, t50.brand_shoe AS brand_shoe_71, t50.nb_tournament_by_year AS nb_tournament_by_year_72, t50.club AS club_73, t74.id AS id_75, t74.website AS website_76, t74.phone AS phone_77, t74.nbcourt AS nbcourt_78, t74.contact_name AS contact_name_79, t74.contact_phone AS contact_phone_80, t74.contact_email AS contact_email_81, t74.description AS description_82, t74.clubhouse AS clubhouse_83, t74.restaurant AS restaurant_84, t74.reception_tam_player AS reception_tam_player_85, t74.price_session_tam AS price_session_tam_86, t74.nb_licensee AS nb_licensee_87, t74.nb_licensee_under_eighteen AS nb_licensee_under_eighteen_88, t74.year_created AS year_created_89, t74.distributor_gc AS distributor_gc_90, t74.distributor_ch AS distributor_ch_91, t74.date_ask_access AS date_ask_access_92, t74.date_ask_access_granted AS date_ask_access_granted_93, t74.tam_user AS tam_user_94, t95.id AS id_96, t95.website AS website_97, t95.phone AS phone_98, t95.description AS description_99, t95.distributor_gc AS distributor_gc_100, t95.distributor_ch AS distributor_ch_101, t95.date_ask_access AS date_ask_access_102, t95.date_ask_access_granted AS date_ask_access_granted_103, t95.date_signin AS date_signin_104, t95.tam_user AS tam_user_105, t95.type_pro AS type_pro_106, t107.id AS id_108, t107.old_id AS old_id_109, t107.website AS website_110, t107.phone AS phone_111, t107.description AS description_112, t107.distributor_gc AS distributor_gc_113, t107.distributor_ch AS distributor_ch_114, t107.date_ask_access AS date_ask_access_115, t107.date_ask_access_granted AS date_ask_access_granted_116, t107.tam_user AS tam_user_117 FROM tam_users t0 LEFT JOIN tam_app_version t44 ON t0.smartphone_app_version = t44.id LEFT JOIN tam_players t50 ON t50.tam_user = t0.id LEFT JOIN tam_clubs t74 ON t74.tam_user = t0.id LEFT JOIN tam_pros t95 ON t95.tam_user = t0.id LEFT JOIN tam_leagues t107 ON t107.tam_user = t0.id WHERE t0.roles = 'ROLE_PRO' ORDER BY t0.date_created DESC LIMIT 4;