A legújabb ügyek listája
Jelenleg nincs megjeleníthető ügy!
Select TOP 100 is_id,case ISNULL(pc.pc_city,'') when '' then is_description else pc.pc_city+': '+is_description end as is_description, is_release, SUBSTRING(dbo.f_StripHTML(is_blog),1,220)+'...' as is_blog, (Select top 1 img_filename from ah_images where img_is_id = is_id and img_active = 1 and img_filename is not null) as is_imgurl, is_created FROM ah_issue ai LEFT join ah_postcodes pc ON ai.is_postcode=pc.pc_postalcode WHERE is_publicid<3 and is_isstandpoint=0 and LTRIM(ISNULL(is_description,''))<>'' and is_status not in ('TOR','DEL','LEZ','IND') ORDER BY is_release desc IssueNews failed! [Object reference not set to an instance of an object.]
Részletes kereső további ügyek megjelenítéséhez