[mattstyle2]

nice mod.. for old xcart versions and people using wcm_cdseo, change the query and first part of the foreach sections to this:

$images_D = db_query("
SELECT * FROM $sql_tbl[products] 
INNER JOIN $sql_tbl[images_D] ON $sql_tbl[products].productid = $sql_tbl[images_D].id 
WHERE forsale='Y' ORDER BY productid DESC LIMIT $products_limit
");

while ($row = db_fetch_array($images_D)) {
  $results[] = $row;
}

foreach ($results as $result){

	//$clean_url = $result['clean_url'] . $product_urls_extension;

	$pid=$result['productid'];
	$cdseo_url = func_query_first_cell("SELECT cdseoUrl FROM wcm_cdseo WHERE cdseoReplaceID='$pid' AND cdseoType='product'");
	if ($cdseo_url!='') {
		$cdseo_url.=".html";
		$clean_url=$cdseo_url;
	} else {
		continue;
	}

you have to do that for the images_p and images_t sections too.

-Matt