Неверный запрос select id, valuetext, short_url from par_values where idpar=66 AND id in (SELECT distinct pd.valueint FROM `par_data` pd, goods g WHERE pd.idgood = g.id and pd.idpar=66 and g.avail>0) order by ord