Предложения спонсоров «Капелланина»: |
debug info
db_connect()
getRow(): SELECT id FROM addr where ip='3.237.31.191'; result: OK
getValue(): SELECT mode FROM addr where id='936132'; result: OK
User not logged in or cookies disabled
Addr_id: 936132; Addr_mode: 2
case ADDR_NOCOOKIES
getValue(): SELECT time FROM addr where id='936132'; result: OK
Time: 1696367330, Saved time: 1696367050
setValue(): UPDATE addr SET mode='1' WHERE id = 936132; result: OK
setValue(): UPDATE addr SET time='1696367330' WHERE id = 936132; result: OK
Redirecting
Redirected
URI: /names/?form=3
Script: /names/index.php
Query: FORM=3
Referer:
getRow(): SELECT `value` FROM `blob` WHERE `key` = 'vkCache' result: OK
lockVkCache(1): INSERT INTO `blob` (`key`, `value`) VALUES ('vkCache', '1696367332.820497'); result: OK
getRow(): SELECT userId FROM vkSources WHERE exclude=0 ORDER BY lastRead LIMIT 1; result: OK
Getting posts for user 2850990. vk.api method: wall.get
getRow(): SELECT `value` FROM `blob` WHERE `key` = 'vk' result: OK
Checking vk access token... Valid. Expires 2023-10-04 08:18:41
Got 10. getRow(): SELECT id FROM vkCache WHERE userId='2850990' AND postId='455' result: OK
addUser(): INSERT INTO vkSources VALUES (2850990, 1696367331, 0) ON DUPLICATE KEY UPDATE lastRead=1696367331; result: NOK
addUser(): Error executing query INSERT INTO vkSources VALUES (2850990, 1696367331, 0) ON DUPLICATE KEY UPDATE lastRead=1696367331; Column count doesn't match value count at row 1
getRow(): SELECT id FROM vkCache WHERE userId='2850990' AND postId='454' result: OK
addUser(): INSERT INTO vkSources VALUES (2850990, 1696367331, 0) ON DUPLICATE KEY UPDATE lastRead=1696367331; result: NOK
addUser(): Error executing query INSERT INTO vkSources VALUES (2850990, 1696367331, 0) ON DUPLICATE KEY UPDATE lastRead=1696367331; Column count doesn't match value count at row 1
cacheVkPost(): UPDATE vkSources SET lastRead=1696367331, state='no updates (10 old posts)', exclude=0 WHERE userId=2850990; result: OK
lockVkCache(): DELETE FROM `blob` WHERE `key` = 'vkCache'; result: OK
getQueryParam(): form=3
printCoursesListFull(): SELECT * FROM course WHERE end <= 2023 ORDER BY end DESC; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2023 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (2183,2186,2237,2238,2239,2240,2241,2242,2243,2244,2245,2246,2247,2248,2249,2250,2251,2252,2253,2254,2289,2292,2293,2315,2316,2317,2336,2450) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2023 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2023; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2022 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (2132,2170,2171,2173,2174,2175,2176,2177,2178,2179,2180,2181,2182,2183,2184,2185,2186,2187,2188,2189,2190,2191,2255,2268,2294,2333,2334,2451,2452,3217,3218) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2022 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2022; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2021 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (2083,2087,2089,2100,2127,2128,2129,2130,2131,2132,2133,2134,2135,2136,2137,2138,2139,2140,2141,2142,2143,2144,2145,2146,2147,2148,2149,2172,2192,2256,2257,2297,2305,2333,2358,2427,2453,4130) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2021 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2021; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2020 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (2083,2084,2085,2086,2087,2088,2089,2090,2091,2092,2093,2094,2095,2096,2097,2098,2099,2100,2101,2112,2114,2127,2150,2258,2259,2296,2297,2318,2463) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2020 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2020; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2019 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (1930,2102,2103,2104,2105,2106,2107,2108,2109,2110,2111,2112,2113,2114,2115,2116,2117,2151,2259,2357) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2019 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2019; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2018 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (1742,1744,1760,1761,1864,1928,1929,1930,1931,1932,1933,1934,1935,1936,1937,1938,1940,2020,2081,2082,2106,2298,2299) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2018 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2018; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2017 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (1685,1699,1728,1742,1743,1744,1745,1746,1747,1748,1749,1750,1751,1752,1753,1754,1755,1757,1758,1759,1760,1761,1918,2080,2082,2118,2126,2218) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2017 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2017; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2016 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (69,820,1500,1658,1685,1686,1697,1698,1699,1700,1701,1715,1728,1737,1738,1739,1740,1741,2120,2260,2261) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2016 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2016; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2015 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (1422,1423,1428,1429,1430,1432,1488,1707,1716,1723,1724,1725,1726,1727,1729,1730,1731,1732,1733,1734,1735,1736,2019,4153) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2015 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2015; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2014 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (1184,1222,1319,1427,1430,1473,1475,1477,1706,1707,1708,1709,1711,1712,1713,1714,1715,1716,1717,1718,1719,1720,1721,1722,2236,4146,4150,4151,4152) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2014 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2014; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2013 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (1184,1424,1425,1426,1431,1471,1472,1473,1474,1475,1476,1477,1478,1479,1480,1481,1482,1483,1485,1510,1678,1684,1696,1804,1806,1817,1820,1903,2079,2266,4143,4144,4145,4146) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2013 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2013; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2012 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (1363,1364,1365,1366,1367,1369,1471,1484,1485,1486,1487,1501,1510,1678,1684,1696,1762,1800,1801,1802,1803,1806,1807,1817,1818,1903,1912,2072,4147) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2012 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2012; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2011 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (930,937,940,941,946,951,953,954,1369,1370,1413,1414,1415,1416,1433,1463,1484,1799,1802,1807,1808,1809,1810,1814,1904,2022,2072,2075,2076,2077,2078,4267) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2011 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2011; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2010 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (926,930,933,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,1463,1467,1468,1490,1656,1799,1814,1815,1816) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2010 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2010; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2009 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (924,925,926,927,928,929,930,931,932,933,934,935,1348,1349,1350,1351,1352,1355,1358,1360,1410,1411,1453,1464,1688,1689,1690,1691,1692,1693) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2009 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2009; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2008 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (875,921,922,923,928,1324,1348,1353,1354,1355,1356,1357,1358,1359,1360,1361,1362,1407,1409,1677) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2008 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2008; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2007 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1368,1372,1406,1408,1434,1489,1495,1852,1854,1915,1916,1917,2003,2069,2573,2610,4148) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2007 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2007; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2006 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (768,811,903,910,911,912,913,914,915,916,917,918,919,920,1012,1013,1014,1015,1016,1017,1028,1372,1400,1402,1403,1404,1405,1462,1465,1466,1702,1851,1853,1892,1893,1894,1895,1896,1897,1898,1899,1900,1901,1911) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2006 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2006; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2005 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (802,812,813,815,819,903,904,905,906,907,908,909,1010,1011,1371,1508,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1887,1888,1889,1890,1891,2233,4149) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2005 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2005; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2004 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (764,765,766,769,770,771,772,773,775,800,803,804,814,898,899,900,901,902,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1337,1338,1371,1884,1885,1886) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2004 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2004; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2003 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (120,124,126,129,133,134,183,185,194,206,240,264,320,384,474,552,764,774,805,897,1183,1223,1224,1225,1226,1276,1277,1278,1279,1280,1281,1328,1435,1868,1878,1880,1881,1882,1883,1884,1909) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2003 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2003; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2002 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (120,133,169,182,194,206,253,423,606,609,630,633,653,701,774,1216,1217,1218,1219,1220,1221,1825,1856,1869,1870,1871,1872,1873,1874,1875,1876,1877) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2002 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2002; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2001 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (91,152,158,384,455,481,598,599,649,746,774,798,799,1217,1417,1418,1419,1420,1436,1437,1438,1439,1440,1441,1442,1443,1454,1511,1826,1827,1828,1829,1865,1866,1867) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2001 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2001; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 2000 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (158,455,713,714,715,716,717,718,719,720,721,722,723,724,794,795,818,1169,1176,1197,1198,1199,1200,1201,1202,1203,1207,1822,1823,1824,2212) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 2000 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 2000; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1999 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (703,704,705,706,707,708,709,710,711,712,760,789,793,806,807,808,809,850,1163,1164,1165,1166,1167,1174,1175,1176,1177,1531,1821) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1999 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1999; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1998 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (93,689,690,691,692,693,694,695,696,697,698,699,700,702,790,796,797,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1087,1088,1190,1805) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1998 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1998; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1997 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (680,681,682,683,684,685,686,687,688,695,744,748,749,750,761,762,779,792,810,1173,1667,1668,1669,1670,1671,1672,1676,1695,1777,1778,1779,1780) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1997 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1997; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1996 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (659,663,667,668,669,670,671,672,673,674,675,676,677,678,679,776,777,778,780,788,1525,1770,1771,1772,1773,1774,1775,1776,4040,4042,4058,4059) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1996 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1996; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1995 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (659,660,661,662,663,664,665,666,673,677,731,759,788,801,810,816,832,857,865,866,967,1286,1287,1288,1289,1290,1291,1292,1293,1294,1295,1296,1375,1376,1377,1379,1530,4037,4041) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1995 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1995; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1994 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (75,99,100,625,643,644,645,646,647,648,650,651,652,654,655,656,657,658,664,747,753,754,757,782,816,1178,1179,1297,1769,1863,1924,1925,1926,4005,4006,4007,4008) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1994 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1994; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1993 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (99,634,635,636,637,638,639,640,641,642,643,658,664,725,735,745,751,752,755,758,782,791,826,857,859,874,1172,1766,1767,1768,2013,2014,2018,2307,2323,2324,2325,3930,4039) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1993 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1993; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1992 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (86,608,620,621,622,623,624,625,626,627,628,629,631,632,636,725,726,727,728,729,732,733,734,735,736,737,738,739,740,741,742,743,751,786,956,957,980,1505,1506,1507,2326,2614,3201,4101) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1992 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1992; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1991 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (45,608,610,611,612,613,614,615,616,617,618,619,756,763,785,837,841,845,856,858,862,1073,1526,1527,1528,1529,3919,3920,3921,3922,3923,3924,3925,3926,3929,3932) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1991 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1991; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1990 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (39,92,117,585,586,595,596,597,600,601,602,603,604,605,607,783,784,817,839,840,844,863,1038,1159,1160,1161,1162,3927) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1990 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1990; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1989 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (584,585,586,587,588,589,590,591,592,593,594,842,843,854,886,1344,1345,1346,1347,1840,2010,2012,2304,4361) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1989 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1989; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1988 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (571,572,573,574,575,576,577,578,579,580,581,582,583,985,986,987,988,1054,1055,1056,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,4284,4285) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1988 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1988; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1987 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (561,562,563,564,565,566,567,568,569,570,787,887,985,1007,1008,1009,1053,1189,1191,1192,1193,1194,1195,1196,1213) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1987 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1987; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1986 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (74,551,553,554,555,556,557,558,559,560,787,1004,1005,1006,1052,1171,2011,2121,2122,2123,2124,2125,3928) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1986 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1986; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1985 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (539,540,541,542,543,544,545,546,547,548,549,550,1001,1002,1003,1919,1920,1921,1922,1923) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1985 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1985; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1984 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (531,532,533,534,535,536,537,538,860,1092,1093,1094,1095,1096,1097,1098,1314,1315,1316,1317,1318,1859,1860,1861,1862,1920,2789) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1984 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1984; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1983 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,861,1084,1085,1086,1137,1138,1139,1140,1141,2017) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1983 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1983; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1982 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,1074,1075,1076,1205,1206,2070,3517,3518,3938,4003,4004) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1982 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1982; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1981 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (76,480,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,1089,1090,1091,1421,1879,1905,1906,1907,2015,2067,2068,3514,3515,3516,3519) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1981 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1981; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1979 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (35,470,471,472,473,475,476,477,478,479,822,1077,1078,1079,1080,1081,1082,1083,1378,1497,1498,1499,1679,1680,1681,1682,1683,1704,3520) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1979 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1979; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1978 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (13,77,458,459,460,461,462,463,464,465,466,467,468,469,821,823,824,825,831,955,970,971,1077,1493,1673,1674,1675,4373) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1978 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1978; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1977 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (52,441,442,443,444,445,446,447,448,449,450,451,452,453,454,456,457,781,968,1309,1310,1311,1399,4371,4372,4374,4376,4382) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1977 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1977; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1976 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (428,429,430,431,432,433,434,435,436,437,438,439,440,1307,1492,1494,2007,2219,2220,2221,2222,2457,4367,4370) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1976 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1976; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1975 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (59,413,414,415,416,417,418,419,420,421,422,424,425,426,427,827,1306,1380,1382,1383,1384,1385,1387,1388,1389,1390,1391,1393,1398) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1975 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1975; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1974 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,828,1298,1299,1300,1301,1302,1303,1304,1306,4366,4375) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1974 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1974; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1973 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (78,382,383,385,386,387,388,389,390,391,392,393,394,395,829,1072,1303,1308,1397,2006,2008,4281,4368,4369,4378) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1973 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1973; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1972 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,2157,4001,4158,4159,4160,4161,4162,4163,4164,4165,4166,4167,4168) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1972 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1972; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1971 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,370,2156,4169,4170,4171,4172,4173,4362,4363) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1971 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1971; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1970 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (335,336,337,338,339,340,341,342,343,344,345,346,347,360,3521,4174,4175,4176,4177,4178,4179,4180,4181) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1970 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1970; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1969 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (325,326,327,328,329,330,331,332,333,334,341,346,4182,4183,4184,4185,4186,4187,4188) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1969 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1969; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1968 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (28,316,317,318,319,321,322,323,324,329,1036,1037,1057,1058,1059,1060,1305,4189,4190) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1968 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1968; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1967 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (28,306,307,308,309,310,311,312,313,314,315,1061,1342,1343,4191,4192,4193) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1967 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1967; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1966 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (293,294,295,296,297,298,299,300,301,302,303,304,305,966,1381,2158,2159) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1966 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1966; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1965 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (283,284,285,286,287,288,289,290,291,292,304,1381,3367,3368,3370,3371,3372,3373,3374,3375) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1965 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1965; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1964 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,292,1147,3348,3349,3350,3351,3363,3364) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1964 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1964; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1963 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (58,259,260,261,262,263,265,266,267,1116,1117,1151,3352,3353,3354,3355,3356,3357,3359,3360,3361,3362) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1963 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1963; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1962 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (95,248,249,250,251,252,254,255,256,257,258,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1155,1156,1157,1158,1168,2327,2460,4200,4222,4225,4226) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1962 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1962; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1961 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (32,236,237,238,239,241,242,243,244,245,246,247,3365,3366,3369,4194,4199,4205,4206,4234) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1961 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1961; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1960 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (227,228,229,230,231,232,233,234,235,4201,4204,4208,4214,4216,4217,4220,4223,4224) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1960 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1960; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1959 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (213,214,215,216,217,218,219,220,221,222,223,224,225,4197,4202,4203,4211,4212,4214,4217,4229,4232) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1959 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1959; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1958 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (25,205,207,208,209,210,211,212,219,2563,2605,2606,2607,2608,2609,2611,4207,4213,4217,4221,4235) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1958 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1958; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1957 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (196,197,198,199,200,201,202,203,204,207,2535,2556,2557,2558,2559,2560,2561,2562,2563,2564,2565,2566,2567,2568,2569,2570,2571,2572,2588,2612,4236) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1957 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1957; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1956 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (5,19,184,186,187,188,189,190,191,192,193,195,200,202,203,960,965,1204,2525,2526,2527,2528,2529,2530,2531,2532,2533,2534,2535,2536,2537,2538,2539,2540,2541,2542,2543,2544,2548,2557,2613) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1956 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1956; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1955 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (34,41,170,171,172,173,174,175,176,177,178,179,180,181,184,202,959,962,963,964,972,973,974,975,976,977,978,979,1756,2464,2465,2476,2477,2478,2491,2496,2500,2506,2529,2530,2534,2545,2550,2551,2552,2574) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1955 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1955; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1954 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (44,159,160,161,162,163,164,165,166,167,168,177,961,2464,2479,2480,2481,2496,2498,2507,2508,2522,2524,2546,2553,2554,2575,2576,2577,2578,2579,2653,4198,4209,4215,4218,4219,4227,4230,4238,4324) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1954 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1954; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1953 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (53,54,149,150,151,153,154,155,156,157,160,1534,1563,2466,2467,2482,2483,2484,2504,2580,2581,2582,2583,2656,3948,4277,4322,4325) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1953 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1953; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1952 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (144,145,146,147,148,153,155,2215,2485,2509,2510,2514,2515,2516,3941,3945,4231,4239) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1952 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1952; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1951 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (12,22,135,136,137,138,139,140,141,142,143,153,1412,2210,2211,2215,2486,2487,2488,2511,2512,2585,2586,2653,2654,2655,2656,3933,3934,3937,3939,3940,3943,3944,3946,3947,3949,3952,3955,4240,4241,4335,4337,4344,4345,4355) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1951 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1951; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1950 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (12,33,130,131,132,135,137,139,140,879,958,1106,2216,2217,2224,2225,2226,2228,2229,2489,2502,2523,2547,2657,2658,2659,2660,3247,3338,3526,3531,4196,4228,4242,4327,4341,4342,4347,4349,4352,4353) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1950 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1950; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1949 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (11,24,31,122,123,125,127,128,130,138,143,877,878,879,1657,2213,2227,2231,2312,2490,2503,2513,2517,2518,2519,2520,2521,2661,2663,2664,2665,2666,2667,2674,3522,3523,3524,3525,3528,3529,3942,3950,3951,3956,4195,4329,4330,4331,4340,4346,4350,4352,4354) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1949 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1949; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1948 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (7,24,119,121,127,982,1186,1187,1188,1657,2227,2229,2235,2309,2487,2585,2666,2668,3214,3245,3246,3247,3248,3250,3251,3253,3260,3273,3527,3530,3935,3936,3954,4210,4233,4323,4328,4338,4343,4351) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1948 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1948; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1947 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (121,123,226,877,989,993,1185,2223,2231,2468,2469,2470,2474,2475,2492,2493,2494,2669,2670,2671,2673,2674,3249,3254,3255,3256,3258,3262,3268,3953,4332,4333,4336) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1947 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1947; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1946 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (3,29,56,118,119,125,981,983,984,991,992,2223,2309,2521,2669,2671,2675,2676,2677,3256,3257,3259,3263,3264,3267,3268,3269,3504,3505,3506,3507) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1946 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1946; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1945 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (3,29,56,118,981,983,984,990,995,996,997,998,999,1000,2223,2230,2232,2300,2678,3158,3159,3160,3162,3163,3164,3165,3166,3167,3168,3169,3170,3171,3172,3173,3174,3175,3176,3177,3178,3179,3180,3181,3182,3183,3184,3185,3186,3187,3188,3189,3190,3191,3192,3193,3194,3244,3261,3265,3266,3272,3503,3508,3509,3510,3511,3512,4321,4334,4339,4348) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1945 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1945; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1944 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (2342,3118,3119,3120,3121,3122,3123,3124,3125,3126,3127,3128,3129,3130,3131,3132,3133,3134,3135,3136,3137,3138,3139,3140,3141,3142,3143,3144,3145,3146,3147,3148,3149,3150,3151,3152,3153,3154,3155,3156,3157) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1944 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1944; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1943 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (3078,3079,3080,3081,3082,3083,3084,3085,3086,3087,3088,3089,3090,3091,3092,3093,3094,3095,3096,3097,3098,3099,3100,3101,3102,3103,3104,3105,3106,3107,3108,3109,3110,3111,3112,3113,3114,3115,3116,3117) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1943 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1943; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1942 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (3033,3034,3035,3036,3037,3038,3039,3040,3041,3042,3043,3044,3045,3046,3047,3048,3049,3050,3051,3052,3053,3054,3055,3056,3057,3058,3059,3060,3061,3062,3063,3064,3065,3066,3067,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1942 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1942; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1941 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (2988,2989,2990,2991,2992,2993,2994,2995,2996,2997,2998,2999,3000,3001,3002,3003,3004,3005,3006,3007,3008,3009,3010,3011,3012,3013,3014,3015,3016,3017,3018,3019,3020,3021,3022,3023,3024,3025,3026,3027,3028,3029,3030,3031,3032) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1941 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1941; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1940 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (1180,2953,2954,2955,2956,2957,2958,2959,2960,2961,2962,2963,2964,2965,2966,2967,2968,2969,2970,2971,2972,2973,2974,2975,2976,2977,2978,2979,2980,2981,2982,2983,2984,2985,2986,2987) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1940 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1940; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1939 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (2921,2922,2923,2924,2925,2926,2927,2928,2929,2930,2931,2932,2933,2934,2935,2936,2937,2938,2939,2940,2941,2942,2943,2944,2945,2946,2947,2948,2949,2951,2952) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1939 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1939; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1938 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (55,2901,2902,2903,2904,2905,2906,2907,2908,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,4156) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1938 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1938; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1937 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (2662,2810,2811,2812,2813,2814,2815,2816,2817,2818,2819,2896,2897,2898,2899,2900,2901,2904,2906,2907,2908,2911,2912,2914,2915,2917,2927,2939,2947,2950,3296,3297,3298,3299,3300,3301,3302,3303,3304,3305,3306,3307,3308,3309,3310,3311,3312,3313,3314,3315,3316,3317,3318,3319,3320,3321,3322,3323,3324,3325,3326,3327,3328,3329,3330,3331,3332,3333,3334,3335,3336,3337) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1937 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1937; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1935 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (876,2814,2817,2820,2821,2822,2823,2824,2825,2826,2827,2828,2829,2899,2947,3307,3314,3328) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1935 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1935; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1934 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (2830,2831,2832,2833,2834,2835) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1934 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1934; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1933 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (2836,2837,2838,2839,2840,2841,2842,2843,2844,2845,2846) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1933 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1933; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1932 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (61,94,2208,2727,2847,2848,2849,2850,2851,2852,2853,2854,2855,2856,2857,2858,2859,2861,3195,3196,3197,3199,3202,3203,3204,3205,3206,3207,3209,3210,3211,3213,4278) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1932 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1932; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1931 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (21,30,61,872,2074,2193,2195,2197,2203,2205,2206,2207,2208,2209,2679,2681,2683,2685,2693,2699,2703,2714,2723,2737,2751,2860,2861,2862,2866,2867,3198,3212,4279) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1931 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1931; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1930 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (2680,2682,2687,2691,2700,2701,2715,2718,2721,2724,2725,2729,2731,2732,2733,2744,2745,2751,2755,2759,2768,2773,2774,2863,2864,2865,2866,2868,2869,2870,2871,3200,3208,3231,4280) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1930 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1930; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1929 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (969,2461,2622,2623,2624,2625,2626,2627,2628,2629,2630,2631,2632,2633,2680,2682,2684,2690,2691,2696,2705,2707,2718,2719,2724,2727,2731,2743,2744,2751,2753,2757,2759,2761,2872,2873,2874,2875,2876,2877,2878,2879) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1929 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1929; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1928 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (115,1035,2684,2686,2689,2692,2694,2698,2701,2705,2707,2711,2712,2713,2738,2746,2752,2753,2754,2767,2775,2776,2777,2778,2780,2784,2881,2882,2883,2884) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1928 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1928; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1927 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (115,2645,2647,2686,2688,2695,2698,2702,2713,2728,2730,2736,2739,2742,2779,2891,2892,2893,2894,2895) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1927 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1927; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1926 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (2645,2648,2649,2650,2651,2704,2706,2709,2710,2726,2750,2756,2760,2763,2779,2781,2782,2880,2885,2886,2887,2888,2889,2890,3234) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1926 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1926; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1925 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (2393,2634,2635,2636,2637,2638,2639,2640,2641,2642,2643,2644,2646,2647,2652,2735,2750,3232,3235) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1925 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1925; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1924 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (2637,2646,2652,2697,2740,2747,2762,2764,2769,2770,2783,2785,2786,2787,3230) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1924 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1924; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1923 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (2716,2717,2720,2722,2734,2741,2749,2758,2765,2766,2769,2771,3237) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1923 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1923; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1922 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (2708,2716,2720,2734,2740,2765,2788,3238) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1922 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1922; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1921 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (1532,2741,3240,3241) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1921 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1921; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1920 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (1532,3236,3242,3243) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1920 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1920; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1914 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (3502) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1914 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1914; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1913 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (3222) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1913 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1913; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1912 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (1653,2058,3491,3492,3493,3494,3495,3496,3497,3498,3499,3500,3501) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1912 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1912; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1909 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (18) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1909 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1909; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1908 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (1664) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1908 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1908; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1907 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (110) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1907 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1907; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1906 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (2263) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1906 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1906; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1905 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (1845) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1905 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1905; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1903 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (9) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1903 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1903; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1902 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (107,2035,2039,3478,3479,3480,3481,3482,3483,3484,3485,3486,3487,3488) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1902 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1902; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1901 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (2024,2031,3473,3474,3475,3476) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1901 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1901; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1900 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (2026,3469,3470,3471,3472,3490) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1900 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1900; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1899 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (3464,3465,3466,3467) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1899 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1899; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1898 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (3461,3462,3463) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1898 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1898; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1897 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (48,1652,3270,3449,3450,3451,3452,3453,3454,3455,3456,3457,3458,3459) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1897 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1897; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1896 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (869,3341,3413,3440,3441,3442,3443,3444,3445) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1896 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1896; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1895 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (3437,3438,3439) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1895 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1895; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1894 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (3429,3430,3431,3432,3433,3434) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1894 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1894; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1893 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (3426,3447,3448) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1893 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1893; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1892 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (23,871,3414,3415,3416,3417,3418) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1892 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1892; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1891 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (3423,3424) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1891 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1891; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1880 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (4268) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1880 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1880; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1872 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (108) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1872 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1872; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1863 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (4359) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1863 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1863; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1860 AND type <> 't' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (4270) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1860 AND type = 't' AND 0 >= rights ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1860; result: OK
getRow(): SELECT id FROM uri where uri='/names/?form=3'; result: OK
getDateCounter(): SELECT COUNT(*) from user where creation_time > '1696280933'; result: OK
error log
addUser(): Error executing query INSERT INTO vkSources VALUES (2850990, 1696367331, 0) ON DUPLICATE KEY UPDATE lastRead=1696367331; Column count doesn't match value count at row 1
addUser(): Error executing query INSERT INTO vkSources VALUES (2850990, 1696367331, 0) ON DUPLICATE KEY UPDATE lastRead=1696367331; Column count doesn't match value count at row 1