Неверный запрос Select DISTINCT(pv.valuetext), p.name, p.id, PD.valueint, pv.titlename, p.titleord, p.viewcollapsed FROM roll_par_values pv, roll_params p, roll_store_goods g, roll_par_data PD WHERE p.podbor=1 AND g.idmenu=1 AND PD.idgood=g.id AND PD.valueint=pv.id AND PD.idpar=pv.idpar AND p.id=PD.idpar and p.tip=2 and g.qnt>0 ORDER By p.ord, p.id, pv.ord,pv.id