working: SELECT newsku.sku, newsku.name, newsku.sell_price, newsku.added, newsku.instock FROM reports.rep_new_skus newsku JOIN reports.rep_skusum_bigsku bigsku ON newsku.sku=bigsku.sku WHERE timestamp>='2007-12-01' order by newsku.added desc; broken: SELECT newsku.sku, newsku.name, newsku.sell_price, newsku.added, newsku.instock FROM reports.rep_new_skus newsku JOIN reports.rep_skusum_bigsku bigsku ON newsku.sku=bigsku.sku WHERE timestamp>='2007-12-01' order by reports.rep_new_skus.added desc;