SELECT version() AS version
SELECT routine_schema from INFORMATION_SCHEMA.routines where routine_name = 'wfwl_inet_pton'
SELECT count(*) FROM webfwlog.services LIMIT 1
SHOW COLUMNS FROM webfwlog.hostnames LIKE 'ip_addr';
SELECT oob_family FROM ulogd.ulog LIMIT 1;
SELECT ip_saddr_bin FROM ulogd.ulog LIMIT 1;
SHOW COLUMNS FROM ulogd.ulog LIKE 'ip_saddr_bin';
SHOW COLUMNS FROM ulogd.ulog LIKE 'icmp_gateway';
SELECT local_time FROM ulogd.ulog LIMIT 1
SELECT oob_family FROM ulogd.ulog LIMIT 1
SELECT _id FROM ulogd.ulog LIMIT 1
SELECT mac_str FROM ulogd.ulog LIMIT 1
SELECT last_saved, last_accessed FROM webfwlog.reports
SELECT count(*) FROM webfwlog.reports
SELECT * FROM webfwlog.reports WHERE code<>'default' ORDER BY last_accessed DESC
SHOW TABLES FROM ulogd
SHOW COLUMNS FROM ulogd._extensions;
SHOW COLUMNS FROM ulogd.conntrack;
SHOW COLUMNS FROM ulogd.hwhdr;
SHOW COLUMNS FROM ulogd.icmp;
SHOW COLUMNS FROM ulogd.icmpv6;
SHOW COLUMNS FROM ulogd.ip_proto;
SHOW COLUMNS FROM ulogd.mac;
SHOW COLUMNS FROM ulogd.nufw;
SHOW COLUMNS FROM ulogd.nulog;
SHOW COLUMNS FROM ulogd.sctp;
SHOW COLUMNS FROM ulogd.state_t;
SHOW COLUMNS FROM ulogd.tcp;
SHOW COLUMNS FROM ulogd.temp;
SHOW COLUMNS FROM ulogd.udp;
SHOW COLUMNS FROM ulogd.ulog;
SHOW COLUMNS FROM ulogd.ulog2;
SHOW COLUMNS FROM ulogd.ulog2_ct;
SHOW COLUMNS FROM ulogd.ulog_200410;
SHOW COLUMNS FROM ulogd.ulog_200411;
SHOW COLUMNS FROM ulogd.ulog_200412;
SHOW COLUMNS FROM ulogd.ulog_200501;
SHOW COLUMNS FROM ulogd.ulog_200502;
SHOW COLUMNS FROM ulogd.ulog_200503;
SHOW COLUMNS FROM ulogd.ulog_200504;
SHOW COLUMNS FROM ulogd.ulog_200505;
SHOW COLUMNS FROM ulogd.ulog_200506;
SHOW COLUMNS FROM ulogd.ulog_200507;
SHOW COLUMNS FROM ulogd.ulog_200508;
SHOW COLUMNS FROM ulogd.ulog_200509;
SHOW COLUMNS FROM ulogd.ulog_200510;
SHOW COLUMNS FROM ulogd.ulog_200511;
SHOW COLUMNS FROM ulogd.ulog_200512;
SHOW COLUMNS FROM ulogd.ulog_200601;
SHOW COLUMNS FROM ulogd.ulog_200602;
SHOW COLUMNS FROM ulogd.ulog_200603;
SHOW COLUMNS FROM ulogd.ulog_200604;
SHOW COLUMNS FROM ulogd.ulog_200605;
SHOW COLUMNS FROM ulogd.ulog_200606;
SHOW COLUMNS FROM ulogd.ulog_200607;
SHOW COLUMNS FROM ulogd.ulog_200608;
SHOW COLUMNS FROM ulogd.ulog_200609;
SHOW COLUMNS FROM ulogd.ulog_200610;
SHOW COLUMNS FROM ulogd.ulog_200611;
SHOW COLUMNS FROM ulogd.ulog_200612;
SHOW COLUMNS FROM ulogd.ulog_200701;
SHOW COLUMNS FROM ulogd.ulog_200702;
SHOW COLUMNS FROM ulogd.ulog_200703;
SHOW COLUMNS FROM ulogd.ulog_200704;
SHOW COLUMNS FROM ulogd.ulog_200705;
SHOW COLUMNS FROM ulogd.ulog_200706;
SHOW COLUMNS FROM ulogd.ulog_200707;
SHOW COLUMNS FROM ulogd.ulog_200708;
SHOW COLUMNS FROM ulogd.ulog_200709;
SHOW COLUMNS FROM ulogd.ulog_200710;
SHOW COLUMNS FROM ulogd.ulog_200711;
SHOW COLUMNS FROM ulogd.ulog_200712;
SHOW COLUMNS FROM ulogd.ulog_200801;
SHOW COLUMNS FROM ulogd.ulog_200802;
SHOW COLUMNS FROM ulogd.ulog_200803;
SHOW COLUMNS FROM ulogd.ulog_200804;
SHOW COLUMNS FROM ulogd.ulog_200805;
SHOW COLUMNS FROM ulogd.ulog_200806;
SHOW COLUMNS FROM ulogd.ulog_200807;
SHOW COLUMNS FROM ulogd.ulog_200808;
SHOW COLUMNS FROM ulogd.ulog_200809;
SHOW COLUMNS FROM ulogd.ulog_200810;
SHOW COLUMNS FROM ulogd.ulog_200811;
SHOW COLUMNS FROM ulogd.ulog_200812;
SHOW COLUMNS FROM ulogd.ulog_200901;
SHOW COLUMNS FROM ulogd.ulog_200902;
SHOW COLUMNS FROM ulogd.ulog_200903;
SHOW COLUMNS FROM ulogd.ulog_200904;
SHOW COLUMNS FROM ulogd.ulog_200905;
SHOW COLUMNS FROM ulogd.ulog_200906;
SHOW COLUMNS FROM ulogd.ulog_200907;
SHOW COLUMNS FROM ulogd.ulog_200908;
SHOW COLUMNS FROM ulogd.ulog_200909;
SHOW COLUMNS FROM ulogd.ulog_200910;
SHOW COLUMNS FROM ulogd.ulog_200911;
SHOW COLUMNS FROM ulogd.ulog_200912;
SHOW COLUMNS FROM ulogd.ulog_201001;
SHOW COLUMNS FROM ulogd.ulog_201002;
SHOW COLUMNS FROM ulogd.ulog_201003;
SHOW COLUMNS FROM ulogd.ulog_201004;
SHOW COLUMNS FROM ulogd.ulog_201005;
SHOW COLUMNS FROM ulogd.ulog_201006;
SHOW COLUMNS FROM ulogd.ulog_201007;
SHOW COLUMNS FROM ulogd.ulog_201008;
SHOW COLUMNS FROM ulogd.ulog_201009;
SHOW COLUMNS FROM ulogd.ulog_201010;
SHOW COLUMNS FROM ulogd.ulog_201011;
SHOW COLUMNS FROM ulogd.ulog_201012;
SHOW COLUMNS FROM ulogd.ulog_201101;
SHOW COLUMNS FROM ulogd.ulog_201102;
SHOW COLUMNS FROM ulogd.ulog_201103;
SHOW COLUMNS FROM ulogd.ulog_201104;
SHOW COLUMNS FROM ulogd.ulog_201105;
SHOW COLUMNS FROM ulogd.ulog_201106;
SHOW COLUMNS FROM ulogd.ulog_201107;
SHOW COLUMNS FROM ulogd.ulog_201108;
SHOW COLUMNS FROM ulogd.ulog_201109;
SHOW COLUMNS FROM ulogd.ulog_201110;
SHOW COLUMNS FROM ulogd.ulog_201111;
SHOW COLUMNS FROM ulogd.ulog_201112;
SHOW COLUMNS FROM ulogd.ulog_201201;
SHOW COLUMNS FROM ulogd.ulog_201202;
SHOW COLUMNS FROM ulogd.ulog_201203;
SHOW COLUMNS FROM ulogd.ulog_201204;
SHOW COLUMNS FROM ulogd.ulog_201205;
SHOW COLUMNS FROM ulogd.ulog_201206;
SHOW COLUMNS FROM ulogd.ulog_201207;
SHOW COLUMNS FROM ulogd.ulog_201208;
SHOW COLUMNS FROM ulogd.ulog_201209;
SHOW COLUMNS FROM ulogd.ulog_201210;
SHOW COLUMNS FROM ulogd.ulog_201211;
SHOW COLUMNS FROM ulogd.ulog_201212;
SHOW COLUMNS FROM ulogd.ulog_201301;
SHOW COLUMNS FROM ulogd.ulog_201302;
SHOW COLUMNS FROM ulogd.ulog_201303;
SHOW COLUMNS FROM ulogd.ulog_201304;
SHOW COLUMNS FROM ulogd.ulog_201305;
SHOW COLUMNS FROM ulogd.ulog_201306;
SHOW COLUMNS FROM ulogd.ulog_201307;
SHOW COLUMNS FROM ulogd.ulog_201308;
SHOW COLUMNS FROM ulogd.ulog_201309;
SHOW COLUMNS FROM ulogd.ulog_201310;
SHOW COLUMNS FROM ulogd.ulog_201311;
SHOW COLUMNS FROM ulogd.ulog_201312;
SHOW COLUMNS FROM ulogd.ulog_201401;
SHOW COLUMNS FROM ulogd.ulog_201402;
SHOW COLUMNS FROM ulogd.ulog_201403;
SHOW COLUMNS FROM ulogd.ulog_201404;
SHOW COLUMNS FROM ulogd.ulog_201405;
SHOW COLUMNS FROM ulogd.ulog_201406;
SHOW COLUMNS FROM ulogd.ulog_201407;
SHOW COLUMNS FROM ulogd.ulog_201408;
SHOW COLUMNS FROM ulogd.ulog_201409;
SHOW COLUMNS FROM ulogd.ulog_201410;
SHOW COLUMNS FROM ulogd.ulog_201411;
SHOW COLUMNS FROM ulogd.ulog_201412;
SHOW COLUMNS FROM ulogd.ulog_201501;
SHOW COLUMNS FROM ulogd.ulog_201502;
SHOW COLUMNS FROM ulogd.ulog_201503;
SHOW COLUMNS FROM ulogd.ulog_201504;
SHOW COLUMNS FROM ulogd.ulog_201505;
SHOW COLUMNS FROM ulogd.ulog_201506;
SHOW COLUMNS FROM ulogd.ulog_201507;
SHOW COLUMNS FROM ulogd.ulog_201508;
SHOW COLUMNS FROM ulogd.ulog_201509;
SHOW COLUMNS FROM ulogd.ulog_201510;
SHOW COLUMNS FROM ulogd.ulog_201511;
SHOW COLUMNS FROM ulogd.ulog_201512;
SHOW COLUMNS FROM ulogd.ulog_201601;
SHOW COLUMNS FROM ulogd.ulog_201602;
SHOW COLUMNS FROM ulogd.ulog_201603;
SHOW COLUMNS FROM ulogd.ulog_201604;
SHOW COLUMNS FROM ulogd.ulog_201605;
SHOW COLUMNS FROM ulogd.ulog_201606;
SHOW COLUMNS FROM ulogd.ulog_201607;
SHOW COLUMNS FROM ulogd.ulog_201608;
SHOW COLUMNS FROM ulogd.ulog_201609;
SHOW COLUMNS FROM ulogd.ulog_201610;
SHOW COLUMNS FROM ulogd.ulog_201611;
SHOW COLUMNS FROM ulogd.ulog_201612;
SHOW COLUMNS FROM ulogd.ulog_201701;
SHOW COLUMNS FROM ulogd.ulog_201702;
SHOW COLUMNS FROM ulogd.ulog_201703;
SHOW COLUMNS FROM ulogd.ulog_201704;
SHOW COLUMNS FROM ulogd.ulog_201705;
SHOW COLUMNS FROM ulogd.ulog_201706;
SHOW COLUMNS FROM ulogd.ulog_201707;
SHOW COLUMNS FROM ulogd.ulog_201708;
SHOW COLUMNS FROM ulogd.ulog_201709;
SHOW COLUMNS FROM ulogd.ulog_201710;
SHOW COLUMNS FROM ulogd.ulog_201711;
SHOW COLUMNS FROM ulogd.ulog_201712;
SHOW COLUMNS FROM ulogd.ulog_201801;
SHOW COLUMNS FROM ulogd.ulog_201802;
SHOW COLUMNS FROM ulogd.ulog_201803;
SHOW COLUMNS FROM ulogd.ulog_201804;
SHOW COLUMNS FROM ulogd.ulog_201805;
SHOW COLUMNS FROM ulogd.ulog_201806;
SHOW COLUMNS FROM ulogd.ulog_201807;
SHOW COLUMNS FROM ulogd.ulog_201808;
SHOW COLUMNS FROM ulogd.ulog_201809;
SHOW COLUMNS FROM ulogd.ulog_201810;
SHOW COLUMNS FROM ulogd.ulog_201811;
SHOW COLUMNS FROM ulogd.ulog_201812;
SHOW COLUMNS FROM ulogd.ulog_201901;
SHOW COLUMNS FROM ulogd.ulog_201902;
SHOW COLUMNS FROM ulogd.ulog_201903;
SHOW COLUMNS FROM ulogd.ulog_201904;
SHOW COLUMNS FROM ulogd.ulog_201905;
SHOW COLUMNS FROM ulogd.ulog_201906;
SHOW COLUMNS FROM ulogd.ulog_201907;
SHOW COLUMNS FROM ulogd.ulog_201908;
SHOW COLUMNS FROM ulogd.ulog_201909;
SHOW COLUMNS FROM ulogd.ulog_201910;
SHOW COLUMNS FROM ulogd.ulog_201911;
SHOW COLUMNS FROM ulogd.ulog_201912;
SHOW COLUMNS FROM ulogd.ulog_202001;
SHOW COLUMNS FROM ulogd.ulog_202002;
SHOW COLUMNS FROM ulogd.ulog_202003;
SHOW COLUMNS FROM ulogd.ulog_202004;
SHOW COLUMNS FROM ulogd.ulog_202005;
SHOW COLUMNS FROM ulogd.ulog_202006;
SHOW COLUMNS FROM ulogd.ulog_202007;
SHOW COLUMNS FROM ulogd.ulog_202008;
SHOW COLUMNS FROM ulogd.ulog_202009;
SHOW COLUMNS FROM ulogd.ulog_202010;
SHOW COLUMNS FROM ulogd.ulog_202011;
SHOW COLUMNS FROM ulogd.ulog_202012;
SHOW COLUMNS FROM ulogd.ulog_202101;
SHOW COLUMNS FROM ulogd.ulog_202102;
SHOW COLUMNS FROM ulogd.ulog_202103;
SHOW COLUMNS FROM ulogd.ulog_202104;
SHOW COLUMNS FROM ulogd.ulog_202105;
SHOW COLUMNS FROM ulogd.ulog_202106;
SHOW COLUMNS FROM ulogd.ulog_202107;
SHOW COLUMNS FROM ulogd.ulog_202108;
SHOW COLUMNS FROM ulogd.ulog_202109;
SHOW COLUMNS FROM ulogd.ulog_202110;
SHOW COLUMNS FROM ulogd.ulog_202111;
SHOW COLUMNS FROM ulogd.ulog_202112;
SHOW COLUMNS FROM ulogd.ulog_202201;
SHOW COLUMNS FROM ulogd.ulog_202202;
SHOW COLUMNS FROM ulogd.ulog_202203;
SHOW COLUMNS FROM ulogd.ulog_202204;
SHOW COLUMNS FROM ulogd.ulog_202205;
SHOW COLUMNS FROM ulogd.ulog_202206;
SHOW COLUMNS FROM ulogd.ulog_202207;
SHOW COLUMNS FROM ulogd.ulog_202208;
SHOW COLUMNS FROM ulogd.ulog_202209;
SHOW COLUMNS FROM ulogd.ulog_202210;
SHOW COLUMNS FROM ulogd.ulog_202211;
SHOW COLUMNS FROM ulogd.ulog_202212;
SHOW COLUMNS FROM ulogd.ulog_202301;
SHOW COLUMNS FROM ulogd.ulog_202302;
SHOW COLUMNS FROM ulogd.ulog_202303;
SHOW COLUMNS FROM ulogd.ulog_202304;
SHOW COLUMNS FROM ulogd.ulog_202305;
SHOW COLUMNS FROM ulogd.ulog_202306;
SHOW COLUMNS FROM ulogd.ulog_202307;
SHOW COLUMNS FROM ulogd.ulog_202308;
SHOW COLUMNS FROM ulogd.ulog_202309;
SHOW COLUMNS FROM ulogd.ulog_202310;
SHOW COLUMNS FROM ulogd.ulog_202311;
SHOW COLUMNS FROM ulogd.ulog_202312;
SHOW COLUMNS FROM ulogd.ulog_202401;
SHOW COLUMNS FROM ulogd.ulog_202402;
SHOW COLUMNS FROM ulogd.ulog_202403;
SHOW COLUMNS FROM ulogd.ulog_202404;
SHOW COLUMNS FROM ulogd.ulog_202405;
SHOW COLUMNS FROM ulogd.ulog_202406;
SHOW COLUMNS FROM ulogd.ulog_202407;
SHOW COLUMNS FROM ulogd.ulog_202408;
SHOW COLUMNS FROM ulogd.ulog_202409;
SHOW COLUMNS FROM ulogd.ulog_202410;
SHOW COLUMNS FROM ulogd.ulog_202411;
SHOW COLUMNS FROM ulogd.ulog_202412;
SHOW COLUMNS FROM ulogd.ulog_202501;
SHOW COLUMNS FROM ulogd.ulog_202502;
SHOW COLUMNS FROM ulogd.ulog_202503;
SHOW COLUMNS FROM ulogd.ulog_202504;
SHOW COLUMNS FROM ulogd.ulog_202505;
SHOW COLUMNS FROM ulogd.ulog_202506;
SHOW COLUMNS FROM ulogd.ulog_202507;
SHOW COLUMNS FROM ulogd.ulog_202508;
SHOW COLUMNS FROM ulogd.ulog_202509;
SHOW COLUMNS FROM ulogd.ulog_202510;
SHOW COLUMNS FROM ulogd.ulog_202511;
SHOW COLUMNS FROM ulogd.ulog_202512;
SHOW COLUMNS FROM ulogd.ulog_202601;
SHOW COLUMNS FROM ulogd.ulog_202602;
SHOW COLUMNS FROM ulogd.ulog_202603;
SHOW COLUMNS FROM ulogd.ulog_202604;
SHOW COLUMNS FROM ulogd.ulog_202605;
SHOW COLUMNS FROM ulogd.ulog_text;
SHOW COLUMNS FROM ulogd.view_icmp;
SHOW COLUMNS FROM ulogd.view_icmpv6;
SHOW COLUMNS FROM ulogd.view_nufw;
SHOW COLUMNS FROM ulogd.view_tcp;
SHOW COLUMNS FROM ulogd.view_tcp_quad;
SHOW COLUMNS FROM ulogd.view_udp;
SHOW COLUMNS FROM ulogd.view_udp_quad;