+---------------------------------------------------------------------------------------------------+
| mal                                                                                               |
+===================================================================================================+
| function user.s24_5{autoCommit=true}(A0:int,A1:int):void;                                         |
|     X_4 := sql.mvc();                                                                             |
|     X_8 := sql.bind(X_4,"msearch_stats_db","tableName","client_id",0);              |
|     X_16 := sql.bind(X_4,"msearch_stats_db","tableName","vendor_id",0);             |
|     X_5:bat[:oid,:oid]  := sql.tid(X_4,"msearch_stats_db","tableName");             |
|     X_56 := algebra.subselect(X_16,X_5,A1,A1,true,true,false);                                    |
|     (X_18,r1_23) := sql.bind(X_4,"msearch_stats_db","tableName","vendor_id",2);     |
|     X_57 := algebra.subselect(r1_23,A1,A1,true,true,false);                                       |
|     X_20 := sql.bind(X_4,"msearch_stats_db","tableName","vendor_id",1);             |
|     X_58 := algebra.subselect(X_20,X_5,A1,A1,true,true,false);                                    |
|     X_21 := sql.subdelta(X_56,X_18,X_57,X_58);                                                    |
|     X_59 := algebra.subselect(X_8,X_21,A0,A0,true,true,false);                                    |
|     (X_11,r1_11) := sql.bind(X_4,"msearch_stats_db","tableName","client_id",2);     |
|     X_60 := algebra.subselect(r1_11,A0,A0,true,true,false);                                       |
|     X_14 := sql.bind(X_4,"msearch_stats_db","tableName","client_id",1);             |
|     X_61 := algebra.subselect(X_14,X_21,A0,A0,true,true,false);                                   |
|     X_23 := sql.subdelta(X_59,X_11,X_60,X_61);                                                    |
|     X_24 := sql.bind(X_4,"msearch_stats_db","tableName","sokrati_sales",0);         |
|     (X_26,r1_36) := sql.bind(X_4,"msearch_stats_db","tableName","sokrati_sales",2); |
|     X_28 := sql.bind(X_4,"msearch_stats_db","tableName","sokrati_sales",1);         |
|     X_31 := sql.projectdelta(X_23,X_24,X_26,r1_36,X_28);                                          |
|     X_32 := algebra.selectNotNil(X_31);                                                           |
|     X_33 := aggr.count(X_32);                                                                     |
|     sql.exportValue(1,"msearch_stats_db.tableName","Sales","wrd",64,0,6,X_33,"");   |
| end s24_5;                                                                                        |
| # optimizer.mitosis()                                                                             |
| # optimizer.dataflow()                                                                            |
+---------------------------------------------------------------------------------------------------+
27 tuples (560.859ms)