sql 聚合使用方法-草稿

<?php

if (!defined('IN_IA')) {
	exit('Access Denied');
}

class Recommend_EweiShopV2Page extends WebPage
{
	public function main()
	{
		global $_W;
		global $_GPC;
		$page = $_GPC['page']?$_GPC['page']:1;
		$pindex = max(1, intval($page));
		$psize = 20;
		$condition  = [];

		$start = $_GPC['time']['start']?$_GPC['time']['start'].':00':'';
		$end = $_GPC['time']['end']?$_GPC['time']['end'].':59':'';

		$startTime = $start ? strtotime($start) : 0;
		$endTime =  $end ? strtotime($end) : time();

		$startPrice = $_GPC['startPrice'] ? (float)$_GPC['startPrice'] : 0.01;
		$endPrice = $_GPC['endPrice'] ? (float)$_GPC['endPrice'] : 9999999999;

		var_dump($startTime);
		var_dump($endTime);
		var_dump($startPrice);
		var_dump($endPrice);
		exit();

		$sql1 =