$col = "T1.product_id, T1.product_name as name, T3.main_list_image, COUNT(*) as order_count, T1.price";
$from = "dtb_order_detail AS T1
INNER JOIN dtb_order AS T2 ON T1.order_id = T2.order_id
INNER JOIN dtb_products AS T3 ON T1.product_id = T3.product_id";
$objQuery->setwhere("T3.status = 1 AND T3.del_flg = 0" );
$objQuery->setGroupBy("T1.product_id, T1.product_name, T3.main_list_image");
$objQuery->setOrder("order_count DESC");
$objQuery->setLimit(5);

$objQuery->setwhere("T3.status = 1 AND T3.del_flg = 0" );

$objQuery->setWhere("T3.status = 1 AND T3.del_flg = 0" AND create_date > DATE_ADD(NOW(),INTERVAL -7 DAYS) );

$objQuery->setWhere("T3.status = 1 AND T3.del_flg = 0 AND create_date > DATE_ADD( NOW(),INTERVAL -7 DAYS )" );

// ランキング検索
function lfGetRanking(){
$objQuery = new SC_Query();

$col = "T1.product_id, T1.product_name as name, T3.main_list_image, COUNT(*) as order_count, T1.price";
$from = "dtb_order_detail AS T1
INNER JOIN dtb_order AS T2 ON T1.order_id = T2.order_id
INNER JOIN dtb_products AS T3 ON T1.product_id = T3.product_id";
$objQuery->setWhere("T3.status = 1 AND T3.del_flg = 0 AND create_date > DATE_ADD( NOW(),INTERVAL -7 DAYS )" );
$objQuery->setGroupBy("T1.product_id, T1.product_name, T3.main_list_image");
$objQuery->setOrder("order_count DESC");
$objQuery->setLimit(5);

return $objQuery->select($col, $from);
}

Column 'create_date' in where clause is ambiguous

// ランキング検索
function lfGetRanking(){
$objQuery = new SC_Query();

$col = "T1.product_id, T1.product_name as name, T3.main_list_image, COUNT(*) as order_count, T1.price, dtb_order";
$from = "dtb_order.dtb_order_detail AS T1
INNER JOIN dtb_order AS T2 ON T1.order_id = T2.order_id
INNER JOIN dtb_products AS T3 ON T1.product_id = T3.product_id";
$objQuery->setWhere("T3.status = 1 AND T3.del_flg = 0 AND dtb_order.create_date > DATE_ADD( NOW(),INTERVAL -7 DAY )" );
$objQuery->setGroupBy("T1.product_id, T1.product_name, T3.main_list_image");
$objQuery->setOrder("order_count DESC");
$objQuery->setLimit(5);

return $objQuery->select($col, $from);
}

[Native message: SELECT command denied to user '****'@'****' for table 'dtb_order_detail']

$col = "T1.product_id, T1.product_name as name, T3.main_list_image, COUNT(*) as order_count, T1.price";
$from = "dtb_order_detail AS T1
INNER JOIN dtb_order AS T2 ON T1.order_id = T2.order_id
INNER JOIN dtb_products AS T3 ON T1.product_id = T3.product_id";
$objQuery->setWhere("T3.status = 1 AND T3.del_flg = 0 AND T2.create_date > DATE_ADD( NOW(),INTERVAL -7 DAY )" );
$objQuery->setGroupBy("T1.product_id");
$objQuery->setOrder("order_count DESC");
$objQuery->setLimit(5);

function lfGetRanking(){
$objQuery = new SC_Query();
$query = '
SELECT
	T1.product_id, T1.product_name as name, T3.main_list_image, COUNT(*) as order_count, T1.price
FROM
	(
		SELECT
			order_id
		FROM
			dtb_order
		WHERE
			create_date > DATE_ADD( NOW(),INTERVAL -7 DAY )
	) T2 INNER JOIN
	dtb_order_detail T1 ON(T2.order_id = T1.order_id) INNER JOIN
	dtb_products AS T3 ON T1.product_id = T3.product_id
WHERE
	T3.status = 1 AND 
	T3.del_flg = 0 
GROUP BY
	T1.product_id
ORDER BY
	order_count DESC
LIMIT 5
';

	
return $objQuery->getAll($query);
}

$objQuery->setWhere("T3.status = 1 AND T3.del_flg = 0 AND T2.create_date > DATE_ADD( NOW(),INTERVAL -7 DAY )" );