[user1]

My mistake. I used wrong variables for the table names. The

AND main = 'Y'

change doesn't matter.

So, try this:

$prods = func_query("SELECT * FROM $sql_tbl[clean_urls], $sql_tbl[products_categories], $sql_tbl[products], $sql_tbl[categories] WHERE xcart_clean_urls.resource_type = 'P' AND xcart_products.productid = xcart_clean_urls.resource_id AND main = 'Y' AND xcart_products.productid = xcart_products_categories.productid AND xcart_products.forsale = 'Y' AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.avail = 'Y'");

This must be correct.

Andreas