a:1:{i:0;a:16:{i:0;a:12:{s:5:"error";s:0:"";s:7:"warning";s:0:"";s:6:"status";i:0;s:6:"fields";a:1:{i:0;s:4:"body";}s:5:"attrs";a:4:{s:4:"idd1";i:1;s:4:"str1";i:7;s:8:"@groupby";i:1;s:6:"@count";i:1;}s:7:"matches";a:3:{i:7;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:4:{s:4:"idd1";s:1:"1";s:4:"str1";s:3:"a a";s:8:"@groupby";s:1:"1";s:6:"@count";s:1:"4";}}i:5;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:4:{s:4:"idd1";s:1:"3";s:4:"str1";s:3:"a a";s:8:"@groupby";s:1:"3";s:6:"@count";s:1:"2";}}i:3;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:4:{s:4:"idd1";s:2:"11";s:4:"str1";s:3:"a a";s:8:"@groupby";s:2:"11";s:6:"@count";s:1:"3";}}}s:5:"total";s:1:"3";s:11:"total_found";s:1:"3";s:4:"time";s:5:"0.001";s:8:"resarray";i:0;s:8:"roundoff";i:0;s:5:"query";s:0:"";}i:1;a:12:{s:5:"error";s:0:"";s:7:"warning";s:0:"";s:6:"status";i:0;s:6:"fields";a:1:{i:0;s:4:"body";}s:5:"attrs";a:4:{s:4:"idd1";i:1;s:4:"str1";i:7;s:8:"@groupby";i:1;s:6:"@count";i:1;}s:7:"matches";a:3:{i:6;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:4:{s:4:"idd1";s:1:"1";s:4:"str1";s:4:"c cc";s:8:"@groupby";s:1:"1";s:6:"@count";s:1:"4";}}i:9;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:4:{s:4:"idd1";s:1:"3";s:4:"str1";s:4:"c cc";s:8:"@groupby";s:1:"3";s:6:"@count";s:1:"2";}}i:4;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:4:{s:4:"idd1";s:2:"11";s:4:"str1";s:4:"cc c";s:8:"@groupby";s:2:"11";s:6:"@count";s:1:"3";}}}s:5:"total";s:1:"3";s:11:"total_found";s:1:"3";s:4:"time";s:5:"0.001";s:8:"resarray";i:0;s:8:"roundoff";i:0;s:5:"query";s:0:"";}i:2;a:13:{s:5:"error";s:0:"";s:7:"warning";s:0:"";s:6:"status";i:0;s:6:"fields";a:1:{i:0;s:4:"body";}s:5:"attrs";a:4:{s:4:"idd1";i:1;s:4:"str1";i:7;s:8:"@groupby";i:1;s:6:"@count";i:1;}s:7:"matches";a:3:{i:7;a:2:{s:6:"weight";s:4:"1513";s:5:"attrs";a:4:{s:4:"idd1";s:1:"1";s:4:"str1";s:3:"a a";s:8:"@groupby";s:1:"1";s:6:"@count";s:1:"2";}}i:5;a:2:{s:6:"weight";s:4:"1558";s:5:"attrs";a:4:{s:4:"idd1";s:1:"3";s:4:"str1";s:3:"a a";s:8:"@groupby";s:1:"3";s:6:"@count";s:1:"2";}}i:3;a:2:{s:6:"weight";s:4:"1500";s:5:"attrs";a:4:{s:4:"idd1";s:2:"11";s:4:"str1";s:3:"a a";s:8:"@groupby";s:2:"11";s:6:"@count";s:1:"3";}}}s:5:"total";s:1:"3";s:11:"total_found";s:1:"3";s:4:"time";s:5:"0.003";s:5:"words";a:3:{s:3:"the";a:2:{s:4:"docs";s:1:"5";s:4:"hits";s:1:"5";}s:3:"dog";a:2:{s:4:"docs";s:1:"2";s:4:"hits";s:1:"2";}s:3:"cat";a:2:{s:4:"docs";s:1:"4";s:4:"hits";s:1:"4";}}s:8:"resarray";i:0;s:8:"roundoff";i:0;s:5:"query";s:15:"the | dog | cat";}i:3;a:13:{s:5:"error";s:0:"";s:7:"warning";s:0:"";s:6:"status";i:0;s:6:"fields";a:1:{i:0;s:4:"body";}s:5:"attrs";a:4:{s:4:"idd1";i:1;s:4:"str1";i:7;s:8:"@groupby";i:1;s:6:"@count";i:1;}s:7:"matches";a:3:{i:6;a:2:{s:6:"weight";s:4:"1527";s:5:"attrs";a:4:{s:4:"idd1";s:1:"1";s:4:"str1";s:4:"c cc";s:8:"@groupby";s:1:"1";s:6:"@count";s:1:"4";}}i:9;a:2:{s:6:"weight";s:4:"1500";s:5:"attrs";a:4:{s:4:"idd1";s:1:"3";s:4:"str1";s:4:"c cc";s:8:"@groupby";s:1:"3";s:6:"@count";s:1:"2";}}i:4;a:2:{s:6:"weight";s:4:"2555";s:5:"attrs";a:4:{s:4:"idd1";s:2:"11";s:4:"str1";s:4:"cc c";s:8:"@groupby";s:2:"11";s:6:"@count";s:1:"3";}}}s:5:"total";s:1:"3";s:11:"total_found";s:1:"3";s:4:"time";s:5:"0.002";s:5:"words";a:3:{s:3:"the";a:2:{s:4:"docs";s:1:"5";s:4:"hits";s:1:"5";}s:4:"eats";a:2:{s:4:"docs";s:1:"3";s:4:"hits";s:1:"3";}s:4:"bird";a:2:{s:4:"docs";s:1:"3";s:4:"hits";s:1:"3";}}s:8:"resarray";i:0;s:8:"roundoff";i:0;s:5:"query";s:17:"the | eats | bird";}i:4;a:3:{s:8:"sphinxql";s:64:"select * from plain group by idd1 within group order by str1 asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:1:"3";s:4:"idd1";s:2:"11";s:4:"str1";s:3:"a a";}i:1;a:3:{s:2:"id";s:1:"5";s:4:"idd1";s:1:"3";s:4:"str1";s:3:"a a";}i:2;a:3:{s:2:"id";s:1:"7";s:4:"idd1";s:1:"1";s:4:"str1";s:3:"a a";}}}i:5;a:3:{s:8:"sphinxql";s:65:"select * from plain group by idd1 within group order by str1 desc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:1:"4";s:4:"idd1";s:2:"11";s:4:"str1";s:4:"cc c";}i:1;a:3:{s:2:"id";s:1:"6";s:4:"idd1";s:1:"1";s:4:"str1";s:4:"c cc";}i:2;a:3:{s:2:"id";s:1:"9";s:4:"idd1";s:1:"3";s:4:"str1";s:4:"c cc";}}}i:6;a:3:{s:8:"sphinxql";s:95:"select * from plain where match('the | dog | cat') group by idd1 within group order by str1 asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:1:"5";s:4:"idd1";s:1:"3";s:4:"str1";s:3:"a a";}i:1;a:3:{s:2:"id";s:1:"7";s:4:"idd1";s:1:"1";s:4:"str1";s:3:"a a";}i:2;a:3:{s:2:"id";s:1:"3";s:4:"idd1";s:2:"11";s:4:"str1";s:3:"a a";}}}i:7;a:3:{s:8:"sphinxql";s:98:"select * from plain where match('the | eats | bird') group by idd1 within group order by str1 desc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:1:"4";s:4:"idd1";s:2:"11";s:4:"str1";s:4:"cc c";}i:1;a:3:{s:2:"id";s:1:"6";s:4:"idd1";s:1:"1";s:4:"str1";s:4:"c cc";}i:2;a:3:{s:2:"id";s:1:"9";s:4:"idd1";s:1:"3";s:4:"str1";s:4:"c cc";}}}i:8;a:3:{s:8:"sphinxql";s:115:"select *, group_concat(id) from plain where match('the | eats | bird') group by idd1 within group order by str1 asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:4:{s:2:"id";s:1:"3";s:4:"idd1";s:2:"11";s:4:"str1";s:3:"a a";s:16:"group_concat(id)";s:5:"2,3,4";}i:1;a:4:{s:2:"id";s:1:"5";s:4:"idd1";s:1:"3";s:4:"str1";s:3:"a a";s:16:"group_concat(id)";s:3:"5,9";}i:2;a:4:{s:2:"id";s:1:"7";s:4:"idd1";s:1:"1";s:4:"str1";s:3:"a a";s:16:"group_concat(id)";s:7:"1,6,7,8";}}}i:9;a:3:{s:8:"sphinxql";s:181:"select * from ( select *, sum(id) as s1, sum(idd1) as s2, group_concat(id) from plain where match('the | eats | bird') group by idd1 within group order by str1 asc ) order by s1 asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:6:{s:2:"id";s:1:"3";s:4:"idd1";s:2:"11";s:4:"str1";s:3:"a a";s:2:"s1";s:1:"9";s:2:"s2";s:2:"33";s:16:"group_concat(id)";s:5:"2,3,4";}i:1;a:6:{s:2:"id";s:1:"5";s:4:"idd1";s:1:"3";s:4:"str1";s:3:"a a";s:2:"s1";s:2:"14";s:2:"s2";s:1:"6";s:16:"group_concat(id)";s:3:"5,9";}i:2;a:6:{s:2:"id";s:1:"7";s:4:"idd1";s:1:"1";s:4:"str1";s:3:"a a";s:2:"s1";s:2:"22";s:2:"s2";s:1:"4";s:16:"group_concat(id)";s:7:"1,6,7,8";}}}i:10;a:3:{s:8:"sphinxql";s:195:"select * from ( select *, sum(id) as s1, sum(idd1) as s2, s1+s2 as s3, group_concat(id) from plain where match('the | eats | bird') group by idd1 within group order by str1 asc ) order by s1 desc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:7:{s:2:"id";s:1:"7";s:4:"idd1";s:1:"1";s:4:"str1";s:3:"a a";s:2:"s1";s:2:"22";s:2:"s2";s:1:"4";s:2:"s3";s:2:"26";s:16:"group_concat(id)";s:7:"1,6,7,8";}i:1;a:7:{s:2:"id";s:1:"5";s:4:"idd1";s:1:"3";s:4:"str1";s:3:"a a";s:2:"s1";s:2:"14";s:2:"s2";s:1:"6";s:2:"s3";s:2:"20";s:16:"group_concat(id)";s:3:"5,9";}i:2;a:7:{s:2:"id";s:1:"3";s:4:"idd1";s:2:"11";s:4:"str1";s:3:"a a";s:2:"s1";s:1:"9";s:2:"s2";s:2:"33";s:2:"s3";s:2:"42";s:16:"group_concat(id)";s:5:"2,3,4";}}}i:11;a:3:{s:8:"sphinxql";s:195:"select * from ( select *, sum(id) as s1, sum(idd1) as s2, s1+s2 as s3, group_concat(id) from plain where match('the | eats | bird') group by idd1 within group order by str1 asc ) order by s2 desc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:7:{s:2:"id";s:1:"3";s:4:"idd1";s:2:"11";s:4:"str1";s:3:"a a";s:2:"s1";s:1:"9";s:2:"s2";s:2:"33";s:2:"s3";s:2:"42";s:16:"group_concat(id)";s:5:"2,3,4";}i:1;a:7:{s:2:"id";s:1:"5";s:4:"idd1";s:1:"3";s:4:"str1";s:3:"a a";s:2:"s1";s:2:"14";s:2:"s2";s:1:"6";s:2:"s3";s:2:"20";s:16:"group_concat(id)";s:3:"5,9";}i:2;a:7:{s:2:"id";s:1:"7";s:4:"idd1";s:1:"1";s:4:"str1";s:3:"a a";s:2:"s1";s:2:"22";s:2:"s2";s:1:"4";s:2:"s3";s:2:"26";s:16:"group_concat(id)";s:7:"1,6,7,8";}}}i:12;a:3:{s:8:"sphinxql";s:195:"select * from ( select *, sum(id) as s1, sum(idd1) as s2, s1+s2 as s3, group_concat(id) from plain where match('the | eats | bird') group by idd1 within group order by str1 asc ) order by s3 desc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:7:{s:2:"id";s:1:"3";s:4:"idd1";s:2:"11";s:4:"str1";s:3:"a a";s:2:"s1";s:1:"9";s:2:"s2";s:2:"33";s:2:"s3";s:2:"42";s:16:"group_concat(id)";s:5:"2,3,4";}i:1;a:7:{s:2:"id";s:1:"7";s:4:"idd1";s:1:"1";s:4:"str1";s:3:"a a";s:2:"s1";s:2:"22";s:2:"s2";s:1:"4";s:2:"s3";s:2:"26";s:16:"group_concat(id)";s:7:"1,6,7,8";}i:2;a:7:{s:2:"id";s:1:"5";s:4:"idd1";s:1:"3";s:4:"str1";s:3:"a a";s:2:"s1";s:2:"14";s:2:"s2";s:1:"6";s:2:"s3";s:2:"20";s:16:"group_concat(id)";s:3:"5,9";}}}i:13;a:2:{s:8:"sphinxql";s:325:"
INSERT INTO rt (id, idd1, str1, body) VALUES
( 1, 1,		'a aa',		'the dog' ),
( 2, 11,	'c cc',		'the cat' ),
( 3, 11,	'a a',		'the bird' ), 
( 4, 11,	'cc c',		'cat eats bird' ),
( 5, 3, 	'a a',		'dog eats cat' ), 
( 6, 1,		'c cc',		'bird' ), 
( 7, 1,		'a a',		'the cat' ),
( 8, 1,		'a a',		'eats' ),
( 9, 3, 	'c cc',		'the' )
";s:14:"total_affected";i:9;}i:14;a:3:{s:8:"sphinxql";s:160:"select *, sum(id) as s1, sum(idd1) as s2, s1+s2 as s3, group_concat(id) from plain where match('the | eats | bird') group by idd1 within group order by str1 asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:7:{s:2:"id";s:1:"3";s:4:"idd1";s:2:"11";s:4:"str1";s:3:"a a";s:2:"s1";s:1:"9";s:2:"s2";s:2:"33";s:2:"s3";s:2:"42";s:16:"group_concat(id)";s:5:"2,3,4";}i:1;a:7:{s:2:"id";s:1:"5";s:4:"idd1";s:1:"3";s:4:"str1";s:3:"a a";s:2:"s1";s:2:"14";s:2:"s2";s:1:"6";s:2:"s3";s:2:"20";s:16:"group_concat(id)";s:3:"5,9";}i:2;a:7:{s:2:"id";s:1:"7";s:4:"idd1";s:1:"1";s:4:"str1";s:3:"a a";s:2:"s1";s:2:"22";s:2:"s2";s:1:"4";s:2:"s3";s:2:"26";s:16:"group_concat(id)";s:7:"1,6,7,8";}}}i:15;a:3:{s:8:"sphinxql";s:160:"select *, sum(id) as s1, sum(idd1) as s2, s1+s2 as s3, group_concat(id) from rt    where match('the | eats | bird') group by idd1 within group order by str1 asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:7:{s:2:"id";s:1:"3";s:4:"idd1";s:2:"11";s:4:"str1";s:3:"a a";s:2:"s1";s:1:"9";s:2:"s2";s:2:"33";s:2:"s3";s:2:"42";s:16:"group_concat(id)";s:5:"2,3,4";}i:1;a:7:{s:2:"id";s:1:"5";s:4:"idd1";s:1:"3";s:4:"str1";s:3:"a a";s:2:"s1";s:2:"14";s:2:"s2";s:1:"6";s:2:"s3";s:2:"20";s:16:"group_concat(id)";s:3:"5,9";}i:2;a:7:{s:2:"id";s:1:"7";s:4:"idd1";s:1:"1";s:4:"str1";s:3:"a a";s:2:"s1";s:2:"22";s:2:"s2";s:1:"4";s:2:"s3";s:2:"26";s:16:"group_concat(id)";s:7:"1,6,7,8";}}}}}