select content.family,title,threadtitle,uk_pricegrabber,ccd_size_physical,ccd_count,optical_zoom,still_resolution_dimensions_max,lcd_size,content.lowprice,uk_2009_rubric_pro.id,rs_spec_total,high_def from content,uk_2009_rubric_pro,uk_ratings_totals,uk_spec_type,uk_leads where uk_catid= and catid= and active=1 and rs_spec_type_id=stype_id and rs_spec_id=uk_2009_rubric_pro.id and stype_table_name='uk_2009_rubric_pro' and releasedate < NOW() and uk_pricegrabber=pg_id and pg_id!='' and leadtype=1 and recentfeature=0 and contentfamilyid=family order by releasedate desc<br>