Résultats


#4 - Boccia, Marie-Pierre Leblanc: Jouer avec une paralysie cérébrale
Marie Mainguy • 2019
Flickr FLICKR HANDISPORT
Photos en lien avec votre recherche mots-clé



Aucun résultat !
(production) 23 queries took 76 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `DocumentsPersonne`.`id`, `DocumentsPersonne`.`document_id` FROM `ExtranetFFH`.`documents_personnes` AS `DocumentsPersonne` WHERE ((`nf` LIKE '%Marie-Pierre%') OR ((SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM personnes P where `P`.`id` = `DocumentsPersonne`.`personne_id`) LIKE '%Marie-Pierre%')) ORDER BY `rang` ASC LIMIT 1000119
2SELECT `DocumentsPersonne`.`id`, `DocumentsPersonne`.`document_id` FROM `ExtranetFFH`.`documents_personnes` AS `DocumentsPersonne` WHERE ((`nf` LIKE '%Leblanc%') OR ((SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM personnes P where `P`.`id` = `DocumentsPersonne`.`personne_id`) LIKE '%Leblanc%')) ORDER BY `rang` ASC LIMIT 1000113
3SELECT COUNT(*) AS `count` FROM `ExtranetFFH`.`documents` AS `Document` WHERE `type` = '1' AND `Document`.`published` IS NOT NULL AND `Document`.`validate` IS NOT NULL AND `Document`.`show_centre_ressource_federal` = 1 AND ((((`Document`.`name` LIKE '%Marie-Pierre%') AND (`Document`.`name` LIKE '%Leblanc%'))) OR (((`Document`.`resume` LIKE '%Marie-Pierre%') AND (`Document`.`resume` LIKE '%Leblanc%'))) OR (((`Document`.`authors` LIKE '%Marie-Pierre%') AND (`Document`.`authors` LIKE '%Leblanc%'))) OR (((`Document`.`sommaire` LIKE '%Marie-Pierre%') AND (`Document`.`sommaire` LIKE '%Leblanc%'))) OR (((`Document`.`id` = (2412)) AND (`Document`.`id` = (2412)))))1120
4SELECT `DocumentsLangue`.`id`, `DocumentsLangue`.`document_id` FROM `ExtranetFFH`.`documents_langues` AS `DocumentsLangue` WHERE `langue_id` = 1 ORDER BY `rang` ASC251225121
5SELECT `DocumentsLangue`.`id`, `DocumentsLangue`.`document_id` FROM `ExtranetFFH`.`documents_langues` AS `DocumentsLangue` WHERE `langue_id` != 1 GROUP BY document_id ORDER BY `rang` ASC3843840
6SELECT `Document`.`id`, `Document`.`code`, `Document`.`code_papier`, `Document`.`code_papier2`, `Document`.`event_id`, `Document`.`collection_id`, `Document`.`type`, `Document`.`type_redactionnel_old`, `Document`.`type_redactionnel`, `Document`.`categorie`, `Document`.`name`, `Document`.`authors`, `Document`.`publication`, `Document`.`pages`, `Document`.`exemplaires`, `Document`.`extract_url`, `Document`.`url`, `Document`.`url_key`, `Document`.`thumb_url`, `Document`.`thumb_url_key`, `Document`.`thumb_url_media`, `Document`.`url_doc_complet`, `Document`.`disponibilite`, `Document`.`created`, `Document`.`user_create_id`, `Document`.`modified`, `Document`.`user_modify_id`, `Document`.`resume`, `Document`.`resume_full`, `Document`.`sommaire`, `Document`.`commentaires_pierre`, `Document`.`commentaires`, `Document`.`published`, `Document`.`user_publish_id`, `Document`.`annee`, `Document`.`validate`, `Document`.`user_validate_id`, `Document`.`url_medias`, `Document`.`proposed`, `Document`.`doute_proposed`, `Document`.`doute`, `Document`.`user_proposed_id`, `Document`.`blocked`, `Document`.`motif_blocked`, `Document`.`verified_by_pierre`, `Document`.`reseau_ffh`, `Document`.`une_ressources`, `Document`.`mis_en_avant`, `Document`.`show_centre_ressource_federal`, `Document`.`show_espace_club_section`, `Document`.`show_espace_cd`, `Document`.`show_espace_cr`, `Document`.`show_espace_cs`, `Document`.`show_espace_ffh`, `Document`.`show_espace_stagiaire`, `Document`.`show_espace_indiv`, `Document`.`show_espace_conv`, `Document`.`dashboard_extranet`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_create_id` LIMIT 1) AS `Document__UCR`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_modify_id` LIMIT 1) AS `Document__UMY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_validate_id` LIMIT 1) AS `Document__UVY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_publish_id` LIMIT 1) AS `Document__UPY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_proposed_id` LIMIT 1) AS `Document__UPR`, (SELECT `E`.`NAME` FROM events E where `E`.`id` = `Document`.`event_id` LIMIT 1) AS `Document__EVNAME`, (SELECT photo_thumb FROM annuaires A where `A`.`user_id` = `Document`.`user_create_id` group by `A`.`id` LIMIT 1) AS `Document__UCR_thumb` FROM `ExtranetFFH`.`documents` AS `Document` WHERE `Document`.`id` IN (625, 612, 610, 609, 608, 607, 606, 605, 604, 603, 613, 614, 615, 624, 623, 622, 621, 620, 619, 618, 617, 616, 602, 601, 588, 587, 586, 585, 584, 583, 580, 579, 578, 589, 590, 591, 600, 599, 598, 597, 596, 595, 594, 593, 592, 577, 626, 682, 668, 667, 666, 665, 664, 662, 661, 660, 657, 669, 670, 671, 681, 680, 679, 678, 677, 675, 674, 673, 672, 656, 655, 639, 638, 637, 635, 632, 631, 630, 629, 628, 643, 644, 645, 654, 653, 652, 651, 650, 649, 648, 647, 646, 627, 529, 516, 515, 514, 513, 512, 511, 510, 509, 508, 517, 518, 519, 528, 527, 526, 525, 524, 523, 522, 521, 520, 507, 506, 493, 492, 491, 490, 489, 488, 487, 485, 481, 494, 495, 496, 505, 504, 503, 502, 501, 500, 499, 498, 497, 480, 530, 576, 563, 562, 561, 560, 559, 558, 557, 556, 555, 564, 565, 566, 575, 574, 573, 572, 571, 570, 569, 568, 567, 554, 553, 540, 539, 538, 537, 536, 535, 534, 533, 532, 541, 542, 543, 552, 551, 550, 549, 548, 547, 546, 545, 544, 531, 839, 825, 824, 821, 817, 816, 815, 814, 813, 812, 826, 827, 828, 838, 837, 836, 835, 834, 833, 832, 831, 830, 811, 810, 795, 792, 790, 789, 788, 787, 786, 785, 784, 796, 797, 798, 809, 807, 805, 804, 803, 802, 801, 800, 799, 783, 840, 892, 878, 877, 876, 875, 874, 873, 872, 871, 870, 879, 881, 882, 891, 890, 889, 888, 887, 886, 885, 884, 883, 869, 868, 853, 851, 849, 848, 847, 845, 844, 843, 842, 854, 855, 856, 867, 866, 865, 864, 863, 862, 861, 860, 858, 841, 731, 718, 717, 716, 715, 714, 713, 712, 711, 710, 719, 720, 721, 730, 729, 728, 727, 726, 725, 724, 723, 722, 707, 706, 692, 691, 690, 689, 688, 687, 686, 685, 684, 693, 694, 695, 705, 704, 702, 701, 700, 699, 698, 697, 696, 683, 732, 781, 768, 767, 766, 765, 763, 762, 761, 760, 759, 769, 770, 771, 780, 779, 778, 777, 776, 775, 774, 773, 772, 758, 757, 742, 741, 740, 739, 738, 737, 736, 735, 734, 745, 746, 747, 756, 755, 754, 753, 752, 751, 750, 749, 748, 733, 193, 180, 179, 178, 177, 176, 175, 174, 173, 172, 181, 182, 183, 192, 191, 190, 189, 188, 187, 186, 185, 184, 171, 170, 127, 126, 125, 124, 123, 122, 120, 119, 118, 128, 129, 130, 169, 168, 167, 137, 135, 134, 133, 132, 131, 117, 194, 258, 230, 229, 228, 227, 226, 225, 224, 223, 221, 233, 235, 236, 257, 255, 254, 253, 242, 241, 240, 239, 238, 220, 219, 206, 205, 204, 202, 201, 199, 198, 197, 196, 207, 208, 209, 218, 217, 216, 215, 214, 213, 212, 211, 210, 195, 65, 51, 50, 49, 48, 47, 46, 45, 44, 43, 53, 54, 55, 64, 63, 62, 61, 60, 59, 58, 57, 56, 42, 41, 18, 17, 16, 14, 11, 10, 9, 8, 7, 19, 22, 23, 35, 33, 30, 29, 28, 27, 26, 25, 24, 2, 66, 115, 102, 101, 99, 98, 97, 96, 95, 94, 93, 103, 104, 105, 114, 113, 112, 111, 110, 109, 108, 107, 106, 92, 91, 77, 76, 75, 74, 73, 71, 70, 69, 68, 78, 79, 80, 89, 88, 87, 86, 85, 84, 83, 82, 81, 67, 428, 414, 413, 412, 411, 410, 409, 408, 407, 405, 415, 416, 417, 427, 426, 424, 423, 422, 421, 420, 419, 418, 404, 403, 390, 389, 388, 387, 386, 385, 384, 383, 382, 391, 392, 393, 402, 401, 400, 399, 398, 397, 396, 395, 394, 381, 429, 479, 466, 465, 464, 463, 462, 461, 460, 457, 456, 467, 468, 469, 478, 477, 476, 475, 474, 473, 472, 471, 470, 455, 454, 440, 439, 438, 437, 436, 435, 434, 432, 431, 441, 442, 443, 453, 452, 451, 450, 448, 447, 446, 445, 444, 430, 329, 316, 313, 312, 311, 310, 309, 308, 307, 306, 317, 318, 319, 328, 327, 326, 325, 324, 323, 322, 321, 320, 303, 286, 270, 269, 268, 267, 266, 264, 263, 262, 260, 272, 273, 275, 285, 284, 282, 281, 280, 279, 278, 277, 276, 259, 330, 380, 366, 365, 364, 363, 362, 361, 360, 359, 358, 367, 368, 379, 378, 377, 376, 375, 374, 372, 370, 369, 357, 356, 355, 341, 340, 338, 337, 336, 335, 334, 333, 332, 342, 343, 354, 353, 352, 351, 350, 349, 347, 345, 344, 331, 1568, 1555, 1554, 1553, 1552, 1551, 1550, 1549, 1548, 1547, 1556, 1557, 1558, 1567, 1566, 1565, 1564, 1563, 1562, 1561, 1560, 1559, 1546, 1545, 1532, 1530, 1529, 1528, 1527, 1526, 1525, 1524, 1523, 1533, 1534, 1535, 1544, 1543, 1542, 1541, 1540, 1539, 1538, 1537, 1536, 1522, 1569, 1619, 1602, 1601, 1600, 1599, 1598, 1597, 1596, 1595, 1594, 1603, 1604, 1605, 1618, 1617, 1616, 1615, 1614, 1613, 1612, 1611, 1610, 1593, 1592, 1579, 1578, 1577, 1576, 1575, 1574, 1573, 1572, 1571, 1580, 1581, 1582, 1591, 1590, 1589, 1588, 1587, 1586, 1585, 1584, 1583, 1570, 1472, 1459, 1458, 1457, 1456, 1455, 1454, 1453, 1452, 1451, 1460, 1461, 1462, 1471, 1470, 1469, 1468, 1467, 1466, 1465, 1464, 1463, 1450, 1449, 1436, 1435, 1434, 1433, 1432, 1431, 1430, 1429, 1428, 1437, 1438, 1439, 1448, 1447, 1446, 1445, 1444, 1443, 1442, 1441, 1440, 1427, 1473, 1521, 1506, 1505, 1504, 1503, 1502, 1501, 1500, 1499, 1498, 1507, 1508, 1509, 1520, 1519, 1518, 1517, 1516, 1515, 1514, 1512, 1511, 1497, 1496, 1483, 1482, 1481, 1480, 1479, 1478, 1477, 1476, 1475, 1484, 1485, 1486, 1495, 1494, 1493, 1492, 1491, 1490, 1489, 1488, 1487, 1474, 1764, 1751, 1750, 1749, 1748, 1747, 1746, 1745, 1744, 1743, 1752, 1753, 1754, 1763, 1762, 1761, 1760, 1759, 1758, 1757, 1756, 1755, 1742, 1741, 1726, 1725, 1724, 1723, 1722, 1721, 1720, 1719, 1718, 1727, 1728, 1729, 1740, 1738, 1737, 1736, 1735, 1734, 1732, 1731, 1730, 1717, 1765, 1812, 1798, 1797, 1796, 1795, 1794, 1793, 1792, 1791, 1790, 1799, 1800, 1801, 1811, 1810, 1809, 1808, 1807, 1806, 1805, 1803, 1802, 1789, 1788, 1775, 1774, 1773, 1772, 1771, 1770, 1769, 1768, 1767, 1776, 1777, 1778, 1787, 1786, 1785, 1784, 1783, 1782, 1781, 1780, 1779, 1766, 1667, 1652, 1651, 1650, 1649, 1648, 1647, 1646, 1645, 1644, 1653, 1654, 1657, 1666, 1665, 1664, 1663, 1662, 1661, 1660, 1659, 1658, 1643, 1642, 1629, 1628, 1627, 1626, 1625, 1624, 1623, 1622, 1621, 1630, 1631, 1632, 1641, 1640, 1639, 1638, 1637, 1636, 1635, 1634, 1633, 1620, 1668, 1716, 1703, 1702, 1701, 1700, 1699, 1698, 1697, 1696, 1695, 1704, 1705, 1706, 1715, 1714, 1713, 1712, 1711, 1710, 1709, 1708, 1707, 1694, 1693, 1680, 1679, 1678, 1677, 1676, 1675, 1674, 1672, 1671, 1681, 1682, 1683, 1692, 1691, 1690, 1689, 1688, 1687, 1686, 1685, 1684, 1670, 1049, 1036, 1035, 1034, 1033, 1030, 1028, 1026, 1025, 1024, 1037, 1038, 1039, 1048, 1047, 1046, 1045, 1044, 1043, 1042, 1041, 1040, 1023, 1022, 999, 998, 997, 996, 995, 994, 993, 992, 991, 1000, 1001, 1002, 1021, 1020, 1019, 1017, 1016, 1012, 1005, 1004, 1003, 990, 1050, 1240, 1083, 1082, 1081, 1080, 1079, 1078, 1077, 1076, 1075, 1228, 1229, 1230, 1239, 1238, 1237, 1236, 1235, 1234, 1233, 1232, 1231, 1074, 1073, 1060, 1059, 1058, 1057, 1056, 1055, 1054, 1053, 1052, 1061, 1062, 1063, 1072, 1071, 1070, 1069, 1068, 1067, 1066, 1065, 1064, 1051, 940, 927, 926, 925, 924, 923, 922, 921, 920, 919, 928, 929, 930, 939, 938, 937, 936, 935, 934, 933, 932, 931, 918, 917, 902, 901, 900, 899, 898, 897, 896, 895, 894, 905, 906, 907, 916, 915, 914, 913, 912, 911, 910, 909, 908, 893, 941, 989, 975, 974, 973, 972, 971, 970, 969, 968, 966, 977, 978, 979, 988, 987, 986, 985, 984, 983, 982, 981, 980, 965, 964, 951, 950, 949, 948, 947, 946, 945, 944, 943, 952, 953, 954, 963, 962, 961, 960, 959, 958, 957, 956, 955, 942, 1379, 1366, 1365, 1364, 1363, 1362, 1361, 1360, 1359, 1358, 1367, 1368, 1369, 1378, 1377, 1376, 1375, 1374, 1373, 1372, 1371, 1370, 1357, 1356, 1343, 1342, 1341, 1340, 1339, 1338, 1337, 1336, 1335, 1344, 1345, 1346, 1355, 1354, 1353, 1352, 1351, 1350, 1349, 1348, 1347, 1334, 1380, 1426, 1413, 1412, 1411, 1410, 1409, 1408, 1407, 1406, 1405, 1414, 1415, 1416, 1425, 1424, 1423, 1422, 1421, 1420, 1419, 1418, 1417, 1404, 1403, 1390, 1389, 1388, 1387, 1386, 1385, 1384, 1383, 1382, 1391, 1392, 1393, 1402, 1401, 1400, 1399, 1398, 1397, 1396, 1395, 1394, 1381, 1286, 1273, 1272, 1271, 1270, 1269, 1268, 1267, 1266, 1265, 1274, 1275, 1276, 1285, 1284, 1283, 1282, 1281, 1280, 1279, 1278, 1277, 1264, 1263, 1250, 1249, 1248, 1247, 1246, 1245, 1244, 1243, 1242, 1251, 1252, 1253, 1262, 1261, 1260, 1259, 1258, 1257, 1256, 1255, 1254, 1241, 1287, 1333, 1320, 1319, 1318, 1317, 1316, 1315, 1314, 1313, 1312, 1321, 1322, 1323, 1332, 1331, 1330, 1329, 1328, 1327, 1326, 1325, 1324, 1311, 1310, 1297, 1296, 1295, 1294, 1293, 1292, 1291, 1290, 1289, 1298, 1299, 1300, 1309, 1308, 1307, 1306, 1305, 1304, 1303, 1302, 1301, 1288, 2945, 2913, 2912, 2911, 2910, 2909, 2908, 2907, 2906, 2905, 2904, 2903, 2902, 2901, 2899, 2898, 2914, 2921, 2925, 2944, 2943, 2942, 2941, 2939, 2937, 2934, 2933, 2932, 2931, 2930, 2929, 2928, 2927, 2926, 2897, 2896, 2876, 2874, 2873, 2872, 2870, 2868, 2867, 2866, 2865, 2864, 2863, 2862, 2861, 2860, 2859, 2877, 2878, 2880, 2895, 2893, 2892, 2891, 2890, 2889, 2888, 2887, 2886, 2885, 2884, 2883, 2882, 2881, 2879, 2858, 3014, 3000, 2999, 2998, 2997, 2996, 2995, 2994, 2993, 2992, 2991, 2990, 2989, 2988, 2987, 2983, 3001, 3002, 3003, 3056, 3053, 3042, 3041, 3034, 3033, 3017, 3011, 3010, 3009, 3008, 3007, 3006, 3005, 3004, 2982, 2981, 2962, 2961, 2960, 2959, 2958, 2957, 2956, 2955, 2954, 2953, 2952, 2951, 2950, 2948, 2947, 2963, 2964, 2965, 2980, 2979, 2978, 2977, 2976, 2975, 2974, 2973, 2972, 2971, 2970, 2969, 2968, 2967, 2966, 2946, 2783, 2762, 2760, 2761, 2759, 2758, 2757, 2756, 2755, 2754, 2752, 2753, 2751, 2748, 2749, 2747, 2708, 2765, 2766, 2782, 2781, 2779, 2778, 2777, 2776, 2775, 2774, 2773, 2772, 2771, 2770, 2769, 2768, 2767, 2746, 2745, 2724, 2723, 2722, 2721, 2720, 2719, 2718, 2717, 2716, 2714, 2712, 2713, 2711, 2709, 2707, 2726, 2727, 2728, 2744, 2743, 2742, 2741, 2740, 2739, 2737, 2736, 2735, 2734, 2733, 2732, 2731, 2730, 2729, 2706, 2857, 2838, 2836, 2796, 2835, 2834, 2833, 2832, 2831, 2830, 2829, 2828, 2827, 2826, 2825, 2824, 2839, 2840, 2841, 2856, 2855, 2854, 2853, 2852, 2851, 2850, 2849, 2848, 2847, 2846, 2845, 2844, 2843, 2842, 2823, 2822, 2803, 2800, 2799, 2798, 2797, 2795, 2794, 2793, 2792, 2763, 2790, 2789, 2788, 2787, 2785, 2804, 2805, 2806, 2821, 2820, 2819, 2818, 2817, 2816, 2815, 2814, 2813, 2812, 2811, 2810, 2809, 2808, 2807, 2784, 2466, 2452, 2453, 2451, 2450, 2449, 2447, 2446, 2445, 2444, 2454, 2455, 2457, 2465, 2464, 2463, 2462, 2461, 2460, 2459, 2458, 2456, 2442, 2443, 2430, 2429, 806, 2428, 2427, 2426, 2425, 2424, 2423, 2431, 2432, 2433, 2238, 2441, 2440, 2439, 2438, 2437, 2436, 2435, 2434, 2422, 2467, 2513, 2500, 2499, 2498, 2497, 2496, 2495, 2494, 2493, 2492, 2501, 2502, 2503, 2512, 2511, 2510, 2509, 2508, 2507, 2506, 2505, 2504, 2491, 2490, 2476, 2477, 2475, 2474, 2473, 2472, 2471, 2470, 2469, 2478, 2479, 2480, 2489, 2488, 2487, 2486, 2485, 2484, 2483, 2482, 2481, 2468, 2372, 2356, 2355, 2354, 2353, 2352, 2351, 2350, 2349, 2348, 2357, 2358, 2359, 2368, 2367, 2366, 2365, 2364, 2363, 2362, 2361, 2360, 2347, 2346, 2333, 2332, 2331, 2330, 2329, 2328, 2326, 2325, 2319, 2334, 2335, 2336, 2345, 2344, 2343, 2342, 2341, 2340, 2339, 2338, 2337, 2324, 2373, 2421, 2409, 2407, 2406, 2404, 2403, 2402, 2401, 2400, 2398, 2410, 2408, 2411, 2420, 2419, 2418, 2417, 2416, 2415, 2414, 2413, 2412, 2397, 2396, 2384, 2383, 2382, 2380, 2379, 2378, 2377, 2376, 2375, 2385, 2386, 2387, 2395, 2394, 2317, 2393, 2392, 2391, 2390, 2389, 2388, 2374, 2656, 2642, 2641, 2640, 2639, 2638, 2633, 2637, 2636, 2635, 2643, 2644, 2645, 2655, 2654, 2653, 2652, 2651, 2650, 2649, 2648, 2646, 2634, 2632, 2619, 2618, 2617, 2616, 2615, 2614, 2613, 2612, 2611, 2620, 2621, 2622, 2631, 2630, 2629, 2628, 2627, 2626, 2625, 2624, 2623, 2610, 2657, 2705, 2691, 2690, 2689, 2688, 2687, 2686, 2682, 2683, 2684, 2692, 2694, 2695, 2693, 2704, 2703, 2702, 2701, 2700, 2699, 2698, 2696, 2685, 2681, 2668, 2667, 2666, 2665, 2664, 2663, 2662, 2661, 2660, 2669, 2670, 2671, 2679, 2680, 2678, 2677, 2676, 2675, 2674, 2673, 2672, 2658, 2560, 2546, 2545, 2544, 2543, 2542, 2541, 2540, 2539, 2538, 2547, 2548, 2549, 2559, 2558, 2557, 2556, 2555, 2553, 2552, 2551, 2550, 2537, 2536, 2523, 2522, 2521, 2520, 2519, 2518, 2517, 2516, 2515, 2524, 2525, 2526, 2535, 2534, 2533, 2532, 72, 2531, 2530, 2528, 2527, 2514, 2561, 2609, 2595, 2592, 2591, 2590, 2589, 2588, 2587, 2586, 2585, 2596, 2598, 2600, 2607, 2369, 2381, 2606, 2605, 2604, 2603, 2602, 2601, 2584, 2583, 2529, 2565, 2570, 2569, 2568, 2567, 2566, 2564, 2563, 2571, 2572, 2573, 2582, 2581, 2580, 2579, 2578, 2577, 2576, 2575, 2574, 2562, 2018, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 2006, 2007, 2009, 2016, 2017, 2015, 2014, 2013, 2012, 2011, 2010, 2008, 1996, 1995, 1982, 1981, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1983, 1984, 1985, 1994, 1993, 1992, 1991, 1990, 1989, 1988, 1987, 1986, 1973, 2019, 2068, 2053, 2052, 2050, 2049, 2048, 2047, 2046, 2045, 2044, 2054, 2055, 2056, 2067, 2066, 2065, 2064, 2063, 2062, 2059, 2057, 2058, 2043, 2042, 2029, 2028, 2027, 2026, 2025, 2024, 2023, 2022, 2021, 2030, 2031, 2032, 2041, 2040, 2039, 2038, 2037, 2036, 2035, 2034, 2033, 2020, 1911, 1889, 1888, 1887, 1886, 1885, 1884, 1879, 1876, 1874, 1890, 1891, 1894, 1910, 1909, 1908, 1907, 1906, 1904, 1899, 1893, 1896, 1873, 1871, 1822, 1821, 1820, 1819, 1818, 1817, 1816, 1815, 1814, 1823, 1824, 1826, 1870, 1864, 1863, 1862, 1861, 1851, 1829, 1828, 1827, 1813, 1913, 1971, 1941, 1951, 1952, 1953, 1955, 1954, 406, 1950, 1949, 1957, 1960, 1962, 1970, 1969, 1968, 1967, 1966, 1965, 1964, 482, 1961, 1931, 1859, 1925, 1924, 1922, 1921, 1920, 1918, 1919, 1897, 1915, 1926, 1927, 1928, 1875, 1898, 1940, 1939, 483, 1932, 1804, 1930, 1929, 1914, 2274, 2261, 2260, 2259, 2258, 2257, 2256, 2255, 2254, 2253, 2262, 2263, 2264, 2273, 2272, 2271, 2270, 2269, 2268, 2267, 2266, 2265, 2252, 2251, 2128, 2191, 2199, 2228, 2227, 2226, 2225, 2224, 2223, 1972, 2239, 2240, 2250, 2249, 2248, 2247, 2246, 2245, 2244, 2242, 2241, 2222, 2275, 2323, 2308, 2307, 2306, 2305, 2304, 2303, 2302, 2301, 2300, 2309, 2310, 2311, 2322, 2321, 2320, 2318, 2316, 2315, 2314, 2313, 2312, 2299, 2298, 2285, 2284, 2283, 2282, 2281, 2280, 2279, 2278, 2277, 2286, 2287, 2288, 2297, 2296, 2295, 2294, 2293, 2292, 2291, 2290, 2289, 2276, 2124, 2113, 2112, 2100, 2099, 2101, 2111, 2103, 2102, 2098, 2114, 2115, 2116, 1923, 2126, 2125, 2123, 2061, 2051, 2119, 2118, 2117, 2097, 2096, 2078, 2077, 2076, 2075, 2074, 2073, 2072, 2071, 2070, 2082, 2083, 2085, 2095, 2093, 2092, 2091, 2090, 2089, 2088, 2087, 2086, 2069, 2221, 2206, 2205, 2203, 2202, 2201, 2200, 2198, 2193, 2192, 2207, 2208, 2209, 2219, 2216, 2215, 2214, 2212, 2213, 2204, 2211, 2210, 2190, 2185, 2186, 2146, 2145, 2144, 2143, 2142, 2141, 2140, 2139, 2138, 2147, 2148, 2149, 2187, 2188, 2189, 2154, 2153, 2152, 2151, 2150, 2127, 2110, 371) AND `type` = '1' AND `Document`.`published` IS NOT NULL AND `Document`.`validate` IS NOT NULL AND `Document`.`show_centre_ressource_federal` = 1 AND ((((`Document`.`name` LIKE '%Marie-Pierre%') AND (`Document`.`name` LIKE '%Leblanc%'))) OR (((`Document`.`resume` LIKE '%Marie-Pierre%') AND (`Document`.`resume` LIKE '%Leblanc%'))) OR (((`Document`.`authors` LIKE '%Marie-Pierre%') AND (`Document`.`authors` LIKE '%Leblanc%'))) OR (((`Document`.`sommaire` LIKE '%Marie-Pierre%') AND (`Document`.`sommaire` LIKE '%Leblanc%'))) OR (((`Document`.`id` = (2412)) AND (`Document`.`id` = (2412))))) ORDER BY `Document`.`mis_en_avant` DESC, `Document`.`annee` DESC, `Document`.`name` ASC LIMIT 10001117
7SELECT `DocumentsTheme`.`id`, `DocumentsTheme`.`theme_id`, `DocumentsTheme`.`document_id` FROM `ExtranetFFH`.`documents_themes` AS `DocumentsTheme` WHERE `DocumentsTheme`.`document_id` = (2412)330
8SELECT `Theme`.`name` FROM `ExtranetFFH`.`themes` AS `Theme` WHERE `Theme`.`id` = 1110
9SELECT `Theme`.`name` FROM `ExtranetFFH`.`themes` AS `Theme` WHERE `Theme`.`id` = 3110
10SELECT `Theme`.`name` FROM `ExtranetFFH`.`themes` AS `Theme` WHERE `Theme`.`id` = 4110
11SELECT `Document`.`id`, `Document`.`code`, `Document`.`code_papier`, `Document`.`code_papier2`, `Document`.`event_id`, `Document`.`collection_id`, `Document`.`type`, `Document`.`type_redactionnel_old`, `Document`.`type_redactionnel`, `Document`.`categorie`, `Document`.`name`, `Document`.`authors`, `Document`.`publication`, `Document`.`pages`, `Document`.`exemplaires`, `Document`.`extract_url`, `Document`.`url`, `Document`.`url_key`, `Document`.`thumb_url`, `Document`.`thumb_url_key`, `Document`.`thumb_url_media`, `Document`.`url_doc_complet`, `Document`.`disponibilite`, `Document`.`created`, `Document`.`user_create_id`, `Document`.`modified`, `Document`.`user_modify_id`, `Document`.`resume`, `Document`.`resume_full`, `Document`.`sommaire`, `Document`.`commentaires_pierre`, `Document`.`commentaires`, `Document`.`published`, `Document`.`user_publish_id`, `Document`.`annee`, `Document`.`validate`, `Document`.`user_validate_id`, `Document`.`url_medias`, `Document`.`proposed`, `Document`.`doute_proposed`, `Document`.`doute`, `Document`.`user_proposed_id`, `Document`.`blocked`, `Document`.`motif_blocked`, `Document`.`verified_by_pierre`, `Document`.`reseau_ffh`, `Document`.`une_ressources`, `Document`.`mis_en_avant`, `Document`.`show_centre_ressource_federal`, `Document`.`show_espace_club_section`, `Document`.`show_espace_cd`, `Document`.`show_espace_cr`, `Document`.`show_espace_cs`, `Document`.`show_espace_ffh`, `Document`.`show_espace_stagiaire`, `Document`.`show_espace_indiv`, `Document`.`show_espace_conv`, `Document`.`dashboard_extranet`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_create_id` LIMIT 1) AS `Document__UCR`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_modify_id` LIMIT 1) AS `Document__UMY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_validate_id` LIMIT 1) AS `Document__UVY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_publish_id` LIMIT 1) AS `Document__UPY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_proposed_id` LIMIT 1) AS `Document__UPR`, (SELECT `E`.`NAME` FROM events E where `E`.`id` = `Document`.`event_id` LIMIT 1) AS `Document__EVNAME`, (SELECT photo_thumb FROM annuaires A where `A`.`user_id` = `Document`.`user_create_id` group by `A`.`id` LIMIT 1) AS `Document__UCR_thumb` FROM `ExtranetFFH`.`documents` AS `Document` WHERE `Document`.`id` IN (149, 165, 237, 283, 302, 581, 703, 850, 1095, 1111, 1127, 1143, 1159, 1175, 1191, 1207, 1223, 1880, 1956, 2136, 859, 12, 150, 166, 243, 287, 304, 582, 708, 852, 1096, 1112, 1128, 1144, 1160, 1176, 1192, 1208, 1224, 1881, 1958, 2137, 2949, 15, 90, 151, 244, 288, 305, 709, 880, 1097, 1113, 1129, 1145, 1161, 1177, 1193, 1209, 1225, 1883, 1959, 2131, 2986, 20, 121, 152, 245, 289, 314, 743, 1098, 1114, 1130, 1146, 1162, 1178, 1194, 1210, 1226, 1900, 1963, 2129, 371, 21, 136, 153, 246, 290, 339, 633, 744, 1099, 1115, 1131, 1147, 1163, 1179, 1195, 1211, 1227, 1901, 484, 2094, 138, 154, 247, 291, 346, 634, 764, 1084, 1100, 1116, 1132, 1148, 1164, 1180, 1196, 1212, 1902, 2060, 2080, 139, 155, 248, 292, 348, 640, 782, 1085, 1101, 1117, 1133, 1149, 1165, 1181, 1197, 1213, 1903, 2079, 1882, 32, 140, 156, 249, 293, 373, 641, 791, 1086, 1102, 1118, 1134, 1150, 1166, 1182, 1198, 1214, 1905, 2081, 2217, 34, 141, 157, 250, 294, 642, 793, 1087, 1103, 1119, 1135, 1151, 1167, 1183, 1199, 1215, 1912, 2218, 36, 142, 158, 200, 251, 295, 425, 794, 1088, 1104, 1120, 1136, 1152, 1168, 1184, 1200, 1216, 1825, 2110, 1877, 315, 37, 143, 159, 203, 252, 296, 818, 1089, 1105, 1121, 1137, 1153, 1169, 1185, 1201, 1217, 1865, 1943, 2084, 31, 1, 38, 144, 160, 256, 297, 433, 819, 1090, 1106, 1122, 1138, 1154, 1170, 1186, 1202, 1218, 1866, 1944, 2130, 2405, 3, 39, 145, 161, 222, 261, 298, 449, 822, 1091, 1107, 1123, 1139, 1155, 1171, 1187, 1203, 1219, 1867, 1945, 2132, 2448, 4, 40, 146, 162, 231, 265, 299, 458, 658, 823, 1092, 1108, 1124, 1140, 1156, 1172, 1188, 1204, 1220, 1868, 1946, 2133, 5, 147, 163, 232, 271, 300, 459, 663, 829, 1093, 1109, 1125, 1141, 1157, 1173, 1189, 1205, 1221, 1872, 1947, 2134, 2597, 6, 148, 164, 234, 274, 301, 676, 1094, 1110, 1126, 1142, 1158, 1174, 1190, 1206, 1222, 1878, 1948, 2135, 2599, 10, 88, 185, 89, 186, 170, 187, 613, 172, 189, 630, 993, 173, 190, 994, 381, 29, 174, 191, 1743, 1772, 30, 175, 192, 1747, 25, 176, 193, 1761, 1689, 177, 194, 424, 1762, 2103, 1691, 178, 646, 1918, 179, 430, 649, 2111, 180, 204, 650, 181, 655, 182, 2472, 53, 183, 54, 184, 567, 836) AND `type` = '1' AND `Document`.`published` IS NOT NULL AND `Document`.`validate` IS NOT NULL AND `Document`.`show_centre_ressource_federal` = 1 AND ((((`Document`.`name` LIKE '%Marie-Pierre%') AND (`Document`.`name` LIKE '%Leblanc%'))) OR (((`Document`.`resume` LIKE '%Marie-Pierre%') AND (`Document`.`resume` LIKE '%Leblanc%'))) OR (((`Document`.`authors` LIKE '%Marie-Pierre%') AND (`Document`.`authors` LIKE '%Leblanc%'))) OR (((`Document`.`sommaire` LIKE '%Marie-Pierre%') AND (`Document`.`sommaire` LIKE '%Leblanc%'))) OR (((`Document`.`id` = (2412)) AND (`Document`.`id` = (2412))))) ORDER BY `Document`.`mis_en_avant` DESC, `Document`.`annee` DESC, `Document`.`name` ASC LIMIT 1000006
12SELECT COUNT(*) AS `count` FROM `ExtranetFFH`.`documents` AS `Document` WHERE `Document`.`show_centre_ressource_federal` = 1 AND `type` = '2' AND ((((`Document`.`name` LIKE '%Marie-Pierre%') AND (`Document`.`name` LIKE '%Leblanc%'))) OR (((`Document`.`resume` LIKE '%Marie-Pierre%') AND (`Document`.`resume` LIKE '%Leblanc%'))) OR (((`Document`.`sommaire` LIKE '%Marie-Pierre%') AND (`Document`.`sommaire` LIKE '%Leblanc%'))) OR (((`Document`.`id` = (2412)) AND (`Document`.`id` = (2412)))))113
13SELECT `Document`.`id`, `Document`.`code`, `Document`.`code_papier`, `Document`.`code_papier2`, `Document`.`event_id`, `Document`.`collection_id`, `Document`.`type`, `Document`.`type_redactionnel_old`, `Document`.`type_redactionnel`, `Document`.`categorie`, `Document`.`name`, `Document`.`authors`, `Document`.`publication`, `Document`.`pages`, `Document`.`exemplaires`, `Document`.`extract_url`, `Document`.`url`, `Document`.`url_key`, `Document`.`thumb_url`, `Document`.`thumb_url_key`, `Document`.`thumb_url_media`, `Document`.`url_doc_complet`, `Document`.`disponibilite`, `Document`.`created`, `Document`.`user_create_id`, `Document`.`modified`, `Document`.`user_modify_id`, `Document`.`resume`, `Document`.`resume_full`, `Document`.`sommaire`, `Document`.`commentaires_pierre`, `Document`.`commentaires`, `Document`.`published`, `Document`.`user_publish_id`, `Document`.`annee`, `Document`.`validate`, `Document`.`user_validate_id`, `Document`.`url_medias`, `Document`.`proposed`, `Document`.`doute_proposed`, `Document`.`doute`, `Document`.`user_proposed_id`, `Document`.`blocked`, `Document`.`motif_blocked`, `Document`.`verified_by_pierre`, `Document`.`reseau_ffh`, `Document`.`une_ressources`, `Document`.`mis_en_avant`, `Document`.`show_centre_ressource_federal`, `Document`.`show_espace_club_section`, `Document`.`show_espace_cd`, `Document`.`show_espace_cr`, `Document`.`show_espace_cs`, `Document`.`show_espace_ffh`, `Document`.`show_espace_stagiaire`, `Document`.`show_espace_indiv`, `Document`.`show_espace_conv`, `Document`.`dashboard_extranet`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_create_id` LIMIT 1) AS `Document__UCR`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_modify_id` LIMIT 1) AS `Document__UMY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_validate_id` LIMIT 1) AS `Document__UVY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_publish_id` LIMIT 1) AS `Document__UPY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_proposed_id` LIMIT 1) AS `Document__UPR`, (SELECT `E`.`NAME` FROM events E where `E`.`id` = `Document`.`event_id` LIMIT 1) AS `Document__EVNAME`, (SELECT photo_thumb FROM annuaires A where `A`.`user_id` = `Document`.`user_create_id` group by `A`.`id` LIMIT 1) AS `Document__UCR_thumb` FROM `ExtranetFFH`.`documents` AS `Document` WHERE `type` = '2' AND `Document`.`show_centre_ressource_federal` = 1 AND ((((`Document`.`name` LIKE '%Marie-Pierre%') AND (`Document`.`name` LIKE '%Leblanc%'))) OR (((`Document`.`resume` LIKE '%Marie-Pierre%') AND (`Document`.`resume` LIKE '%Leblanc%'))) OR (((`Document`.`sommaire` LIKE '%Marie-Pierre%') AND (`Document`.`sommaire` LIKE '%Leblanc%'))) OR (((`Document`.`id` = (2412)) AND (`Document`.`id` = (2412))))) ORDER BY `annee` DESC, `Document`.`name` ASC004
14SELECT COUNT(*) AS `count` FROM `ExtranetFFH`.`documents` AS `Document` WHERE `Document`.`show_centre_ressource_federal` = 1 AND `type` = '3' AND ((((`Document`.`name` LIKE '%Marie-Pierre%') AND (`Document`.`name` LIKE '%Leblanc%'))) OR (((`Document`.`resume` LIKE '%Marie-Pierre%') AND (`Document`.`resume` LIKE '%Leblanc%'))) OR (((`Document`.`sommaire` LIKE '%Marie-Pierre%') AND (`Document`.`sommaire` LIKE '%Leblanc%'))) OR (((`Document`.`id` = (2412)) AND (`Document`.`id` = (2412)))))112
15SELECT `Document`.`id`, `Document`.`code`, `Document`.`code_papier`, `Document`.`code_papier2`, `Document`.`event_id`, `Document`.`collection_id`, `Document`.`type`, `Document`.`type_redactionnel_old`, `Document`.`type_redactionnel`, `Document`.`categorie`, `Document`.`name`, `Document`.`authors`, `Document`.`publication`, `Document`.`pages`, `Document`.`exemplaires`, `Document`.`extract_url`, `Document`.`url`, `Document`.`url_key`, `Document`.`thumb_url`, `Document`.`thumb_url_key`, `Document`.`thumb_url_media`, `Document`.`url_doc_complet`, `Document`.`disponibilite`, `Document`.`created`, `Document`.`user_create_id`, `Document`.`modified`, `Document`.`user_modify_id`, `Document`.`resume`, `Document`.`resume_full`, `Document`.`sommaire`, `Document`.`commentaires_pierre`, `Document`.`commentaires`, `Document`.`published`, `Document`.`user_publish_id`, `Document`.`annee`, `Document`.`validate`, `Document`.`user_validate_id`, `Document`.`url_medias`, `Document`.`proposed`, `Document`.`doute_proposed`, `Document`.`doute`, `Document`.`user_proposed_id`, `Document`.`blocked`, `Document`.`motif_blocked`, `Document`.`verified_by_pierre`, `Document`.`reseau_ffh`, `Document`.`une_ressources`, `Document`.`mis_en_avant`, `Document`.`show_centre_ressource_federal`, `Document`.`show_espace_club_section`, `Document`.`show_espace_cd`, `Document`.`show_espace_cr`, `Document`.`show_espace_cs`, `Document`.`show_espace_ffh`, `Document`.`show_espace_stagiaire`, `Document`.`show_espace_indiv`, `Document`.`show_espace_conv`, `Document`.`dashboard_extranet`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_create_id` LIMIT 1) AS `Document__UCR`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_modify_id` LIMIT 1) AS `Document__UMY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_validate_id` LIMIT 1) AS `Document__UVY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_publish_id` LIMIT 1) AS `Document__UPY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_proposed_id` LIMIT 1) AS `Document__UPR`, (SELECT `E`.`NAME` FROM events E where `E`.`id` = `Document`.`event_id` LIMIT 1) AS `Document__EVNAME`, (SELECT photo_thumb FROM annuaires A where `A`.`user_id` = `Document`.`user_create_id` group by `A`.`id` LIMIT 1) AS `Document__UCR_thumb` FROM `ExtranetFFH`.`documents` AS `Document` WHERE `Document`.`show_centre_ressource_federal` = 1 AND `type` = '3' AND ((((`Document`.`name` LIKE '%Marie-Pierre%') AND (`Document`.`name` LIKE '%Leblanc%'))) OR (((`Document`.`resume` LIKE '%Marie-Pierre%') AND (`Document`.`resume` LIKE '%Leblanc%'))) OR (((`Document`.`sommaire` LIKE '%Marie-Pierre%') AND (`Document`.`sommaire` LIKE '%Leblanc%'))) OR (((`Document`.`id` = (2412)) AND (`Document`.`id` = (2412))))) ORDER BY `annee` DESC, `Document`.`name` ASC005
16SELECT COUNT(*) AS `count` FROM `ExtranetFFH`.`documents` AS `Document` WHERE `Document`.`show_centre_ressource_federal` = 1 AND `type` = '4' AND ((((`Document`.`name` LIKE '%Marie-Pierre%') AND (`Document`.`name` LIKE '%Leblanc%'))) OR (((`Document`.`resume` LIKE '%Marie-Pierre%') AND (`Document`.`resume` LIKE '%Leblanc%'))) OR (((`Document`.`authors` LIKE '%Marie-Pierre%') AND (`Document`.`authors` LIKE '%Leblanc%'))) OR (((`Document`.`sommaire` LIKE '%Marie-Pierre%') AND (`Document`.`sommaire` LIKE '%Leblanc%'))) OR (((`Document`.`id` = (2412)) AND (`Document`.`id` = (2412)))))113
17SELECT `Document`.`id`, `Document`.`code`, `Document`.`code_papier`, `Document`.`code_papier2`, `Document`.`event_id`, `Document`.`collection_id`, `Document`.`type`, `Document`.`type_redactionnel_old`, `Document`.`type_redactionnel`, `Document`.`categorie`, `Document`.`name`, `Document`.`authors`, `Document`.`publication`, `Document`.`pages`, `Document`.`exemplaires`, `Document`.`extract_url`, `Document`.`url`, `Document`.`url_key`, `Document`.`thumb_url`, `Document`.`thumb_url_key`, `Document`.`thumb_url_media`, `Document`.`url_doc_complet`, `Document`.`disponibilite`, `Document`.`created`, `Document`.`user_create_id`, `Document`.`modified`, `Document`.`user_modify_id`, `Document`.`resume`, `Document`.`resume_full`, `Document`.`sommaire`, `Document`.`commentaires_pierre`, `Document`.`commentaires`, `Document`.`published`, `Document`.`user_publish_id`, `Document`.`annee`, `Document`.`validate`, `Document`.`user_validate_id`, `Document`.`url_medias`, `Document`.`proposed`, `Document`.`doute_proposed`, `Document`.`doute`, `Document`.`user_proposed_id`, `Document`.`blocked`, `Document`.`motif_blocked`, `Document`.`verified_by_pierre`, `Document`.`reseau_ffh`, `Document`.`une_ressources`, `Document`.`mis_en_avant`, `Document`.`show_centre_ressource_federal`, `Document`.`show_espace_club_section`, `Document`.`show_espace_cd`, `Document`.`show_espace_cr`, `Document`.`show_espace_cs`, `Document`.`show_espace_ffh`, `Document`.`show_espace_stagiaire`, `Document`.`show_espace_indiv`, `Document`.`show_espace_conv`, `Document`.`dashboard_extranet`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_create_id` LIMIT 1) AS `Document__UCR`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_modify_id` LIMIT 1) AS `Document__UMY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_validate_id` LIMIT 1) AS `Document__UVY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_publish_id` LIMIT 1) AS `Document__UPY`, (SELECT CONCAT(`P`.`PersonnePrenom`, " ", `P`.`PersonneNom`) FROM users U LEFT JOIN personnes P ON `P`.`id` = `U`.`personne_id` where `U`.`id` = `Document`.`user_proposed_id` LIMIT 1) AS `Document__UPR`, (SELECT `E`.`NAME` FROM events E where `E`.`id` = `Document`.`event_id` LIMIT 1) AS `Document__EVNAME`, (SELECT photo_thumb FROM annuaires A where `A`.`user_id` = `Document`.`user_create_id` group by `A`.`id` LIMIT 1) AS `Document__UCR_thumb` FROM `ExtranetFFH`.`documents` AS `Document` WHERE `Document`.`show_centre_ressource_federal` = 1 AND `type` = '4' AND ((((`Document`.`name` LIKE '%Marie-Pierre%') AND (`Document`.`name` LIKE '%Leblanc%'))) OR (((`Document`.`resume` LIKE '%Marie-Pierre%') AND (`Document`.`resume` LIKE '%Leblanc%'))) OR (((`Document`.`authors` LIKE '%Marie-Pierre%') AND (`Document`.`authors` LIKE '%Leblanc%'))) OR (((`Document`.`sommaire` LIKE '%Marie-Pierre%') AND (`Document`.`sommaire` LIKE '%Leblanc%'))) OR (((`Document`.`id` = (2412)) AND (`Document`.`id` = (2412))))) ORDER BY `annee` DESC, `Document`.`name` ASC003
18SELECT `DocumentsSport`.`sport_id`, `Sport`.`name` FROM `ExtranetFFH`.`documents_sports` AS `DocumentsSport` LEFT JOIN `ExtranetFFH`.`sports` AS `Sport` ON (`DocumentsSport`.`sport_id` = `Sport`.`id`) WHERE `Sport`.`name` IS NOT NULL GROUP BY `DocumentsSport`.`sport_id` ORDER BY `Sport`.`name` Asc86860
19SELECT `Theme`.`id`, `Theme`.`name` FROM `ExtranetFFH`.`themes` AS `Theme` WHERE 1 = 1 ORDER BY `name` ASC13130
20SELECT `Collection`.`id`, `Collection`.`name` FROM `ExtranetFFH`.`collections` AS `Collection` WHERE 1 = 1 ORDER BY `name` ASC16160
21SELECT `Cible`.`id`, `Cible`.`name` FROM `ExtranetFFH`.`cibles` AS `Cible` WHERE 1 = 1 ORDER BY `name` ASC550
22SELECT `Langue`.`id`, `Langue`.`name` FROM `ExtranetFFH`.`langues` AS `Langue` WHERE 1 = 1 ORDER BY `name` ASC11110
23SELECT `Format`.`id`, `Format`.`name` FROM `ExtranetFFH`.`formats` AS `Format` WHERE 1 = 1 ORDER BY `name` ASC440