Posted to tcl by colin at Tue Apr 27 00:22:02 GMT 2010view pretty

"pages_gt_date_with_content"            { set sql {SELECT * 
		                                                   FROM pages a, pages_content b 
		                                                   WHERE a.id = b.id 
		                                                   AND a.date > :date 
                                                                   AND length(b.content) > 1
                                                                   ORDER BY a.date DESC} }