.sum) FROM payment_schedule_cover AS psc2 WHERE psc.payment_schedule_id = psc2.payment_schedule_id) ASpayment_schedule_row AS psr ON psr.payment_schedule_id = ps.id WHERE l
这个mysql查询提供了按一天中的天数和小时分组的产品销售数量(总计和total_staff)。我想要每个产品的总和和total_staff (不是按任何东西分组,而是按id进行期望)。s.staff=1 THEN 1 ELSE 0 END) as total_staffLEFT JOIN products_subCategories pscON msc.id=psc.manifSubCategory_id
LEFT JOIN