select
pa_p_id, pa_cleanurl_nl as pa_cleanurl, pa_foto_kl, p_productnaam_nl as p_productnaam,pa_artikelnaam_nl as pa_artikelnaam,pa_tekst_kl_nl as pa_tekst_kl,pa_korting as pa_korting,sum(v_voorraad) as v_voorraad,sum(v_doorbestellen) as v_doorbestellen, pa_assort, pa_retail,pa_wholesale, pa_voorraad_type,p_productnummer, pa_artikelnummer
from crea_product, crea_voorraad
where v_p_id = pa_p_id and pa_retail = 1 and pa_assort = 1 and v_ingebruik=1 and (pa_p_id = 9065)
group by v_p_id