export const deletedLinesSql = (alias: string) => { return ` (SELECT sum(CNT) AS "DELETED_COUNT" FROM ( SELECT COUNT("sli"."SID") "CNT" FROM data_file "df1" LEFT JOIN sales_line_item "sli" ON "sli"."DATA_FILE_SID" = "df1"."SID" AND "sli"."CUSTOMER_SID" = "df1"."CUSTOMER_SID" AND "sli"."DELETED" = 1 AND "sli"."RESUBMITTED" = 0 WHERE "df1"."SID" = ${alias}."SID" AND "df1"."CUSTOMER_SID" = ${alias}."CUSTOMER_SID" GROUP BY "df1"."SID" UNION ALL SELECT COUNT("ili"."SID") "CNT" FROM data_file "df1" LEFT JOIN inv_line_item "ili" ON "ili"."DATA_FILE_SID" = "df1"."SID" AND "ili"."CUSTOMER_SID" = "df1"."CUSTOMER_SID" AND "ili"."DELETED" = 1 AND "ili"."RESUBMITTED" = 0 WHERE "df1"."SID" = ${alias}."SID" and "df1"."CUSTOMER_SID" = ${alias}."CUSTOMER_SID" group by "df1"."SID" )) `; };