select masina_id,m.user_id,masina_model2,masina_cmc,m.tip,m.marca_id,m.sectiune,masina_model,combustibil,marca.marca_text,m.culoare_id,culoare_text,
id_judet,judet.nume,to_char(masina_datafab, 'MM/YYYY') as masina_datafab2,
CASE
WHEN valuta=0 THEN pret/0
WHEN valuta=2 THEN pret*0/0
ELSE pret
END as pret1,
CASE
WHEN tip_putere=1 THEN masina_kw
ELSE ( masina_kw / 0.7457)
END as masina_kw,
masina_km,tip_putere,masina_noua,culoare_alta from masina m left join utilizator u on u.user_id=m.user_id left join marca on marca.marca_id=m.marca_id left join culoare on m.culoare_id=culoare.culoare_id left join judet on m.id_judet=judet.idjudet where 1=1 AND (CASE
WHEN valuta=0 THEN pret/0
WHEN valuta=2 THEN pret*0/0
ELSE pret
END)>=0
AND (CASE
WHEN valuta=0 THEN pret/0
WHEN valuta=2 THEN pret*0/0
ELSE pret
END)<=9999999
AND masina_km >=0
AND masina_km <= 9999999
AND (CASE
WHEN tip_putere=1 THEN masina_kw
ELSE ( masina_kw / 0.7457)
END) >=0
AND (CASE
WHEN tip_putere=1 THEN masina_kw
ELSE ( masina_kw / 0.7457)
END) <= 99999 AND TO_CHAR( masina_datafab,'YYYY' ) >= 1900
AND TO_CHAR( masina_datafab,'YYYY' ) <= 5000
AND m.marca_id = marca.marca_id
AND data_vanzare IS NULL AND activ='1' AND m.sectiune=4 ORDER BY pret1 LIMIT 10 OFFSET (0*10)
ERROR: division by zero