#ifndef hArtistRoyaltyRunSaleTable
#define hArtistRoyaltyRunSaleTable

#include "PackedTable.h"
#include "SaleTable.h"


class ArtistRoyaltyRunSaleTable : public SaleTable
{
protected:
    virtual const char* _dataQueryString() 
    { 
    // !!! Ok, we've got a problem here.  This query is seemingly broken, and is causing
    // !!! the db to never come back.
//        return "SELECT sale_id,date_end,product_type,format_type,media_type,units,price,sales,returns,total_revenue,channel,lic_track_id,product_id FROM sale WHERE mechanical_royalty_status<>2 AND file_id in (select file_id from file where period_id>0 AND service_id NOT IN (select service_id from service where exclude_mechanicals = 1)) AND free<>1 AND ( (product_type IN ('1','2','4','7','9','B','C','D','P','U')) OR (product_type IN ('T','A')  AND format_type IN ('D', 'P', 'E', 'H', 'R')  AND (units < 0 ||price<>0))) ORDER BY sale_id";
//        return "SELECT sale_id,date_end,product_type,format_type,media_type,units,price,sales,returns,total_revenue,channel,lic_track_id,product_id FROM sale WHERE artist_royalty_status<>2 AND file_id in (select file_id from file where period_id > 0) AND free<>1 AND product_type not in ('L') AND ( price <> 0 or product_type not in ('T', 'A'))";
        return  "SELECT sale_id,date_end,product_type,format_type,media_type,units,price,sales,returns,total_revenue,channel,lic_track_id,product_id,country_code,price_level,average_price,wholesale_price,retail_price,artist_royalty_status,file_id FROM sale WHERE artist_royalty_status<>2 AND file_id in (select file_id from file where period_id > 0) AND free<>1 AND product_type not in ('L') AND ( price <> 0 or product_type not in ('T', 'A')) ORDER BY sale_id"; 

    }
};

#endif