Hledání podle parametrů
Dotaz:
SELECT
price_vat
FROM
product_variant
LEFT JOIN
product
ON
product.id = product_variant.product_id
LEFT JOIN
htree T
ON
T.id = product.category_id
WHERE
product.active = 1 AND T.active = 1 AND product.is_strap = 0 AND product.is_accessory = 0
ORDER BY
price_vat DESC
LIMIT 1
Chyba: Unknown column 'product.is_strap' in 'where clause'
Chyba: Unknown column 'product.is_strap' in 'where clause'