160 Kč
675 Kč
1054 Unknown column 'lov.label' in 'field list'
[SELECT max(value_to) as maximalni, min(value) as minimalni,,, if( IS NULL , pat.priority, lovg.priority ) AS priority, pat.sort, u.code as unit, pa.parameters_lov_id, AS group_id, AS group_name, GROUP_CONCAT(DISTINCT CONCAT(, '&',, if(lov.label is null, '', CONCAT('&', lov.label))) SEPARATOR '#') AS list_name, GROUP_CONCAT(DISTINCT value) as snaps FROM centra_miklik.parameters pa INNER JOIN _miklik_products p ON p.products_id = pa.products_id AND p.state = 0 INNER JOIN _miklik_products_to_categories p2c ON pa.products_id = p2c.products_id AND p2c.categories_id = 2656 JOIN centra_miklik.parameter_types pat ON pa.parameter_types_id = JOIN centra_miklik.units u on = pat.units_id LEFT OUTER JOIN centra_miklik.parameters_lov lov ON = pa.parameters_lov_id LEFT OUTER JOIN centra_miklik.parameters_lov_groups lovg ON lov.parameters_lov_groups_id = WHERE pa.state >0 GROUP BY, order by priority desc, sort DESC,]