1
|
a:1:{i:0;a:3:{i:0;a:3:{s:8:"sphinxql";s:85:"SELECT *, AVG(price) AS p FROM test GROUP BY gid ORDER BY p DESC option max_matches=2";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:4:{s:2:"id";s:1:"4";s:3:"gid";s:1:"3";s:5:"price";s:2:"30";s:1:"p";s:9:"30.000000";}i:1;a:4:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:5:"price";s:2:"15";s:1:"p";s:9:"15.000000";}}}i:1;a:3:{s:8:"sphinxql";s:84:"SELECT *, AVG(price) AS p FROM test GROUP BY gid ORDER BY p ASC option max_matches=2";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:4:{s:2:"id";s:2:"10";s:3:"gid";s:1:"5";s:5:"price";s:1:"1";s:1:"p";s:8:"1.000000";}i:1;a:4:{s:2:"id";s:2:"11";s:3:"gid";s:1:"6";s:5:"price";s:1:"2";s:1:"p";s:8:"2.000000";}}}i:2;a:3:{s:8:"sphinxql";s:98:"SELECT *, AVG(price) AS p FROM test WHERE price>4 GROUP BY gid ORDER BY p ASC option max_matches=2";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:4:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:5:"price";s:1:"5";s:1:"p";s:8:"5.000000";}i:1;a:4:{s:2:"id";s:2:"14";s:3:"gid";s:1:"9";s:5:"price";s:1:"5";s:1:"p";s:8:"5.000000";}}}}}
|