Mysql eilute. Reik kad imtu

Sveiki, kaip galima butu idet iterpt i sia eilute koda, kad naujienas rodytu pvz nuo vakarykstes ar dar senesnes dienos ?

	    $query = 'SELECT a.*,CASE WHEN CHAR_LENGTH(a.alias) THEN  CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
			CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(":", b.id, b.alias) ELSE b.id END as catslug,
			b.title as category_title, b.alias as categoryalias, b.params as categoryparams,u.name AS author
			FROM #__content as a left join #__categories as b
			ON a.catid = b.id
			LEFT JOIN #__users AS u ON u.id = a.created_by
			where '.$where. ' order by '. $orderby. " limit ".$limit;

' AND ((TO_DAYS(' . $db->Quote(date('Y-m-d',time()+$mainframe->getCfg('offset')*60*60 )) . ') - TO_DAYS(a.created)) <= ' . $db->Quote($period) . ')'.

Cia radau kitam moduly sita, gal iseitu sita iterp kaip nors i pirma koda?

Aciu uz bet kokius atsakymus ;)

Žiūrint kaip saugoma data duomenų bazėj, bet kažkas tokio turėtų būt.

        
$date = date('Y-m-d', mktime(0, 0, 0, date("m")  , date("d")-1, date("Y")));
$query = 'SELECT a.*,CASE WHEN CHAR_LENGTH(a.alias) THEN  CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
			CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(":", b.id, b.alias) ELSE b.id END as catslug,
			b.title as category_title, b.alias as categoryalias, b.params as categoryparams,u.name AS author
			FROM #__content as a left join #__categories as b
			ON a.catid = b.id
			LEFT JOIN #__users AS u ON u.id = a.created_by
			WHERE datos_field_pavadinimas >= '.$date.'  '.$where. ' order by '. $orderby. " limit ".$limit;