Random med flera villkor

Den här frågan tar ut de 25 nyaste produkterna (Mysql, php)

$wt_query = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by products_date_added desc limit " . 25);

Men jag skulle vilja kunna sortera resultatet en gång till typ ORDER BY RAND() LIMIT 4. Jag får inte till det.

Tänkte lite galet där, det är ju enklare att sätta ena villkoret i "where" kommandot.

  $wt_query = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = pd.products_id and p.products_date_added >= date_add(curdate(), interval -1 month) and pd.language_id = '" . (int)$languages_id . "'  order by  RAND() limit " . 4);