File: model.bin

package info (click to toggle)
sphinxsearch 2.2.11-8
links: PTS, VCS
area: main
in suites: bookworm, sid, trixie
size: 25,720 kB
sloc: cpp: 102,259; xml: 85,608; sh: 9,259; php: 3,790; ansic: 3,158; yacc: 1,969; java: 1,336; ruby: 1,289; python: 1,062; pascal: 912; perl: 381; lex: 275; makefile: 150; sql: 77; cs: 35
file content (1 line) | stat: -rw-r--r-- 37,887 bytes
parent folder | download | duplicates (3)
a:1:{i:0;a:145:{i:0;a:3:{s:8:"sphinxql";s:48:"select gr, count(*) cnt from dist_no group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"gr";s:1:"3";s:3:"cnt";s:1:"2";}i:1;a:2:{s:2:"gr";s:1:"2";s:3:"cnt";s:1:"1";}}}i:1;a:3:{s:8:"sphinxql";s:46:"select gr, count(*) cnt from dist0 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"gr";s:1:"3";s:3:"cnt";s:1:"2";}i:1;a:2:{s:2:"gr";s:1:"2";s:3:"cnt";s:1:"1";}}}i:2;a:3:{s:8:"sphinxql";s:46:"select gr, count(*) cnt from dist1 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"gr";s:1:"3";s:3:"cnt";s:1:"2";}i:1;a:2:{s:2:"gr";s:1:"2";s:3:"cnt";s:1:"1";}}}i:3;a:3:{s:8:"sphinxql";s:46:"select gr, count(*) cnt from dist2 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"gr";s:1:"3";s:3:"cnt";s:1:"2";}i:1;a:2:{s:2:"gr";s:1:"2";s:3:"cnt";s:1:"1";}}}i:4;a:3:{s:8:"sphinxql";s:46:"select gr, count(*) cnt from dist3 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"gr";s:1:"3";s:3:"cnt";s:1:"2";}i:1;a:2:{s:2:"gr";s:1:"2";s:3:"cnt";s:1:"1";}}}i:5;a:3:{s:8:"sphinxql";s:52:"select id idd, weight() cnt from dist_no group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:3:"idd";s:1:"1";s:3:"cnt";s:1:"1";}i:1;a:2:{s:3:"idd";s:1:"2";s:3:"cnt";s:1:"1";}}}i:6;a:3:{s:8:"sphinxql";s:50:"select id idd, weight() cnt from dist0 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:3:"idd";s:1:"1";s:3:"cnt";s:1:"1";}i:1;a:2:{s:3:"idd";s:1:"2";s:3:"cnt";s:1:"1";}}}i:7;a:3:{s:8:"sphinxql";s:50:"select id idd, weight() cnt from dist1 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:3:"idd";s:1:"1";s:3:"cnt";s:1:"1";}i:1;a:2:{s:3:"idd";s:1:"2";s:3:"cnt";s:1:"1";}}}i:8;a:3:{s:8:"sphinxql";s:50:"select id idd, weight() cnt from dist2 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:3:"idd";s:1:"1";s:3:"cnt";s:1:"1";}i:1;a:2:{s:3:"idd";s:1:"2";s:3:"cnt";s:1:"1";}}}i:9;a:3:{s:8:"sphinxql";s:50:"select id idd, weight() cnt from dist3 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:3:"idd";s:1:"1";s:3:"cnt";s:1:"1";}i:1;a:2:{s:3:"idd";s:1:"2";s:3:"cnt";s:1:"1";}}}i:10;a:3:{s:8:"sphinxql";s:69:"select count(*) cnt, count (distinct tag) tg from dist_no group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:3:"cnt";s:1:"2";s:2:"tg";s:1:"1";}i:1;a:2:{s:3:"cnt";s:1:"1";s:2:"tg";s:1:"1";}}}i:11;a:3:{s:8:"sphinxql";s:67:"select count(*) cnt, count (distinct tag) tg from dist0 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:3:"cnt";s:1:"2";s:2:"tg";s:1:"1";}i:1;a:2:{s:3:"cnt";s:1:"1";s:2:"tg";s:1:"1";}}}i:12;a:3:{s:8:"sphinxql";s:67:"select count(*) cnt, count (distinct tag) tg from dist1 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:3:"cnt";s:1:"2";s:2:"tg";s:1:"1";}i:1;a:2:{s:3:"cnt";s:1:"1";s:2:"tg";s:1:"1";}}}i:13;a:3:{s:8:"sphinxql";s:67:"select count(*) cnt, count (distinct tag) tg from dist2 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:3:"cnt";s:1:"2";s:2:"tg";s:1:"1";}i:1;a:2:{s:3:"cnt";s:1:"1";s:2:"tg";s:1:"1";}}}i:14;a:3:{s:8:"sphinxql";s:67:"select count(*) cnt, count (distinct tag) tg from dist3 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:3:"cnt";s:1:"2";s:2:"tg";s:1:"1";}i:1;a:2:{s:3:"cnt";s:1:"1";s:2:"tg";s:1:"1";}}}i:15;a:3:{s:8:"sphinxql";s:48:"select id, tag from dist_no where match ('test')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"tag";s:1:"2";}i:1;a:2:{s:2:"id";s:1:"2";s:3:"tag";s:1:"2";}i:2;a:2:{s:2:"id";s:1:"3";s:3:"tag";s:1:"2";}}}i:16;a:3:{s:8:"sphinxql";s:46:"select id, tag from dist0 where match ('test')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"tag";s:1:"2";}i:1;a:2:{s:2:"id";s:1:"2";s:3:"tag";s:1:"2";}i:2;a:2:{s:2:"id";s:1:"3";s:3:"tag";s:1:"2";}}}i:17;a:3:{s:8:"sphinxql";s:46:"select id, tag from dist1 where match ('test')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"3";s:3:"tag";s:1:"2";}i:1;a:2:{s:2:"id";s:1:"1";s:3:"tag";s:1:"2";}i:2;a:2:{s:2:"id";s:1:"2";s:3:"tag";s:1:"2";}}}i:18;a:3:{s:8:"sphinxql";s:46:"select id, tag from dist2 where match ('test')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"3";s:3:"tag";s:1:"2";}i:1;a:2:{s:2:"id";s:1:"1";s:3:"tag";s:1:"2";}i:2;a:2:{s:2:"id";s:1:"2";s:3:"tag";s:1:"2";}}}i:19;a:3:{s:8:"sphinxql";s:46:"select id, tag from dist3 where match ('test')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"3";s:3:"tag";s:1:"2";}i:1;a:2:{s:2:"id";s:1:"1";s:3:"tag";s:1:"2";}i:2;a:2:{s:2:"id";s:1:"2";s:3:"tag";s:1:"2";}}}i:20;a:3:{s:8:"sphinxql";s:52:"select id idd, tag from dist_no where match ('test')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:3:"idd";s:1:"1";s:3:"tag";s:1:"2";}i:1;a:2:{s:3:"idd";s:1:"2";s:3:"tag";s:1:"2";}i:2;a:2:{s:3:"idd";s:1:"3";s:3:"tag";s:1:"2";}}}i:21;a:3:{s:8:"sphinxql";s:50:"select id idd, tag from dist0 where match ('test')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:3:"idd";s:1:"1";s:3:"tag";s:1:"2";}i:1;a:2:{s:3:"idd";s:1:"2";s:3:"tag";s:1:"2";}i:2;a:2:{s:3:"idd";s:1:"3";s:3:"tag";s:1:"2";}}}i:22;a:3:{s:8:"sphinxql";s:50:"select id idd, tag from dist1 where match ('test')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:3:"idd";s:1:"3";s:3:"tag";s:1:"2";}i:1;a:2:{s:3:"idd";s:1:"1";s:3:"tag";s:1:"2";}i:2;a:2:{s:3:"idd";s:1:"2";s:3:"tag";s:1:"2";}}}i:23;a:3:{s:8:"sphinxql";s:50:"select id idd, tag from dist2 where match ('test')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:3:"idd";s:1:"3";s:3:"tag";s:1:"2";}i:1;a:2:{s:3:"idd";s:1:"1";s:3:"tag";s:1:"2";}i:2;a:2:{s:3:"idd";s:1:"2";s:3:"tag";s:1:"2";}}}i:24;a:3:{s:8:"sphinxql";s:50:"select id idd, tag from dist3 where match ('test')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:3:"idd";s:1:"3";s:3:"tag";s:1:"2";}i:1;a:2:{s:3:"idd";s:1:"1";s:3:"tag";s:1:"2";}i:2;a:2:{s:3:"idd";s:1:"2";s:3:"tag";s:1:"2";}}}i:25;a:3:{s:8:"sphinxql";s:36:"select gr, count(*) cnt from dist_no";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"gr";s:1:"3";s:3:"cnt";s:1:"3";}}}i:26;a:3:{s:8:"sphinxql";s:34:"select gr, count(*) cnt from dist0";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"gr";s:1:"3";s:3:"cnt";s:1:"3";}}}i:27;a:3:{s:8:"sphinxql";s:34:"select gr, count(*) cnt from dist1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"gr";s:1:"3";s:3:"cnt";s:1:"3";}}}i:28;a:3:{s:8:"sphinxql";s:39:"select gr from dist_no where count(*)=1";s:5:"error";s:63:"sphinxql: Aggregates in 'where' clause prohibited, use 'having'";s:5:"errno";i:1064;}i:29;a:3:{s:8:"sphinxql";s:37:"select gr from dist_no where @count=1";s:5:"error";s:63:"sphinxql: Aggregates in 'where' clause prohibited, use 'having'";s:5:"errno";i:1064;}i:30;a:3:{s:8:"sphinxql";s:39:"select gr from dist_no where weight()=1";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:2:"gr";s:1:"3";}i:1;a:1:{s:2:"gr";s:1:"2";}i:2;a:1:{s:2:"gr";s:1:"3";}}}i:31;a:3:{s:8:"sphinxql";s:38:"select gr from dist_no where @weight=1";s:5:"error";s:70:"Using the old-fashion @variables (@count, @weight, etc.) is deprecated";s:5:"errno";i:1064;}i:32;a:3:{s:8:"sphinxql";s:37:"select gr from dist0 where count(*)=1";s:5:"error";s:63:"sphinxql: Aggregates in 'where' clause prohibited, use 'having'";s:5:"errno";i:1064;}i:33;a:3:{s:8:"sphinxql";s:35:"select gr from dist0 where @count=1";s:5:"error";s:63:"sphinxql: Aggregates in 'where' clause prohibited, use 'having'";s:5:"errno";i:1064;}i:34;a:3:{s:8:"sphinxql";s:37:"select gr from dist0 where weight()=1";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:2:"gr";s:1:"3";}i:1;a:1:{s:2:"gr";s:1:"2";}i:2;a:1:{s:2:"gr";s:1:"3";}}}i:35;a:3:{s:8:"sphinxql";s:36:"select gr from dist0 where @weight=1";s:5:"error";s:70:"Using the old-fashion @variables (@count, @weight, etc.) is deprecated";s:5:"errno";i:1064;}i:36;a:3:{s:8:"sphinxql";s:37:"select gr from dist1 where count(*)=1";s:5:"error";s:63:"sphinxql: Aggregates in 'where' clause prohibited, use 'having'";s:5:"errno";i:1064;}i:37;a:3:{s:8:"sphinxql";s:35:"select gr from dist1 where @count=1";s:5:"error";s:63:"sphinxql: Aggregates in 'where' clause prohibited, use 'having'";s:5:"errno";i:1064;}i:38;a:3:{s:8:"sphinxql";s:37:"select gr from dist1 where weight()=1";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:2:"gr";s:1:"3";}i:1;a:1:{s:2:"gr";s:1:"2";}i:2;a:1:{s:2:"gr";s:1:"3";}}}i:39;a:3:{s:8:"sphinxql";s:36:"select gr from dist1 where @weight=1";s:5:"error";s:70:"Using the old-fashion @variables (@count, @weight, etc.) is deprecated";s:5:"errno";i:1064;}i:40;a:3:{s:8:"sphinxql";s:37:"select gr from dist2 where count(*)=1";s:5:"error";s:63:"sphinxql: Aggregates in 'where' clause prohibited, use 'having'";s:5:"errno";i:1064;}i:41;a:3:{s:8:"sphinxql";s:35:"select gr from dist2 where @count=1";s:5:"error";s:63:"sphinxql: Aggregates in 'where' clause prohibited, use 'having'";s:5:"errno";i:1064;}i:42;a:3:{s:8:"sphinxql";s:37:"select gr from dist2 where weight()=1";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:2:"gr";s:1:"3";}i:1;a:1:{s:2:"gr";s:1:"2";}i:2;a:1:{s:2:"gr";s:1:"3";}}}i:43;a:3:{s:8:"sphinxql";s:36:"select gr from dist2 where @weight=1";s:5:"error";s:70:"Using the old-fashion @variables (@count, @weight, etc.) is deprecated";s:5:"errno";i:1064;}i:44;a:3:{s:8:"sphinxql";s:37:"select gr from dist3 where count(*)=1";s:5:"error";s:63:"sphinxql: Aggregates in 'where' clause prohibited, use 'having'";s:5:"errno";i:1064;}i:45;a:3:{s:8:"sphinxql";s:35:"select gr from dist3 where @count=1";s:5:"error";s:63:"sphinxql: Aggregates in 'where' clause prohibited, use 'having'";s:5:"errno";i:1064;}i:46;a:3:{s:8:"sphinxql";s:37:"select gr from dist3 where weight()=1";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:2:"gr";s:1:"3";}i:1;a:1:{s:2:"gr";s:1:"2";}i:2;a:1:{s:2:"gr";s:1:"3";}}}i:47;a:3:{s:8:"sphinxql";s:36:"select gr from dist3 where @weight=1";s:5:"error";s:70:"Using the old-fashion @variables (@count, @weight, etc.) is deprecated";s:5:"errno";i:1064;}i:48;a:3:{s:8:"sphinxql";s:46:"select id idd from dist_no where match('test')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:3:"idd";s:1:"1";}i:1;a:1:{s:3:"idd";s:1:"2";}i:2;a:1:{s:3:"idd";s:1:"3";}}}i:49;a:3:{s:8:"sphinxql";s:44:"select count(*) cnt from dist_no group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:1:{s:3:"cnt";s:1:"2";}i:1;a:1:{s:3:"cnt";s:1:"1";}}}i:50;a:3:{s:8:"sphinxql";s:44:"select weight() cnt from dist_no group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:1:{s:3:"cnt";s:1:"1";}i:1;a:1:{s:3:"cnt";s:1:"1";}}}i:51;a:3:{s:8:"sphinxql";s:44:"select id idd from dist0 where match('test')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:3:"idd";s:1:"1";}i:1;a:1:{s:3:"idd";s:1:"2";}i:2;a:1:{s:3:"idd";s:1:"3";}}}i:52;a:3:{s:8:"sphinxql";s:42:"select count(*) cnt from dist0 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:1:{s:3:"cnt";s:1:"2";}i:1;a:1:{s:3:"cnt";s:1:"1";}}}i:53;a:3:{s:8:"sphinxql";s:42:"select weight() cnt from dist0 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:1:{s:3:"cnt";s:1:"1";}i:1;a:1:{s:3:"cnt";s:1:"1";}}}i:54;a:3:{s:8:"sphinxql";s:44:"select id idd from dist1 where match('test')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:3:"idd";s:1:"3";}i:1;a:1:{s:3:"idd";s:1:"1";}i:2;a:1:{s:3:"idd";s:1:"2";}}}i:55;a:3:{s:8:"sphinxql";s:42:"select count(*) cnt from dist1 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:1:{s:3:"cnt";s:1:"2";}i:1;a:1:{s:3:"cnt";s:1:"1";}}}i:56;a:3:{s:8:"sphinxql";s:42:"select weight() cnt from dist1 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:1:{s:3:"cnt";s:1:"1";}i:1;a:1:{s:3:"cnt";s:1:"1";}}}i:57;a:3:{s:8:"sphinxql";s:44:"select id idd from dist2 where match('test')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:3:"idd";s:1:"3";}i:1;a:1:{s:3:"idd";s:1:"1";}i:2;a:1:{s:3:"idd";s:1:"2";}}}i:58;a:3:{s:8:"sphinxql";s:42:"select count(*) cnt from dist2 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:1:{s:3:"cnt";s:1:"2";}i:1;a:1:{s:3:"cnt";s:1:"1";}}}i:59;a:3:{s:8:"sphinxql";s:42:"select weight() cnt from dist2 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:1:{s:3:"cnt";s:1:"1";}i:1;a:1:{s:3:"cnt";s:1:"1";}}}i:60;a:3:{s:8:"sphinxql";s:44:"select id idd from dist3 where match('test')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:3:"idd";s:1:"3";}i:1;a:1:{s:3:"idd";s:1:"1";}i:2;a:1:{s:3:"idd";s:1:"2";}}}i:61;a:3:{s:8:"sphinxql";s:42:"select count(*) cnt from dist3 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:1:{s:3:"cnt";s:1:"2";}i:1;a:1:{s:3:"cnt";s:1:"1";}}}i:62;a:3:{s:8:"sphinxql";s:42:"select weight() cnt from dist3 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:1:{s:3:"cnt";s:1:"1";}i:1;a:1:{s:3:"cnt";s:1:"1";}}}i:63;a:3:{s:8:"sphinxql";s:53:"select @id idd, count(*) cnt from dist_no group by gr";s:5:"error";s:163:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near ') cnt from dist_no group by gr'";s:5:"errno";i:1064;}i:64;a:3:{s:8:"sphinxql";s:50:"select id idd, @count cnt from dist_no group by gr";s:5:"error";s:168:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near '@count cnt from dist_no group by gr'";s:5:"errno";i:1064;}i:65;a:3:{s:8:"sphinxql";s:53:"select id idd from dist_no where @count=1 group by gr";s:5:"error";s:153:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near '@count=1 group by gr'";s:5:"errno";i:1064;}i:66;a:3:{s:8:"sphinxql";s:56:"select @id idd from dist_no where count(*)=1 group by gr";s:5:"error";s:148:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near ')=1 group by gr'";s:5:"errno";i:1064;}i:67;a:3:{s:8:"sphinxql";s:42:"select id idd from dist_no group by @count";s:5:"error";s:139:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near '@count'";s:5:"errno";i:1064;}i:68;a:3:{s:8:"sphinxql";s:45:"select @id idd from dist_no group by count(*)";s:5:"error";s:134:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near ')'";s:5:"errno";i:1064;}i:69;a:3:{s:8:"sphinxql";s:51:"select @id idd, count(*) cnt from dist0 group by gr";s:5:"error";s:161:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near ') cnt from dist0 group by gr'";s:5:"errno";i:1064;}i:70;a:3:{s:8:"sphinxql";s:48:"select id idd, @count cnt from dist0 group by gr";s:5:"error";s:166:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near '@count cnt from dist0 group by gr'";s:5:"errno";i:1064;}i:71;a:3:{s:8:"sphinxql";s:51:"select id idd from dist0 where @count=1 group by gr";s:5:"error";s:153:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near '@count=1 group by gr'";s:5:"errno";i:1064;}i:72;a:3:{s:8:"sphinxql";s:54:"select @id idd from dist0 where count(*)=1 group by gr";s:5:"error";s:148:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near ')=1 group by gr'";s:5:"errno";i:1064;}i:73;a:3:{s:8:"sphinxql";s:40:"select id idd from dist0 group by @count";s:5:"error";s:139:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near '@count'";s:5:"errno";i:1064;}i:74;a:3:{s:8:"sphinxql";s:43:"select @id idd from dist0 group by count(*)";s:5:"error";s:134:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near ')'";s:5:"errno";i:1064;}i:75;a:3:{s:8:"sphinxql";s:51:"select @id idd, count(*) cnt from dist1 group by gr";s:5:"error";s:161:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near ') cnt from dist1 group by gr'";s:5:"errno";i:1064;}i:76;a:3:{s:8:"sphinxql";s:48:"select id idd, @count cnt from dist1 group by gr";s:5:"error";s:166:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near '@count cnt from dist1 group by gr'";s:5:"errno";i:1064;}i:77;a:3:{s:8:"sphinxql";s:51:"select id idd from dist1 where @count=1 group by gr";s:5:"error";s:153:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near '@count=1 group by gr'";s:5:"errno";i:1064;}i:78;a:3:{s:8:"sphinxql";s:54:"select @id idd from dist1 where count(*)=1 group by gr";s:5:"error";s:148:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near ')=1 group by gr'";s:5:"errno";i:1064;}i:79;a:3:{s:8:"sphinxql";s:40:"select id idd from dist1 group by @count";s:5:"error";s:139:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near '@count'";s:5:"errno";i:1064;}i:80;a:3:{s:8:"sphinxql";s:43:"select @id idd from dist1 group by count(*)";s:5:"error";s:134:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near ')'";s:5:"errno";i:1064;}i:81;a:3:{s:8:"sphinxql";s:51:"select @id idd, count(*) cnt from dist2 group by gr";s:5:"error";s:161:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near ') cnt from dist2 group by gr'";s:5:"errno";i:1064;}i:82;a:3:{s:8:"sphinxql";s:48:"select id idd, @count cnt from dist2 group by gr";s:5:"error";s:166:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near '@count cnt from dist2 group by gr'";s:5:"errno";i:1064;}i:83;a:3:{s:8:"sphinxql";s:51:"select id idd from dist2 where @count=1 group by gr";s:5:"error";s:153:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near '@count=1 group by gr'";s:5:"errno";i:1064;}i:84;a:3:{s:8:"sphinxql";s:54:"select @id idd from dist2 where count(*)=1 group by gr";s:5:"error";s:148:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near ')=1 group by gr'";s:5:"errno";i:1064;}i:85;a:3:{s:8:"sphinxql";s:40:"select id idd from dist2 group by @count";s:5:"error";s:139:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near '@count'";s:5:"errno";i:1064;}i:86;a:3:{s:8:"sphinxql";s:43:"select @id idd from dist2 group by count(*)";s:5:"error";s:134:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near ')'";s:5:"errno";i:1064;}i:87;a:3:{s:8:"sphinxql";s:51:"select @id idd, count(*) cnt from dist3 group by gr";s:5:"error";s:161:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near ') cnt from dist3 group by gr'";s:5:"errno";i:1064;}i:88;a:3:{s:8:"sphinxql";s:48:"select id idd, @count cnt from dist3 group by gr";s:5:"error";s:166:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near '@count cnt from dist3 group by gr'";s:5:"errno";i:1064;}i:89;a:3:{s:8:"sphinxql";s:51:"select id idd from dist3 where @count=1 group by gr";s:5:"error";s:153:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near '@count=1 group by gr'";s:5:"errno";i:1064;}i:90;a:3:{s:8:"sphinxql";s:54:"select @id idd from dist3 where count(*)=1 group by gr";s:5:"error";s:148:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near ')=1 group by gr'";s:5:"errno";i:1064;}i:91;a:3:{s:8:"sphinxql";s:40:"select id idd from dist3 group by @count";s:5:"error";s:139:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near '@count'";s:5:"errno";i:1064;}i:92;a:3:{s:8:"sphinxql";s:43:"select @id idd from dist3 group by count(*)";s:5:"error";s:134:"sphinxql: Mixing the old-fashion internal vars (@id, @count, @weight) with new acronyms like count(*), weight() is prohibited near ')'";s:5:"errno";i:1064;}i:93;a:3:{s:8:"sphinxql";s:57:"select id, count (distinct tag) tg from dist2 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"1";s:2:"tg";s:1:"1";}i:1;a:2:{s:2:"id";s:1:"2";s:2:"tg";s:1:"1";}}}i:94;a:3:{s:8:"sphinxql";s:62:"select id, count (distinct tag) tg from idx1, idx2 group by gr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"1";s:2:"tg";s:1:"1";}i:1;a:2:{s:2:"id";s:1:"2";s:2:"tg";s:1:"1";}}}i:95;a:3:{s:8:"sphinxql";s:80:"select id, count (distinct tag), count(*) from distinct1, distinct2 group by tag";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:3:{s:2:"id";s:1:"1";s:20:"count (distinct tag)";s:1:"1";s:8:"count(*)";s:2:"20";}i:1;a:3:{s:2:"id";s:2:"11";s:20:"count (distinct tag)";s:1:"1";s:8:"count(*)";s:1:"2";}}}i:96;a:3:{s:8:"sphinxql";s:78:"select id, count (distinct gr), count(*) from distinct1, distinct2 group by gr";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:19:"count (distinct gr)";s:1:"1";s:8:"count(*)";s:2:"17";}i:1;a:3:{s:2:"id";s:1:"8";s:19:"count (distinct gr)";s:1:"1";s:8:"count(*)";s:1:"1";}i:2;a:3:{s:2:"id";s:1:"9";s:19:"count (distinct gr)";s:1:"1";s:8:"count(*)";s:1:"3";}i:3;a:3:{s:2:"id";s:2:"10";s:19:"count (distinct gr)";s:1:"1";s:8:"count(*)";s:1:"1";}}}i:97;a:3:{s:8:"sphinxql";s:79:"select id, count (distinct tag), count(*) from distinct1, distinct2 group by gr";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:20:"count (distinct tag)";s:1:"1";s:8:"count(*)";s:2:"17";}i:1;a:3:{s:2:"id";s:1:"8";s:20:"count (distinct tag)";s:1:"1";s:8:"count(*)";s:1:"1";}i:2;a:3:{s:2:"id";s:1:"9";s:20:"count (distinct tag)";s:1:"3";s:8:"count(*)";s:1:"3";}i:3;a:3:{s:2:"id";s:2:"10";s:20:"count (distinct tag)";s:1:"1";s:8:"count(*)";s:1:"1";}}}i:98;a:3:{s:8:"sphinxql";s:79:"select id, count (distinct gr), count(*) from distinct1, distinct2 group by tag";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:3:{s:2:"id";s:1:"1";s:19:"count (distinct gr)";s:1:"4";s:8:"count(*)";s:2:"20";}i:1;a:3:{s:2:"id";s:2:"11";s:19:"count (distinct gr)";s:1:"1";s:8:"count(*)";s:1:"2";}}}i:99;a:3:{s:8:"sphinxql";s:80:"select id, count (distinct tag), count(*) from distinct1, distinct1 group by tag";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:3:{s:2:"id";s:1:"1";s:20:"count (distinct tag)";s:1:"1";s:8:"count(*)";s:2:"20";}i:1;a:3:{s:2:"id";s:2:"11";s:20:"count (distinct tag)";s:1:"1";s:8:"count(*)";s:1:"2";}}}i:100;a:3:{s:8:"sphinxql";s:78:"select id, count (distinct gr), count(*) from distinct1, distinct1 group by gr";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:19:"count (distinct gr)";s:1:"1";s:8:"count(*)";s:2:"14";}i:1;a:3:{s:2:"id";s:1:"8";s:19:"count (distinct gr)";s:1:"1";s:8:"count(*)";s:1:"2";}i:2;a:3:{s:2:"id";s:1:"9";s:19:"count (distinct gr)";s:1:"1";s:8:"count(*)";s:1:"4";}i:3;a:3:{s:2:"id";s:2:"10";s:19:"count (distinct gr)";s:1:"1";s:8:"count(*)";s:1:"2";}}}i:101;a:3:{s:8:"sphinxql";s:79:"select id, count (distinct tag), count(*) from distinct1, distinct1 group by gr";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:20:"count (distinct tag)";s:1:"1";s:8:"count(*)";s:2:"14";}i:1;a:3:{s:2:"id";s:1:"8";s:20:"count (distinct tag)";s:1:"1";s:8:"count(*)";s:1:"2";}i:2;a:3:{s:2:"id";s:1:"9";s:20:"count (distinct tag)";s:1:"2";s:8:"count(*)";s:1:"4";}i:3;a:3:{s:2:"id";s:2:"10";s:20:"count (distinct tag)";s:1:"1";s:8:"count(*)";s:1:"2";}}}i:102;a:3:{s:8:"sphinxql";s:79:"select id, count (distinct gr), count(*) from distinct1, distinct1 group by tag";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:3:{s:2:"id";s:1:"1";s:19:"count (distinct gr)";s:1:"4";s:8:"count(*)";s:2:"20";}i:1;a:3:{s:2:"id";s:2:"11";s:19:"count (distinct gr)";s:1:"1";s:8:"count(*)";s:1:"2";}}}i:103;a:3:{s:8:"sphinxql";s:62:"select id, max(tag) as cond from idx1 where cond<5 group by gr";s:5:"error";s:57:"index idx1: unsupported filter 'cond' on aggregate column";s:5:"errno";i:1064;}i:104;a:3:{s:8:"sphinxql";s:96:"SELECT * FROM ( SELECT * FROM sub_dist_loc ORDER BY id asc LIMIT 15 ) ORDER BY id desc LIMIT 3,5";s:10:"total_rows";i:5;s:4:"rows";a:5:{i:0;a:2:{s:2:"id";s:3:"102";s:3:"tag";s:1:"1";}i:1;a:2:{s:2:"id";s:3:"101";s:3:"tag";s:1:"1";}i:2;a:2:{s:2:"id";s:2:"25";s:3:"tag";s:1:"1";}i:3;a:2:{s:2:"id";s:2:"24";s:3:"tag";s:1:"1";}i:4;a:2:{s:2:"id";s:2:"23";s:3:"tag";s:1:"1";}}}i:105;a:3:{s:8:"sphinxql";s:94:"SELECT * FROM ( SELECT * FROM sub_dist_1 ORDER BY id desc LIMIT 7 ) ORDER BY id desc LIMIT 4,3";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:3:"116";s:3:"tag";s:1:"1";}i:1;a:2:{s:2:"id";s:3:"115";s:3:"tag";s:1:"1";}i:2;a:2:{s:2:"id";s:3:"114";s:3:"tag";s:1:"1";}}}i:106;a:3:{s:8:"sphinxql";s:94:"SELECT * FROM ( SELECT * FROM sub_dist_2 ORDER BY id asc LIMIT 11 ) ORDER BY id desc LIMIT 1,5";s:10:"total_rows";i:5;s:4:"rows";a:5:{i:0;a:2:{s:2:"id";s:2:"20";s:3:"tag";s:1:"1";}i:1;a:2:{s:2:"id";s:2:"18";s:3:"tag";s:1:"1";}i:2;a:2:{s:2:"id";s:2:"16";s:3:"tag";s:1:"1";}i:3;a:2:{s:2:"id";s:2:"14";s:3:"tag";s:1:"1";}i:4;a:2:{s:2:"id";s:2:"12";s:3:"tag";s:1:"1";}}}i:107;a:3:{s:8:"sphinxql";s:95:"SELECT * FROM ( SELECT * FROM sub_dist_loc ORDER BY id asc LIMIT 5 ) ORDER BY id desc LIMIT 2,4";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:2:"id";s:1:"8";s:3:"tag";s:1:"1";}i:1;a:2:{s:2:"id";s:1:"7";s:3:"tag";s:1:"1";}i:2;a:2:{s:2:"id";s:1:"6";s:3:"tag";s:1:"1";}i:3;a:2:{s:2:"id";s:1:"5";s:3:"tag";s:1:"1";}}}i:108;a:3:{s:8:"sphinxql";s:53:"SELECT * FROM dist_offset ORDER BY id asc LIMIT 23, 5";s:10:"total_rows";i:5;s:4:"rows";a:5:{i:0;a:2:{s:2:"id";s:2:"24";s:3:"tag";s:1:"1";}i:1;a:2:{s:2:"id";s:2:"25";s:3:"tag";s:1:"1";}i:2;a:2:{s:2:"id";s:3:"101";s:3:"tag";s:1:"1";}i:3;a:2:{s:2:"id";s:3:"102";s:3:"tag";s:1:"1";}i:4;a:2:{s:2:"id";s:3:"103";s:3:"tag";s:1:"1";}}}i:109;a:2:{s:8:"sphinxql";s:76:"INSERT INTO words_rt1 VALUES ( 100, 'yes of', 111 ), ( 102, 'yes pey', 122 )";s:14:"total_affected";i:2;}i:110;a:2:{s:8:"sphinxql";s:76:"INSERT INTO words_rt2 VALUES ( 200, 'yes of', 211 ), ( 202, 'yes pey', 222 )";s:14:"total_affected";i:2;}i:111;a:3:{s:8:"sphinxql";s:53:"select * from words1, words2 where match('yes | pey')";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"2";s:3:"idd";s:2:"22";}i:1;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:2:"11";}}}i:112;a:3:{s:8:"sphinxql";s:9:"show meta";s:10:"total_rows";i:16;s:4:"rows";a:15:{i:0;a:2:{s:13:"Variable_name";s:7:"warning";s:5:"Value";s:46:"index 'words2': query word(s) mismatch: es, pe";}i:1;a:2:{s:13:"Variable_name";s:5:"total";s:5:"Value";s:1:"2";}i:2;a:2:{s:13:"Variable_name";s:11:"total_found";s:5:"Value";s:1:"2";}i:3;a:2:{s:13:"Variable_name";s:10:"keyword[0]";s:5:"Value";s:3:"yes";}i:4;a:2:{s:13:"Variable_name";s:7:"docs[0]";s:5:"Value";s:1:"2";}i:5;a:2:{s:13:"Variable_name";s:7:"hits[0]";s:5:"Value";s:1:"2";}i:6;a:2:{s:13:"Variable_name";s:10:"keyword[1]";s:5:"Value";s:3:"pey";}i:7;a:2:{s:13:"Variable_name";s:7:"docs[1]";s:5:"Value";s:1:"1";}i:8;a:2:{s:13:"Variable_name";s:7:"hits[1]";s:5:"Value";s:1:"1";}i:9;a:2:{s:13:"Variable_name";s:10:"keyword[2]";s:5:"Value";s:2:"es";}i:10;a:2:{s:13:"Variable_name";s:7:"docs[2]";s:5:"Value";s:1:"2";}i:11;a:2:{s:13:"Variable_name";s:7:"hits[2]";s:5:"Value";s:1:"2";}i:12;a:2:{s:13:"Variable_name";s:10:"keyword[3]";s:5:"Value";s:2:"pe";}i:13;a:2:{s:13:"Variable_name";s:7:"docs[3]";s:5:"Value";s:1:"1";}i:14;a:2:{s:13:"Variable_name";s:7:"hits[3]";s:5:"Value";s:1:"1";}}}i:113;a:3:{s:8:"sphinxql";s:59:"select * from words_rt1, words_rt2 where match('yes | pey')";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:2:"id";s:3:"102";s:3:"idd";s:3:"122";}i:1;a:2:{s:2:"id";s:3:"202";s:3:"idd";s:3:"222";}i:2;a:2:{s:2:"id";s:3:"100";s:3:"idd";s:3:"111";}i:3;a:2:{s:2:"id";s:3:"200";s:3:"idd";s:3:"211";}}}i:114;a:3:{s:8:"sphinxql";s:9:"show meta";s:10:"total_rows";i:16;s:4:"rows";a:15:{i:0;a:2:{s:13:"Variable_name";s:7:"warning";s:5:"Value";s:49:"index 'words_rt2': query word(s) mismatch: es, pe";}i:1;a:2:{s:13:"Variable_name";s:5:"total";s:5:"Value";s:1:"4";}i:2;a:2:{s:13:"Variable_name";s:11:"total_found";s:5:"Value";s:1:"4";}i:3;a:2:{s:13:"Variable_name";s:10:"keyword[0]";s:5:"Value";s:3:"yes";}i:4;a:2:{s:13:"Variable_name";s:7:"docs[0]";s:5:"Value";s:1:"2";}i:5;a:2:{s:13:"Variable_name";s:7:"hits[0]";s:5:"Value";s:1:"2";}i:6;a:2:{s:13:"Variable_name";s:10:"keyword[1]";s:5:"Value";s:3:"pey";}i:7;a:2:{s:13:"Variable_name";s:7:"docs[1]";s:5:"Value";s:1:"1";}i:8;a:2:{s:13:"Variable_name";s:7:"hits[1]";s:5:"Value";s:1:"1";}i:9;a:2:{s:13:"Variable_name";s:10:"keyword[2]";s:5:"Value";s:2:"es";}i:10;a:2:{s:13:"Variable_name";s:7:"docs[2]";s:5:"Value";s:1:"2";}i:11;a:2:{s:13:"Variable_name";s:7:"hits[2]";s:5:"Value";s:1:"2";}i:12;a:2:{s:13:"Variable_name";s:10:"keyword[3]";s:5:"Value";s:2:"pe";}i:13;a:2:{s:13:"Variable_name";s:7:"docs[3]";s:5:"Value";s:1:"1";}i:14;a:2:{s:13:"Variable_name";s:7:"hits[3]";s:5:"Value";s:1:"1";}}}i:115;a:3:{s:8:"sphinxql";s:56:"select * from words_rt1, words2 where match('yes | pey')";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:2:"id";s:1:"2";s:3:"idd";s:2:"22";}i:1;a:2:{s:2:"id";s:3:"102";s:3:"idd";s:3:"122";}i:2;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:2:"11";}i:3;a:2:{s:2:"id";s:3:"100";s:3:"idd";s:3:"111";}}}i:116;a:3:{s:8:"sphinxql";s:9:"show meta";s:10:"total_rows";i:16;s:4:"rows";a:15:{i:0;a:2:{s:13:"Variable_name";s:7:"warning";s:5:"Value";s:46:"index 'words2': query word(s) mismatch: es, pe";}i:1;a:2:{s:13:"Variable_name";s:5:"total";s:5:"Value";s:1:"4";}i:2;a:2:{s:13:"Variable_name";s:11:"total_found";s:5:"Value";s:1:"4";}i:3;a:2:{s:13:"Variable_name";s:10:"keyword[0]";s:5:"Value";s:3:"yes";}i:4;a:2:{s:13:"Variable_name";s:7:"docs[0]";s:5:"Value";s:1:"2";}i:5;a:2:{s:13:"Variable_name";s:7:"hits[0]";s:5:"Value";s:1:"2";}i:6;a:2:{s:13:"Variable_name";s:10:"keyword[1]";s:5:"Value";s:3:"pey";}i:7;a:2:{s:13:"Variable_name";s:7:"docs[1]";s:5:"Value";s:1:"1";}i:8;a:2:{s:13:"Variable_name";s:7:"hits[1]";s:5:"Value";s:1:"1";}i:9;a:2:{s:13:"Variable_name";s:10:"keyword[2]";s:5:"Value";s:2:"es";}i:10;a:2:{s:13:"Variable_name";s:7:"docs[2]";s:5:"Value";s:1:"2";}i:11;a:2:{s:13:"Variable_name";s:7:"hits[2]";s:5:"Value";s:1:"2";}i:12;a:2:{s:13:"Variable_name";s:10:"keyword[3]";s:5:"Value";s:2:"pe";}i:13;a:2:{s:13:"Variable_name";s:7:"docs[3]";s:5:"Value";s:1:"1";}i:14;a:2:{s:13:"Variable_name";s:7:"hits[3]";s:5:"Value";s:1:"1";}}}i:117;a:3:{s:8:"sphinxql";s:32:"SELECT id, COUNT(*) FROM dist_no";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"1";s:8:"count(*)";s:1:"3";}}}i:118;a:3:{s:8:"sphinxql";s:31:"SELECT id, MIN(gr) FROM dist_no";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"1";s:7:"min(gr)";s:1:"2";}}}i:119;a:3:{s:8:"sphinxql";s:42:"SELECT id, COUNT(DISTINCT gr) FROM dist_no";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"1";s:18:"count(distinct gr)";s:1:"2";}}}i:120;a:3:{s:8:"sphinxql";s:62:"SELECT id, COUNT(*) FROM dist_no WITHIN GROUP ORDER BY id DESC";s:5:"error";s:100:"sphinxql: you must specify GROUP BY element in order to use WITHIN GROUP ORDER BY clause near 'DESC'";s:5:"errno";i:1064;}i:121;a:3:{s:8:"sphinxql";s:30:"SELECT id, COUNT(*) FROM dist2";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"1";s:8:"count(*)";s:1:"3";}}}i:122;a:3:{s:8:"sphinxql";s:29:"SELECT id, MIN(gr) FROM dist2";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"1";s:7:"min(gr)";s:1:"2";}}}i:123;a:3:{s:8:"sphinxql";s:40:"SELECT id, COUNT(DISTINCT gr) FROM dist2";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"1";s:18:"count(distinct gr)";s:1:"2";}}}i:124;a:3:{s:8:"sphinxql";s:18:"SELECT * FROM idx1";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"tag";s:1:"2";s:2:"gr";s:1:"3";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"tag";s:1:"2";s:2:"gr";s:1:"2";}}}i:125;a:3:{s:8:"sphinxql";s:29:"SELECT * FROM idx1 WHERE id>1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"2";s:3:"tag";s:1:"2";s:2:"gr";s:1:"2";}}}i:126;a:3:{s:8:"sphinxql";s:35:"SELECT * FROM dist_just1 WHERE id>1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"2";s:3:"tag";s:1:"2";s:2:"gr";s:1:"2";}}}i:127;a:3:{s:8:"sphinxql";s:172:"SELECT * FROM ( SELECT @id, @weight FROM sub_dist_loc WHERE MATCH ( 'test ( my | of )' ) ORDER BY @weight asc, @id desc LIMIT 15 ) ORDER BY @weight desc, @id asc LIMIT 0, 5";s:5:"error";s:70:"Using the old-fashion @variables (@count, @weight, etc.) is deprecated";s:5:"errno";i:1064;}i:128;a:3:{s:8:"sphinxql";s:169:"SELECT * FROM ( SELECT id, weight() as wgt FROM sub_dist_loc WHERE MATCH ( 'test ( my | of )' ) ORDER BY wgt asc, id desc LIMIT 15 ) ORDER BY wgt desc, id asc LIMIT 0, 5";s:10:"total_rows";i:5;s:4:"rows";a:5:{i:0;a:2:{s:2:"id";s:1:"7";s:3:"wgt";s:4:"1463";}i:1;a:2:{s:2:"id";s:2:"17";s:3:"wgt";s:4:"1463";}i:2;a:2:{s:2:"id";s:3:"107";s:3:"wgt";s:4:"1463";}i:3;a:2:{s:2:"id";s:3:"117";s:3:"wgt";s:4:"1463";}i:4;a:2:{s:2:"id";s:1:"6";s:3:"wgt";s:4:"1462";}}}i:129;a:3:{s:8:"sphinxql";s:78:"SELECT id, COUNT(*) cc, GROUPBY() gg FROM dist2 GROUP BY gr HAVING COUNT(*)>=1";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:3:{s:2:"id";s:1:"1";s:2:"cc";s:1:"2";s:2:"gg";s:1:"3";}i:1;a:3:{s:2:"id";s:1:"2";s:2:"cc";s:1:"1";s:2:"gg";s:1:"2";}}}i:130;a:3:{s:8:"sphinxql";s:80:"SELECT id, COUNT(*) cc, GROUPBY() gg FROM dist_no GROUP BY gr HAVING COUNT(*)>=1";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:3:{s:2:"id";s:1:"1";s:2:"cc";s:1:"2";s:2:"gg";s:1:"3";}i:1;a:3:{s:2:"id";s:1:"2";s:2:"cc";s:1:"1";s:2:"gg";s:1:"2";}}}i:131;a:3:{s:8:"sphinxql";s:71:"SELECT id, COUNT(*) cc, GROUPBY() gg FROM dist2 GROUP BY gr HAVING cc<3";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:3:{s:2:"id";s:1:"1";s:2:"cc";s:1:"2";s:2:"gg";s:1:"3";}i:1;a:3:{s:2:"id";s:1:"2";s:2:"cc";s:1:"1";s:2:"gg";s:1:"2";}}}i:132;a:3:{s:8:"sphinxql";s:73:"SELECT id, COUNT(*) cc, GROUPBY() gg FROM dist_no GROUP BY gr HAVING cc<3";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:3:{s:2:"id";s:1:"1";s:2:"cc";s:1:"2";s:2:"gg";s:1:"3";}i:1;a:3:{s:2:"id";s:1:"2";s:2:"cc";s:1:"1";s:2:"gg";s:1:"2";}}}i:133;a:3:{s:8:"sphinxql";s:95:"SELECT id, COUNT(DISTINCT tag) cc, GROUPBY() gg FROM dist2 GROUP BY gr HAVING gg IN ( 1,2,3,10)";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:3:{s:2:"id";s:1:"1";s:2:"cc";s:1:"1";s:2:"gg";s:1:"3";}i:1;a:3:{s:2:"id";s:1:"2";s:2:"cc";s:1:"1";s:2:"gg";s:1:"2";}}}i:134;a:3:{s:8:"sphinxql";s:97:"SELECT id, COUNT(DISTINCT tag) cc, GROUPBY() gg FROM dist_no GROUP BY gr HAVING gg IN ( 1,2,3,10)";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:3:{s:2:"id";s:1:"1";s:2:"cc";s:1:"1";s:2:"gg";s:1:"3";}i:1;a:3:{s:2:"id";s:1:"2";s:2:"cc";s:1:"1";s:2:"gg";s:1:"2";}}}i:135;a:3:{s:8:"sphinxql";s:85:"SELECT id, MIN(gr) aa, COUNT(*) cc, GROUPBY() gg  FROM dist2 GROUP BY tag HAVING aa=2";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:4:{s:2:"id";s:1:"1";s:2:"aa";s:1:"2";s:2:"cc";s:1:"3";s:2:"gg";s:1:"2";}}}i:136;a:3:{s:8:"sphinxql";s:87:"SELECT id, MIN(gr) aa, COUNT(*) cc, GROUPBY() gg  FROM dist_no GROUP BY tag HAVING aa=2";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:4:{s:2:"id";s:1:"1";s:2:"aa";s:1:"2";s:2:"cc";s:1:"3";s:2:"gg";s:1:"2";}}}i:137;a:3:{s:8:"sphinxql";s:86:"SELECT id, MAX(gr) aa, COUNT(*) cc, GROUPBY() gg   FROM dist2 GROUP BY tag HAVING aa=3";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:4:{s:2:"id";s:1:"1";s:2:"aa";s:1:"3";s:2:"cc";s:1:"3";s:2:"gg";s:1:"2";}}}i:138;a:3:{s:8:"sphinxql";s:88:"SELECT id, MAX(gr) aa, COUNT(*) cc, GROUPBY() gg   FROM dist_no GROUP BY tag HAVING aa=3";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:4:{s:2:"id";s:1:"1";s:2:"aa";s:1:"3";s:2:"cc";s:1:"3";s:2:"gg";s:1:"2";}}}i:139;a:3:{s:8:"sphinxql";s:86:"SELECT id, SUM(gr) aa, COUNT(*) cc, GROUPBY() gg   FROM dist2 GROUP BY tag HAVING aa>5";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:4:{s:2:"id";s:1:"1";s:2:"aa";s:1:"8";s:2:"cc";s:1:"3";s:2:"gg";s:1:"2";}}}i:140;a:3:{s:8:"sphinxql";s:88:"SELECT id, SUM(gr) aa, COUNT(*) cc, GROUPBY() gg   FROM dist_no GROUP BY tag HAVING aa>5";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:4:{s:2:"id";s:1:"1";s:2:"aa";s:1:"8";s:2:"cc";s:1:"3";s:2:"gg";s:1:"2";}}}i:141;a:3:{s:8:"sphinxql";s:94:"select id, MIN(tag)  aa, COUNT(*) cc, GROUPBY() gg FROM dist2 GROUP 8  BY gr HAVING COUNT(*)=2";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:4:{s:2:"id";s:1:"1";s:2:"aa";s:1:"2";s:2:"cc";s:1:"2";s:2:"gg";s:1:"3";}i:1;a:4:{s:2:"id";s:1:"3";s:2:"aa";s:1:"2";s:2:"cc";s:1:"2";s:2:"gg";s:1:"3";}}}i:142;a:3:{s:8:"sphinxql";s:88:"select id, SUM(tag)  aa, COUNT(*) cc, GROUPBY() gg FROM dist2 GROUP 8  BY gr HAVING aa=4";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:4:{s:2:"id";s:1:"1";s:2:"aa";s:1:"4";s:2:"cc";s:1:"2";s:2:"gg";s:1:"3";}i:1;a:4:{s:2:"id";s:1:"3";s:2:"aa";s:1:"4";s:2:"cc";s:1:"2";s:2:"gg";s:1:"3";}}}i:143;a:3:{s:8:"sphinxql";s:85:"SELECT id, COUNT(*) cc, GROUPBY() gg FROM dist_j GROUP BY j.j1 HAVING j.j1 IN ( 1,2 )";s:5:"error";s:57:"can not use HAVING with attribute not related to GROUP BY";s:5:"errno";i:1064;}i:144;a:3:{s:8:"sphinxql";s:83:"SELECT id, COUNT(*) cc, GROUPBY() gg FROM dist_j GROUP BY j.j1 HAVING gg IN ( 1,2 )";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:3:{s:2:"id";s:1:"1";s:2:"cc";s:1:"2";s:2:"gg";s:1:"1";}i:1;a:3:{s:2:"id";s:1:"1";s:2:"cc";s:1:"1";s:2:"gg";s:1:"2";}}}}}