Азина-М.-Сибиряка - Шевченко-Свердлова оч.4.1.2
|
select p.id as value, p.p_name as text,case when p_shortDesc = '' then ' ' else p_shortdesc end as q, p_comment from Pictures p inner join PictureTypes pt on p.pt_id = pt.pt_id where house_id = 3307 and Ap_ID = 0 and pt_alias = 'map' and p_deleted = 0 order by first_Pic desc, p_sort,ID desc
<< Вернуться к описанию дома
|