我试图声明变量并按如下方式运行查询:
$sql = "SELECT @dateconsult := (YEARWEEK('2018-10-01',3)),
@countunits := ( SELECT COUNT(s.id_production)
FROM sw_sowing
WHERE status != 0
AND YEARWEEK(date,3) <= @dateconsult
GROUP BY id_production_unit_detail
),
@quadrants := ( SELECT DISTINCT value
FROM cf_config
WHERE parameter = 'PLANTHEALTH'
);
SELECT FORMAT(((count_quadrant * 100)/(total_units * Cuadrantes)),3) AS incidence
FROM (
SELECT @countunits AS total_units, @quadrants AS Cuadrantes,
FROM ph_planthealth
INNER JOIN ph_planthealth_detail ON ph_planthealth_detail.id_p = ph_planthealth.id
WHERE YEARWEEK(ph_planthealth.date,3) = @dateconsult
AND ph_planthealth.status = 200
AND ph_planthealth.id_tenant = 1
AND ph_planthealth_detail.id_plague != 0
GROUP BY ph_planthealth_detail.id_plague
) AS s
ORDER BY incidence DESC; ";
$plague = $this->db->fetchAll($sql, Phalcon\Db::FETCH_ASSOC, $options) ";
问题是它显示了第一个select的结果,这是我声明的变量,而不是第二个select的结果,后者是主查询。
这是我第一次声明变量,我不知道我是否做得对。
我感谢你对这个主题的评论和帮助。
1条答案
按热度按时间disho6za1#
不需要在单独的环境中进行变量赋值
SELECT
. 您可以通过加入主查询来完成这些操作。