Aquafilter -Filtry na tvrdou vodu
| Cena |
|
1054 Unknown column 'lov.label' in 'field list'
in:
[SELECT max(value_to) as maximalni, min(value) as minimalni, pat.id, pat.name, if( lovg.id IS NULL , pat.priority, lovg.priority ) AS priority, pat.sort, u.code as unit, pa.parameters_lov_id, lovg.id AS group_id, lovg.name AS group_name, GROUP_CONCAT(DISTINCT CONCAT(lov.id, '&', lov.name, 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 = 2621 JOIN centra_miklik.parameter_types pat ON pa.parameter_types_id = pat.id JOIN centra_miklik.units u on u.id = pat.units_id LEFT OUTER JOIN centra_miklik.parameters_lov lov ON lov.id = pa.parameters_lov_id LEFT OUTER JOIN centra_miklik.parameters_lov_groups lovg ON lov.parameters_lov_groups_id = lovg.id WHERE pa.state >0 GROUP BY pat.id, lovg.id order by priority desc, sort DESC, pat.id]
in:
[SELECT max(value_to) as maximalni, min(value) as minimalni, pat.id, pat.name, if( lovg.id IS NULL , pat.priority, lovg.priority ) AS priority, pat.sort, u.code as unit, pa.parameters_lov_id, lovg.id AS group_id, lovg.name AS group_name, GROUP_CONCAT(DISTINCT CONCAT(lov.id, '&', lov.name, 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 = 2621 JOIN centra_miklik.parameter_types pat ON pa.parameter_types_id = pat.id JOIN centra_miklik.units u on u.id = pat.units_id LEFT OUTER JOIN centra_miklik.parameters_lov lov ON lov.id = pa.parameters_lov_id LEFT OUTER JOIN centra_miklik.parameters_lov_groups lovg ON lov.parameters_lov_groups_id = lovg.id WHERE pa.state >0 GROUP BY pat.id, lovg.id order by priority desc, sort DESC, pat.id]