vm_cust38
25<br><table><tr>\n
                            <td>0</td>\n
                            <td>SET SESSION sql_mode=''</td>\n
                          </tr>\n<tr>\n
                            <td>1</td>\n
                            <td>SELECT eventdb_date_start AS date_start,
                           eventdb_date_stop AS date_stop
                        FROM vm_1_eventdb
                        LEFT JOIN vm_1_eventdbincat
                            ON (eventdbincat_eventdbID=eventdbID)
                        WHERE eventdbincat_eventdbcatvalueID IN (6,5,3,1,4)
                        ORDER BY date_start ASC
                        LIMIT 0,1</td>\n
                          </tr>\n<tr>\n
                            <td>2</td>\n
                            <td>SELECT eventdb_date_start AS date_start,
                           eventdb_date_stop AS date_stop
                        FROM vm_1_eventdb
                        LEFT JOIN vm_1_eventdbincat
                            ON (eventdbincat_eventdbID=eventdbID)
                        WHERE eventdbincat_eventdbcatvalueID IN (6,5,3,1,4)
                        ORDER BY date_start DESC
                        LIMIT 0,1</td>\n
                          </tr>\n<tr>\n
                            <td>3</td>\n
                            <td>SELECT eventdbcatID                                AS CATID,
                               eventdbcat_name                         AS CAT_NAME,
                               eventdbcatvalueID      AS ELEMENTID,
                               eventdbcatvalue_name                   AS ELEMENT_NAME,
                               eventdbcatvalue_url                    AS ELEMENT_URL,
                               eventdbcatvalue_color                  AS ELEMENT_COLOR
                            FROM vm_1_eventdbcatvalue
                            LEFT JOIN vm_1_eventdbcat
                                ON (eventdbcatID = eventdbcatvalue_eventdbcatID)
                            WHERE   eventdbcatvalueID IN (6,5,3,1,4)
                            ORDER BY eventdbcat_name,
                                     eventdbcatvalue_name</td>\n
                          </tr>\n<tr>\n
                            <td>4</td>\n
                            <td>SELECT * FROM vm_1_eventdb
                            LEFT JOIN vm_1_eventdbincat
                                ON (eventdbincat_eventdbID=eventdbID)
                            WHERE   
                                    
                                    eventdbincat_eventdbcatvalueID IN (1) AND (
                                           (
                                            eventdb_date_start < 1716415200 AND
                                            eventdb_date_stop < 1716415200
                                           )
                                      )
                                      GROUP BY eventdbID</td>\n
                          </tr>\n<tr>\n
                            <td>5</td>\n
                            <td>SELECT CEILING(COUNT(eventdbID) /10) AS PAGES,
                                            COUNT(eventdbID) AS MAX_DISPLAY FROM vm_1_eventdb
                                           WHERE    
                                                    eventdbID IN (141,143,146,147,148,149,150,153,154,156,159,160,161,162,163,164,165,172,174,178,180,182,184,186,187,189,190,191,192,193,194,195,196,197,198,200,201,203,205,206,208,209,214,216,221,224,225,226,227,231,232,234,235,236,237,239,240,242,244,250,252,253,254,255,256,259,260,262,263,265,270,271,276,277,279,285,287,288,289,290,293,294,295,296,297,301,303,305,306,309,310,313,315,318,319,320,321,322,323,327,328,329,331,332,333,334,336,340,341,342,346,349,350,353,355,356,358,359,360,361,365,367,368,371,374,375,377,379,380,382,383,384,385,386,387,389,391,393,394,395,396,397,398,400,401,402,403,405,406,407,409,411,413,417,418,420,423,426,427,429,430,435,436,437,439,443,446,447,448,450,451,453,454,455,456,459,463,464,465,467,471,472,473,474,475,478,480,481,482,483,484,485,486,487,488,489,490,494,495,496,497,498,500,501,502,505,509,511,512,515,516,518,520,521,522,526,527,528,529,530,533,534,535,536,537,539,540,551,552,556,559,561,562,563,564,565,569,570,574,575,577,578,579,580,581,583,586,588,590,592,593,595,596,597,598,599,600,601,603,604,605,607,608,609,611,615,616,617,619,620,622,625,627,628,632,634,635,636,638,640,641,644,648,649,651,653,654,655,656,659,660,661,662,663,664,666,667,671,672,676,677,678,680,681,682,683,684,685,690,693,694,695,697,699,700,702,704,706,707,708,715,716,717,723,724,725,729,730,731,732,733,734,735,736,737,738,739,742,743,744,745,748,749,750,752,755,756,757,758,761,763,765,766,767,769,770,774,775,778,781,783,785,787,789,793,797,800,801,802,804,809,810,812,814,815,816,818,821,822,823,827,828,830,833,834,836,837,838,840,843,844,846,847,849,851,852,853,857,859,861,876,877,878,879,880,881,883,885,887,888,889,890,892,893,894,897,898,899,900,902,903,907,908,909,912,914,916,917,918,919,921,922,923,924,925,927,930,931,932,933,934,935,936,938,939,940,941,943,944,945,947,948,950,951,952,953,954,959,961,966,968,969,970,971,972,973,976,978,982,987,989,990,991,994,995,999,1000,1001,1002,1003,1005,1008,1009,1010,1011,1012,1017,1025,1027,1028,1030,1032,1037,1038,1039,1042,1045,1046,1049,1050,1051,1052,1053,1056,1057,1058,1059,1061,1062,1064,1065,1066,1067,1069,1070,1071,1075,1076,1080,1081,1082,1083,1084,1085,1086,1088,1089,1090,1091,1092,1094,1095,1096,1102,1104,1105,1106,1108,1110,1111,1113,1115,1117,1118,1120,1121,1122,1124,1125,1126,1128,1129,1130,1131,1132,1134,1135,1138,1139,1142,1145,1146,1148,1150,1153,1154,1155,1156,1157,1162,1164,1165,1167,1168,1174,1176,1178,1184,1185,1187,1188,1190,1191,1192,1194,1196,1197,1202,1203,1210,1211,1212,1213,1214,1215,1216,1217,1221,1224,1225,1228,1229,1230,1232,1233,1234,1235,1236,1237,1238,1239,1240,1241,1243,1244,1245,1246,1247,1250,1252,1254,1256,1257,1261,1266,1270,1274,1275,1277,1278,1283,1284,1286,1287,1290,1293,1294,1295,1298,1301,1302,1303,1304,1305,1307,1309,1312,1315,1317,1318,1319,1320,1321,1323,1324,1325,1327,1328,1335,1337,1340,1341,1343,1345,1346,1347,1353,1355,1356,1357,1358,1359,1361,1362,1363,1364,1365,1366,1367,1368,1369,1370,1371,1372,1374,1375,1380,1381,1382,1386,1387,1396,1397,1398,1400,1401,1402,1404,1406,1407,1417,1418,1422,1427,1428,1429,1435,1436,1438,1440,1444,1447,1449,1450,1451,1452,1453,1454,1455,1461,1463,1464,1466,1468,1469,1470,1471,1475,1478,1479,1483,1484,1485,1486,1488,1490,1491,1492,1494,1495,1497,1499,1501,1502,1505,1507,1508,1509,1513,1514,1515,1521,1522,1523,1524,1525,1527,1528,1529,1530,1531,1532,1533,1534,1536,1538,1540,1543,1544,1546,1551,1552,1554,1556,1557,1560,1562,1564,1565,1568,1571,1574,1576,1577,1580,1605,1608,1619,1620,1621,1623,1625,1627,1628,1629,1631,1632,1634,1639,1640,1643,1644,1646,1647,1650,1651,1652,1653,1660,1663,1664,1666,1668,1669,1673,1674,1675,1676,1677,1680,1682,1687,1688,1689,1690,1691,1693,1694,1695,1696,1698,1700,1701,1702,1703,1704,1705,1706,1707,1708,1711,1712,1714,1716,1719,1720,1721,1724,1725,1726,1727,1728,1729,1731,1733,1735,1736,1740,1742,1743,1744,1746,1753,1755,1758,1761,1762,1764,1765,1766,1778,1779,1780,1781,1792,1794,1797,1799,1800,1804,1806,1808,1809,1810,1812,1814,1817,1818,1819,1821,1823,1825,1826,1827,1828,1829,1831,1832,1833,1834,1835,1836,1838,1839,1842,1843,1844,1849,1853,1855,1857,1860,1861,1862,1864,1865,1866,1870,1871,1873,1876,1877,1878,1880,1881,1884,1888,1889,1894,1895,1897,1898,1905,1907,1909,1910,1911,1924,1925,1926,1927,1928,1929,1931,1932,1934,1935,1936,1937,1939,1940,1941,1942,1943,1944,1945,1948,1949,1950,1951,1959,1961,1962,1966,1967,1968,1971,1972,1973,1974,1975,1977,1982,1983,1985,1986,1987,1990,1991,1992,1993,1994,1998,1999,2000,2001,2003,2005,2008,2009,2010,2011,2012,2013,2018,2019,2020,2022,2024,2025,2034,2035,2038,2039,2040,2041,2043,2044,2045,2050,2052,2053,2054,2057,2058,2059,2060,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071,2072,2073,2075,2076,2077,2080,2083,2084,2085,2086,2087,2088,2090,2091,2092,2093,2094,2105,2108,2109,2111,2112,2113,2114,2115,2116,2117,2118,2122,2126,2128,2131,2132,2134,2136,2137,2139,2140,2149,2150,2157,2161,2162,2177,2179,2181,2185,2186,2187,2188,2189,2190,2191,2192,2193,2194,2195,2196,2197,2198,2199,2202,2203,2204,2205,2206,2207,2208,2209,2210,2211,2212,2219,2220,2221,2222,2223,2224,2225,2226,2227,2228,2229,2230,2232,2233,2234,2235,2236,2237,2238,2241,2244,2245,2246,2247,2248,2249,2250,2252,2253,2254,2255,2256,2257,2268,2269,2270,2272,2273,2274,2275,2276,2277,2278,2279,2281,2282,2283,2285,2288,2289,2291,2292,2293,2294,2298,2300,2302,2304,2309,2310,2311,2314,2315,2316,2320,2321,2322,2323,2325,2326,2327,2328,2329,2330,2331,2332,2333,2334,2336,2339,2340,2341,2342,2345,2347,2348,2349,2350,2352,2354,2356,2357,2358,2360,2363,2364,2365,2366,2367,2368,2369,2371,2372,2373,2374,2375,2377,2381,2384,2393,2404,2406,2424,2425,2427,2443,2444,2445,2446,2468)</td>\n
                          </tr>\n<tr>\n
                            <td>6</td>\n
                            <td>SELECT * FROM vm_1_eventdb
                            LEFT JOIN vm_1_eventdbincat
                                ON (eventdbincat_eventdbID=eventdbID)
                            WHERE   
                                    
                                    eventdbincat_eventdbcatvalueID IN (1) AND (
                                           (
                                            eventdb_date_start < 1716415200 AND
                                            eventdb_date_stop < 1716415200
                                           )
                                      )
                                      GROUP BY eventdbID
                                    ORDER BY eventdb_date_start DESC, eventdbID DESC
                                    LIMIT 1010, 10</td>\n
                          </tr>\n<tr>\n
                            <td>7</td>\n
                            <td>SELECT eventdbincat_eventdbcatvalueID AS ELEMENTID
                                                FROM vm_1_eventdbincat
                                                WHERE eventdbincat_eventdbcatvalueID IN (1) AND
                                                      eventdbincat_eventdbID                                        = 296</td>\n
                          </tr>\n<tr>\n
                            <td>8</td>\n
                            <td>SELECT eventdbincat_eventdbcatvalueID AS ELEMENTID
                                                FROM vm_1_eventdbincat
                                                WHERE eventdbincat_eventdbcatvalueID IN (1) AND
                                                      eventdbincat_eventdbID                                        = 285</td>\n
                          </tr>\n<tr>\n
                            <td>9</td>\n
                            <td>SELECT eventdbincat_eventdbcatvalueID AS ELEMENTID
                                                FROM vm_1_eventdbincat
                                                WHERE eventdbincat_eventdbcatvalueID IN (1) AND
                                                      eventdbincat_eventdbID                                        = 350</td>\n
                          </tr>\n<tr>\n
                            <td>10</td>\n
                            <td>SELECT eventdbincat_eventdbcatvalueID AS ELEMENTID
                                                FROM vm_1_eventdbincat
                                                WHERE eventdbincat_eventdbcatvalueID IN (1) AND
                                                      eventdbincat_eventdbID                                        = 295</td>\n
                          </tr>\n<tr>\n
                            <td>11</td>\n
                            <td>SELECT eventdbincat_eventdbcatvalueID AS ELEMENTID
                                                FROM vm_1_eventdbincat
                                                WHERE eventdbincat_eventdbcatvalueID IN (1) AND
                                                      eventdbincat_eventdbID                                        = 310</td>\n
                          </tr>\n<tr>\n
                            <td>12</td>\n
                            <td>SELECT eventdbincat_eventdbcatvalueID AS ELEMENTID
                                                FROM vm_1_eventdbincat
                                                WHERE eventdbincat_eventdbcatvalueID IN (1) AND
                                                      eventdbincat_eventdbID                                        = 294</td>\n
                          </tr>\n<tr>\n
                            <td>13</td>\n
                            <td>SELECT eventdbincat_eventdbcatvalueID AS ELEMENTID
                                                FROM vm_1_eventdbincat
                                                WHERE eventdbincat_eventdbcatvalueID IN (1) AND
                                                      eventdbincat_eventdbID                                        = 368</td>\n
                          </tr>\n<tr>\n
                            <td>14</td>\n
                            <td>SELECT eventdbincat_eventdbcatvalueID AS ELEMENTID
                                                FROM vm_1_eventdbincat
                                                WHERE eventdbincat_eventdbcatvalueID IN (1) AND
                                                      eventdbincat_eventdbID                                        = 367</td>\n
                          </tr>\n<tr>\n
                            <td>15</td>\n
                            <td>SELECT eventdbincat_eventdbcatvalueID AS ELEMENTID
                                                FROM vm_1_eventdbincat
                                                WHERE eventdbincat_eventdbcatvalueID IN (1) AND
                                                      eventdbincat_eventdbID                                        = 315</td>\n
                          </tr>\n<tr>\n
                            <td>16</td>\n
                            <td>SELECT eventdbincat_eventdbcatvalueID AS ELEMENTID
                                                FROM vm_1_eventdbincat
                                                WHERE eventdbincat_eventdbcatvalueID IN (1) AND
                                                      eventdbincat_eventdbID                                        = 271</td>\n
                          </tr>\n<tr>\n
                            <td>17</td>\n
                            <td>SELECT COUNT(picID) AS COUNTER
                                                FROM vm_1_eventdbpic
                                                WHERE pic_picfolderID = 153</td>\n
                          </tr>\n<tr>\n
                            <td>18</td>\n
                            <td>SELECT COUNT(docID) AS COUNTER
                                                FROM vm_1_eventdbdoc
                                                WHERE doc_docfolderID = 158</td>\n
                          </tr>\n<tr>\n
                            <td>19</td>\n
                            <td>SELECT COUNT(picID) AS COUNTER
                                                FROM vm_1_eventdbpic
                                                WHERE pic_picfolderID = 142</td>\n
                          </tr>\n<tr>\n
                            <td>20</td>\n
                            <td>SELECT COUNT(docID) AS COUNTER
                                                FROM vm_1_eventdbdoc
                                                WHERE doc_docfolderID = 157</td>\n
                          </tr>\n<tr>\n
                            <td>21</td>\n
                            <td>SELECT COUNT(picID) AS COUNTER
                                                FROM vm_1_eventdbpic
                                                WHERE pic_picfolderID = 207</td>\n
                          </tr>\n<tr>\n
                            <td>22</td>\n
                            <td>SELECT COUNT(docID) AS COUNTER
                                                FROM vm_1_eventdbdoc
                                                WHERE doc_docfolderID = 159</td>\n
                          </tr>\n<tr>\n
                            <td>23</td>\n
                            <td>SELECT COUNT(picID) AS COUNTER
                                                FROM vm_1_eventdbpic
                                                WHERE pic_picfolderID = 152</td>\n
                          </tr>\n<tr>\n
                            <td>24</td>\n
                            <td>SELECT COUNT(docID) AS COUNTER
                                                FROM vm_1_eventdbdoc
                                                WHERE doc_docfolderID = 161</td>\n
                          </tr>\n</table>