select count(products.id) as num,manufact,size1,size2,size3,size4,size5,size6,picture.file as picid from products,company left join picture on company.id=picture.parentid and picture.topic='company' and picture.pictureid=0 and picture.status>0 where products.status>0 and products.manufact=company.id and actuality>0 and products.create_time>'2026-09-02 00:00:00' group by manufact,size1,size2,size3,size4,size5,size6 order by company.company
Unknown column 'size1' in 'SELECT'