Online PHP editor | vld for miZU7

<?php echo removeslashes("SELECT t.id_transaction, t.ts, c.campaign_name as campaign, IFNULL(sc.id_sub_campaign,0) as id_sub_campaign, IFNULL(sc.name,\"\") as sub_campaign, IFNULL(li.id_line_item,0) as id_line_item, IFNULL(li.name,\"\") as line_item, IFNULL(sc.channel_id,0) as channel_id, IFNULL(p.anonymous_name,seo_p.anonymous_name) as anonymous_name, DATE_FORMAT(tcjstat.ts_last_click,\"%Y-%m-%d %r\") AS EventTime, CASE WHEN seo_p.id_publisher is null THEN CONCAT(p.publisher_name,\" > \",pt.name) ELSE seo_p.publisher_name END as publisher, CASE WHEN (t.transaction_type = \"pps\") THEN \"Sale\" ELSE CASE WHEN (t.transaction_type = \"ppl\") THEN \"Lead\" ELSE ifNULL(t.transaction_type,\"\") END END as transaction_type, ifNULL(t.param_customerid,\"\") as customerid, ifNULL(t.param_orderid,\"\") as orderid, ifNULL(t.usessinfo,\"\") as sessionId, t.param_totalprice as totalprice, CASE WHEN (t.param_currency is null) OR (t.param_currency=\"\") THEN \"EUR\" ELSE t.param_currency END as currency, ifNULL(level_name,IFNULL(t.param_level,\"\")) as level, ifNULL(t.level_id,0) as level_id, ifNULL(level_name,\"\") as level_name, ifNULL(tcjstat.ts_last_click, tcj.ts) as ts_last_click, tcjstat.ts_first_view, CASE WHEN (iFNULL(tc.action_type,0) = 20) THEN 1 ELSE 0 END as is_postview_conversion, 0 as is_retargeting_conversion, (ifNULL(tcjstat.count_views,0) + ifNULL(tcjstat.count_postviews,0) + ifNULL(tcjstat.count_clicks,0) + ifNULL(tcjstat.count_seo,0)) as num_touchpoints, CASE WHEN ifNULL(geo_city,\"\") != \"\" AND ifNULL(geo_region,\"\") = \"\" THEN CONCAT(ifNULL(geo_country,\"\"), \" - \", ifNULL(geo_city,\"\")) ELSE CASE WHEN ifNULL(geo_city,\"\") != \"\" THEN CONCAT(ifNULL(geo_country,\"\"), \" - \", ifNULL(geo_region,\"\"), \" - \", ifNULL(geo_city,\"\")) ELSE CASE WHEN ifNULL(geo_region,\"\") != \"\" THEN CONCAT(ifNULL(geo_country,\"\"), \" - \", ifNULL(geo_region,\"\")) ELSE ifNULL(geo_country,\"\") END END END as geo, tcj.referrer as referrer, t.transaction_status_id, tch.modified_ts as ts_last_update, IFNULL(ch.channel_name,\"\") as channel_name, IFNULL(p.publisher_name,seo_p.publisher_name) as publisher_name, IFNULL(p.id_publisher,seo_p.id_publisher) as publisher_id, ifNULL(tc.network_session,\"\") as session_param, tcj.is_brand as winning_is_brand, tcj.is_content as winning_is_content, tcj.keyword as winning_keyword, tcjstat.has_blocked, tc.percentage, IFNULL(pt.name ,\"\") as publisher_trackingcode, t.param_1, t.param_2, t.param_3, t.param_4, t.param_5, t.param_6, t.param_7, t.param_8, t.param_9, t.param_comment, tcj.partnerid_param_value, tcj.cinfo, tc.ts as winning_ts, CASE WHEN td.identified_by_cookie = 1 THEN \"c\" ELSE CASE WHEN td.identified_by_fingerprint = 1 THEN \"f\" ELSE \"\" END END as identified_by, CASE WHEN tcj.position = 0 THEN \"1\" ELSE 0 END as is_temp_cj, tc.position as winning_position, CASE WHEN t.campaign_id in (263,713,724) THEN (tc.percentage * CAST(t.param_comment AS DECIMAL(10,2)))/100 ELSE (tc.percentage * CAST(t.revenue AS DECIMAL(10,2)))/100 END as winning_revenue, t.uid, tc.level_return_value, t.browser, t.winning_capping_active, ts.status as transaction_status, IFNULL(tcjstat.costs_cj,\"0.00\")+IFNULL(t.costs_wp,\"0.00\") as costs_cj, tp10.param_value as param_10, tp11.param_value as param_11, tp12.param_value as param_12, tp13.param_value as param_13, tp14.param_value as param_14, tp15.param_value as param_15, tp16.param_value as param_16, tp17.param_value as param_17, tp18.param_value as param_18, tp19.param_value as param_19, tp20.param_value as param_20, tp21.param_value as param_21, tp22.param_value as param_22, tp23.param_value as param_23, tp24.param_value as param_24, tp25.param_value as param_25, tp26.param_value as param_26, tp27.param_value as param_27, tp28.param_value as param_28, tp29.param_value as param_29, p.external_publisher_id, p.additional_id_1, p.additional_id_2, rcgt.group_name as report_custom_group_tracking FROM transaction t INNER JOIN campaign c ON c.id_campaign = t.campaign_id INNER JOIN transaction_commission tc ON tc.transaction_id = t.id_transaction AND tc.position = 1 LEFT OUTER JOIN publisher_trackingcode pt ON pt.id_publisher_trackingcode = tc.publisher_trackingcode_id LEFT OUTER JOIN publisher_assignment pa ON pa.id_publisher_assignment = pt.publisher_assignment_id LEFT OUTER JOIN publisher p ON p.id_publisher = pa.publisher_id LEFT OUTER JOIN publisher seo_p ON seo_p.id_publisher = tc.seo_id LEFT OUTER JOIN line_item li ON li.id_line_item = tc.line_item_id LEFT OUTER JOIN sub_campaign sc ON sc.id_sub_campaign = li.sub_campaign_id LEFT OUTER JOIN channel ch ON sc.channel_id = ch.id_channel LEFT OUTER JOIN report_custom_group_tracking rcgt ON rcgt.id_report_custom_group_tracking = pt.report_custom_group_tracking_id LEFT OUTER JOIN transaction_cj_stat tcjstat ON t.id_transaction = tcjstat.transaction_id LEFT OUTER JOIN transaction_debug td ON t.uid = td.uid LEFT OUTER JOIN transaction_status ts ON ts.id_transaction_status = t.transaction_status_id left outer join transaction_param tp10 on tp10.transaction_id = t.id_transaction and tp10.field_id = 10 left outer join transaction_param tp11 on tp11.transaction_id = t.id_transaction and tp11.field_id = 11 left outer join transaction_param tp12 on tp12.transaction_id = t.id_transaction and tp12.field_id = 12 left outer join transaction_param tp13 on tp13.transaction_id = t.id_transaction and tp13.field_id = 13 left outer join transaction_param tp14 on tp14.transaction_id = t.id_transaction and tp14.field_id = 14 left outer join transaction_param tp15 on tp15.transaction_id = t.id_transaction and tp15.field_id = 15 left outer join transaction_param tp16 on tp16.transaction_id = t.id_transaction and tp16.field_id = 16 left outer join transaction_param tp17 on tp17.transaction_id = t.id_transaction and tp17.field_id = 17 left outer join transaction_param tp18 on tp18.transaction_id = t.id_transaction and tp18.field_id = 18 left outer join transaction_param tp19 on tp19.transaction_id = t.id_transaction and tp19.field_id = 19 left outer join transaction_param tp20 on tp20.transaction_id = t.id_transaction and tp20.field_id = 20 left outer join transaction_param tp21 on tp21.transaction_id = t.id_transaction and tp21.field_id = 21 left outer join transaction_param tp22 on tp22.transaction_id = t.id_transaction and tp22.field_id = 22 left outer join transaction_param tp23 on tp23.transaction_id = t.id_transaction and tp23.field_id = 23 left outer join transaction_param tp24 on tp24.transaction_id = t.id_transaction and tp24.field_id = 24 left outer join transaction_param tp25 on tp25.transaction_id = t.id_transaction and tp25.field_id = 25 left outer join transaction_param tp26 on tp26.transaction_id = t.id_transaction and tp26.field_id = 26 left outer join transaction_param tp27 on tp27.transaction_id = t.id_transaction and tp27.field_id = 27 left outer join transaction_param tp28 on tp28.transaction_id = t.id_transaction and tp28.field_id = 28 left outer join transaction_param tp29 on tp29.transaction_id = t.id_transaction and tp29.field_id = 29 left outer join transaction_change tch on tch.transaction_change_id = (select transaction_change_id from transaction_change where transaction_id = t.id_transaction order by transaction_change_id desc limit 1) LEFT OUTER JOIN transaction_customerjourney tcj ON tcj.transaction_id = t.id_transaction AND tcj.action_type = tc.action_type AND tc.ts = tcj.ts AND REPLACE(REPLACE(ifNULL(tc.network_session,\"\"),\"(\",\"\"), \")\",\"\") = REPLACE(REPLACE(ifNULL(tcj.session_param_value,\"\"),\"(\",\"\"), \")\",\"\") AND ( ( tc.publisher_trackingcode_id = tcj.publisher_trackingcode_id AND tc.publisher_trackingcode_id is not null ) OR ( tc.seo_id = tcj.seo_id AND tc.seo_id is not null ) ) WHERE t.campaign_id = 741 and t.ts between \"2015-08-15 00:00:00\" and \"2015-09-17 23:59:59\" AND li.id_line_item in (-1,6496,6497,6498,6499,6500,6501,6502,6503,6542,6543,6544,6550,6551,6552,6553,6554,6555,6556,6557,6558,6559,6560,6561,6562,6563,6564,6725,6726,6727,6728,6729,6730,6731,6780,6781,6782,6791,6798,6799,6800,6801,6807,6808,6809,6810,6814,6838,6839,6840,6841,6842,6843,6844,6845,6859,6950,6984,6990,7157,7229,7231,7232,7292,7293,7294,7295,7296,7297,7298,7299,7300,7337,7341,7366,7376,7388,7406,7407,7420,7433,7459,7460,7472,7473,7475,7476,7842,8043,8233,8234,8235,9270,10779,10852,11152,11518,12194,12197,12571,12785,12825,13007,13169,13197,13198,13199,13200,13201,13240,13243,13567,13782,13879,13880,13881,14377,14649,14928,15103,15460,15634,15635,15636,15637,15638,15805,15806,15979,15980,15981,15982,15983,16019,16086,16153,16154,16155,16272,16291,16320,16595,16702,16711,16712,16714,16738,16756,16786,16787,16792,16794,17051,17068,17466,17844) AND IFNULL(p.id_publisher,seo_p.id_publisher) in (-1,5538,9824,5540,6625,8746,5539,9637,5541,5608,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,386,665,666,793,794,1738,1739,1740,1741,1742,1743,1744,1745,1746,1797,1798,1799,1800,1801,1802,1803,1804,1805,1806,1807,1808,1809,1810,1811,1812,1813,1814,1815,1816,1817,1818,1819,1820,1821,1822,1823,1824,1825,1826,1827,1828,1829,1830,1831,1832,1833,1834,1835,1836,1837,1838,1839,1840,1841,1842,1843,1844,1845,1846,1847,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,1861,1862,1863,1864,1865,1866,1867,1868,1869,1870,1871,1872,1873,1874,1875,1876,1877,1878,1879,1880,1881,1882,1883,1884,1885,1886,1887,1888,1889,1890,1891,1892,1893,1894,1895,1896,1897,1898,1899,1900,1901,1902,1903,1904,1905,1906,1907,1908,1909,1910,1911,1912,1913,1914,1915,1916,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1955,1956,1957,1958,1959,1960,1961,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085,2086,2087,2088,2089,2090,2091,2092,2093,2094,2095,2096,2097,2098,2099,2100,2101,2102,2103,2104,2105,2106,2107,2108,2109,2110,2111,2112,2113,2114,2115,2116,2117,2118,2119,2120,2121,2122,2123,2124,2125,2126,2127,2128,2129,2130,2131,2132,2133,2134,2135,2136,2137,2138,2139,2140,2141,2142,2143,2144,2145,2146,2147,2148,2149,2150,2151,2152,2153,2154,2155,2156,2157,2158,2159,2160,2161,2162,2163,2164,2165,2166,2167,2168,2169,2170,2171,2172,2173,2174,2175,2176,2177,2178,2179,2180,2181,2182,2183,2184,2185,2186,2187,2188,2189,2190,2191,2192,2193,2194,2195,2196,2197,2198,2199,2200,2201,2202,2203,2204,2205,2206,2207,2208,2209,2210,2211,2212,2213,2214,2215,2216,2217,2218,2219,2220,2221,2222,2223,2224,2225,2226,2227,2228,2229,2230,2231,2232,2233,2234,2235,2236,2237,2238,2239,2240,2241,2242,2243,2244,2245,2246,2247,2248,2249,2250,2251,2252,2253,2254,2255,2256,2257,2258,2259,2260,2261,2262,2263,2264,2265,2266,2267,2268,2269,2270,2271,2272,2273,2274,2275,2276,2277,2278,2279,2280,2281,2282,2283,2284,2285,2286,2287,2288,2289,2290,2291,2292,2293,2294,2295,2296,2297,2298,2299,2300,2301,2302,2303,2304,2305,2306,2307,2308,2309,2310,2311,2312,2313,2314,2315,2316,2317,2318,2319,2320,2321,2322,2323,2324,2325,2326,2327,2328,2329,2330,2331,2332,2333,2334,2335,2336,2337,2338,2339,2340,2341,2342,2343,2344,2345,2346,2347,2348,2349,2350,2351,2352,2353,2354,2355,2356,2357,2358,2359,2360,2361,2362,2363,2364,2365,2366,2367,2368,2369,2370,2371,2372,2373,2374,2375,2376,2377,2378,2379,2380,2381,2382,2383,2384,2385,2386,2387,2388,2389,2390,2391,2392,2393,2394,2395,2396,2397,2398,2399,2400,2401,2402,2403,2404,2405,2406,2407,2408,2409,2410,2411,2412,2413,2414,2415,2416,2417,2418,2419,2420,2421,2422,2423,2424,2425,2426,2427,2428,2429,2430,2431,2432,2433,2434,2435,2436,2437,2438,2439,2440,2441,2442,2443,2444,2445,2446,2447,2448,2449,2450,2451,2452,2453,2454,2455,2456,2457,2458,2459,2460,2461,2462,2463,2464,2465,2466,4883,4884,6202,6203,6204,6205,6206,6207,6208,6209,6210,6211,6212,6213,6214,6215,6216,6217,6218,6219,6220,6221,6222,6223,6224,6225,6226,6227,6228,6229,6230,6231,6232,6233,6234,6235,6236,6237,6238,6239,6240,6241,6242,6243,6244,6245,6246,6247,6248,6249,6250,6251,6252,6253,6254,6255,6256,6257,6258,6259,6260,6261,6262,6263,6264,6265,6266,6267,6268,6269,6270,6271,6272,6273,6274,6275,6276,6277,6278,6279,6280,6281,6282,6283,6284,6285,6286,6287,6288,6289,6290,6291,6292,6293,6294,6295,6296,6297,6298,6299,6300,6301,6302,6303,6304,6305,6306,6307,6308,6309,6310,6311,6312,6313,6314,6315,6316,6317,6318,6319,6320,6321,6322,6323,6324,6325,6326,6327,6328,6329,6330,6331,6332,6333,6334,6335,6336,6337,6338,6339,6340,6341,6342,6343,6344,6345,6346,6347,6348,6349,6350,6351,6352,6353,6354,6355,6356,6357,6358,6359,6360,6361,6362,6363,6364,6365,6366,6367,6368,6369,6370,6371,6372,6373,6374,6375,6376,6377,6378,6379,6380,6381,6382,6383,6384,6385,8685,8686,8687,8688,8689,8690,8691,8692,8693,8694,8695,8696,8697,8698,8699,5609,5567,5616,5568,1754,1753,5613,5614,5615,5620,5617,5618,5619,5621,5622,5623,5624,6156,9687,6712,6188,6479,6200,6201,6567,6484,6607,6619,6714,6774,6777,6781,6782,6783,6784,6785,6786,6837,6856,6658,6660,6661,6662,6665,6669,6675,6676,6680,6685,6701,7705,7704,8524,8525,8903,8650,8970,8204,9021,9022,9023,9043,9328,9384,9385,8203,9631,9633,9634,9690,9636,6626,9721,9803,8881,9821,9836,9517,8884,10069) ORDER BY 2 desc LIMIT 0 , 25 ");

Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/miZU7
function name:  (null)
number of ops:  5
compiled vars:  none
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
    3     0  E >   INIT_FCALL_BY_NAME                                       'removeslashes'
          1        SEND_VAL_EX                                              'SELECT++++t.id_transaction%2C++++t.ts%2C++++c.campaign_name+as+campaign%2C++++IFNULL%28sc.id_sub_campaign%2C0%29+as+id_sub_campaign%2C++++IFNULL%28sc.name%2C%22%22%29+as+sub_campaign%2C++++IFNULL%28li.id_line_item%2C0%29+as+id_line_item%2C++++IFNULL%28li.name%2C%22%22%29+as+line_item%2C++++IFNULL%28sc.channel_id%2C0%29+as+channel_id%2C++++IFNULL%28p.anonymous_name%2Cseo_p.anonymous_name%29+as+anonymous_name%2C++++DATE_FORMAT%28tcjstat.ts_last_click%2C%22%25Y-%25m-%25d+%25r%22%29+AS+EventTime%2C++++CASE+WHEN+seo_p.id_publisher+is+null+THEN+CONCAT%28p.publisher_name%2C%22+%3E+%22%2Cpt.name%29+ELSE+seo_p.publisher_name+END+as+publisher%2C++++CASE+WHEN+%28t.transaction_type+%3D+%22pps%22%29+THEN+%22Sale%22+ELSE+CASE+WHEN+%28t.transaction_type+%3D+%22ppl%22%29+THEN+%22Lead%22+ELSE+ifNULL%28t.transaction_type%2C%22%22%29+END+END+as+transaction_type%2C+++++ifNULL%28t.param_customerid%2C%22%22%29+as+customerid%2C++++ifNULL%28t.param_orderid%2C%22%22%29+as+orderid%2C++++ifNULL%28t.usessinfo%2C%22%22%29+as+sessionId%2C++++t.param_totalprice+as+totalprice%2C+++++CASE+WHEN+%28t.param_currency+is+null%29+OR+%28t.param_currency%3D%22%22%29+THEN+%22EUR%22+ELSE+t.param_currency+END+as+currency%2C++++ifNULL%28level_name%2CIFNULL%28t.param_level%2C%22%22%29%29+as+level%2C++++ifNULL%28t.level_id%2C0%29+as+level_id%2C++++ifNULL%28level_name%2C%22%22%29+as+level_name%2C++++ifNULL%28tcjstat.ts_last_click%2C+tcj.ts%29+as+ts_last_click%2C++++tcjstat.ts_first_view%2C++++CASE+WHEN+%28iFNULL%28tc.action_type%2C0%29+%3D+20%29+THEN+1+ELSE+0+END+as+is_postview_conversion%2C++++0+as+is_retargeting_conversion%2C++++%28ifNULL%28tcjstat.count_views%2C0%29+%2B+ifNULL%28tcjstat.count_postviews%2C0%29+%2B+ifNULL%28tcjstat.count_clicks%2C0%29+%2B+ifNULL%28tcjstat.count_seo%2C0%29%29+as+num_touchpoints%2C++++CASE+WHEN+ifNULL%28geo_city%2C%22%22%29+%21%3D+%22%22+AND+ifNULL%28geo_region%2C%22%22%29+%3D+%22%22+THEN+CONCAT%28ifNULL%28geo_country%2C%22%22%29%2C+%22+-+%22%2C+ifNULL%28geo_city%2C%22%22%29%29+ELSE+++++++++CASE+WHEN+ifNULL%28geo_city%2C%22%22%29+%21%3D+%22%22+THEN+CONCAT%28ifNULL%28geo_country%2C%22%22%29%2C+%22+-+%22%2C+ifNULL%28geo_region%2C%22%22%29%2C+%22+-+%22%2C+ifNULL%28geo_city%2C%22%22%29%29+ELSE+++++++++++++CASE+WHEN+ifNULL%28geo_region%2C%22%22%29+%21%3D+%22%22+THEN+CONCAT%28ifNULL%28geo_country%2C%22%22%29%2C+%22+-+%22%2C+ifNULL%28geo_region%2C%22%22%29%29+ELSE+ifNULL%28geo_country%2C%22%22%29+END+END+END+as+geo%2C++++tcj.referrer+as+referrer%2C++++t.transaction_status_id%2C++++tch.modified_ts+as+ts_last_update%2C++++IFNULL%28ch.channel_name%2C%22%22%29+as+channel_name%2C++++IFNULL%28p.publisher_name%2Cseo_p.publisher_name%29+as+publisher_name%2C++++IFNULL%28p.id_publisher%2Cseo_p.id_publisher%29+as+publisher_id%2C++++ifNULL%28tc.network_session%2C%22%22%29+as+session_param%2C++++tcj.is_brand+as+winning_is_brand%2C++++tcj.is_content+as+winning_is_content%2C++++tcj.keyword+as+winning_keyword%2C++++tcjstat.has_blocked%2C++++tc.percentage%2C++++IFNULL%28pt.name+%2C%22%22%29+as+publisher_trackingcode%2C++++t.param_1%2C++++t.param_2%2C++++t.param_3%2C++++t.param_4%2C++++t.param_5%2C++++t.param_6%2C++++t.param_7%2C++++t.param_8%2C++++t.param_9%2C++++t.param_comment%2C++++tcj.partnerid_param_value%2C++++tcj.cinfo%2C++++tc.ts+as+winning_ts%2C++++CASE+WHEN+td.identified_by_cookie+%3D+1+THEN+%22c%22+ELSE+CASE+WHEN+td.identified_by_fingerprint+%3D+1+THEN+%22f%22+ELSE+%22%22+END+END+as+identified_by%2C++++CASE+WHEN+tcj.position+%3D+0+THEN+%221%22+ELSE+0+END+as+is_temp_cj%2C++++tc.position+as+winning_position%2C++++CASE+WHEN+t.campaign_id+in+%28263%2C713%2C724%29+THEN+%28tc.percentage+%2A+CAST%28t.param_comment+AS+DECIMAL%2810%2C2%29%29%29%2F100+ELSE+%28tc.percentage+%2A+CAST%28t.revenue+AS+DECIMAL%2810%2C2%29%29%29%2F100+END+as+winning_revenue%2C++++t.uid%2C++++tc.level_return_value%2C++++t.browser%2C++++t.winning_capping_active%2C++++ts.status+as+transaction_status%2C++++IFNULL%28tcjstat.costs_cj%2C%220.00%22%29%2BIFNULL%28t.costs_wp%2C%220.00%22%29+as+costs_cj%2C++++tp10.param_value+as+param_10%2C++++tp11.param_value+as+param_11%2C++++tp12.param_value+as+param_12%2C++++tp13.param_value+as+param_13%2C++++tp14.param_value+as+param_14%2C++++tp15.param_value+as+param_15%2C++++tp16.param_value+as+param_16%2C++++tp17.param_value+as+param_17%2C++++tp18.param_value+as+param_18%2C++++tp19.param_value+as+param_19%2C++++tp20.param_value+as+param_20%2C++++tp21.param_value+as+param_21%2C++++tp22.param_value+as+param_22%2C++++tp23.param_value+as+param_23%2C++++tp24.param_value+as+param_24%2C++++tp25.param_value+as+param_25%2C++++tp26.param_value+as+param_26%2C++++tp27.param_value+as+param_27%2C++++tp28.param_value+as+param_28%2C++++tp29.param_value+as+param_29%2C++++p.external_publisher_id%2C++++p.additional_id_1%2C++++p.additional_id_2%2C++++rcgt.group_name+as+report_custom_group_tracking++FROM+transaction+t++INNER+JOIN+campaign+c+ON+c.id_campaign+%3D+t.campaign_id++INNER+JOIN+transaction_commission+tc+ON+tc.transaction_id+%3D+t.id_transaction+AND+tc.position+%3D+1++LEFT+OUTER+JOIN+publisher_trackingcode+pt+ON+pt.id_publisher_trackingcode+%3D+tc.publisher_trackingcode_id++LEFT+OUTER+JOIN+publisher_assignment+pa+ON+pa.id_publisher_assignment+%3D+pt.publisher_assignment_id++LEFT+OUTER+JOIN+publisher+p+ON+p.id_publisher+%3D+pa.publisher_id++LEFT+OUTER+JOIN+publisher+seo_p+ON+seo_p.id_publisher+%3D+tc.seo_id++LEFT+OUTER+JOIN+line_item+li+ON+li.id_line_item+%3D+tc.line_item_id++LEFT+OUTER+JOIN+sub_campaign+sc+ON+sc.id_sub_campaign+%3D+li.sub_campaign_id++LEFT+OUTER+JOIN+channel+ch+ON+sc.channel_id+%3D+ch.id_channel++LEFT+OUTER+JOIN+report_custom_group_tracking+rcgt+ON+rcgt.id_report_custom_group_tracking+%3D+pt.report_custom_group_tracking_id++LEFT+OUTER+JOIN+transaction_cj_stat+tcjstat+ON+t.id_transaction+%3D+tcjstat.transaction_id++LEFT+OUTER+JOIN+transaction_debug+td+ON+t.uid+%3D+td.uid++LEFT+OUTER+JOIN+transaction_status+ts+ON+ts.id_transaction_status+%3D+t.transaction_status_id++left+outer+join+transaction_param+tp10+on+tp10.transaction_id+%3D+t.id_transaction+and+tp10.field_id+%3D+10++left+outer+join+transaction_param+tp11+on+tp11.transaction_id+%3D+t.id_transaction+and+tp11.field_id+%3D+11++left+outer+join+transaction_param+tp12+on+tp12.transaction_id+%3D+t.id_transaction+and+tp12.field_id+%3D+12++left+outer+join+transaction_param+tp13+on+tp13.transaction_id+%3D+t.id_transaction+and+tp13.field_id+%3D+13++left+outer+join+transaction_param+tp14+on+tp14.transaction_id+%3D+t.id_transaction+and+tp14.field_id+%3D+14++left+outer+join+transaction_param+tp15+on+tp15.transaction_id+%3D+t.id_transaction+and+tp15.field_id+%3D+15++left+outer+join+transaction_param+tp16+on+tp16.transaction_id+%3D+t.id_transaction+and+tp16.field_id+%3D+16++left+outer+join+transaction_param+tp17+on+tp17.transaction_id+%3D+t.id_transaction+and+tp17.field_id+%3D+17++left+outer+join+transaction_param+tp18+on+tp18.transaction_id+%3D+t.id_transaction+and+tp18.field_id+%3D+18++left+outer+join+transaction_param+tp19+on+tp19.transaction_id+%3D+t.id_transaction+and+tp19.field_id+%3D+19++left+outer+join+transaction_param+tp20+on+tp20.transaction_id+%3D+t.id_transaction+and+tp20.field_id+%3D+20++left+outer+join+transaction_param+tp21+on+tp21.transaction_id+%3D+t.id_transaction+and+tp21.field_id+%3D+21++left+outer+join+transaction_param+tp22+on+tp22.transaction_id+%3D+t.id_transaction+and+tp22.field_id+%3D+22++left+outer+join+transaction_param+tp23+on+tp23.transaction_id+%3D+t.id_transaction+and+tp23.field_id+%3D+23++left+outer+join+transaction_param+tp24+on+tp24.transaction_id+%3D+t.id_transaction+and+tp24.field_id+%3D+24++left+outer+join+transaction_param+tp25+on+tp25.transaction_id+%3D+t.id_transaction+and+tp25.field_id+%3D+25++left+outer+join+transaction_param+tp26+on+tp26.transaction_id+%3D+t.id_transaction+and+tp26.field_id+%3D+26++left+outer+join+transaction_param+tp27+on+tp27.transaction_id+%3D+t.id_transaction+and+tp27.field_id+%3D+27++left+outer+join+transaction_param+tp28+on+tp28.transaction_id+%3D+t.id_transaction+and+tp28.field_id+%3D+28++left+outer+join+transaction_param+tp29+on+tp29.transaction_id+%3D+t.id_transaction+and+tp29.field_id+%3D+29++left+outer+join+transaction_change+tch+on+tch.transaction_change_id+%3D+%28select+transaction_change_id+from+transaction_change+where+transaction_id+%3D+t.id_transaction+order+by+transaction_change_id+desc+limit+1%29++LEFT+OUTER+JOIN+transaction_customerjourney+tcj+ON+tcj.transaction_id+%3D+t.id_transaction++++AND+tcj.action_type+%3D+tc.action_type+AND+tc.ts+%3D+tcj.ts+AND+REPLACE%28REPLACE%28ifNULL%28tc.network_session%2C%22%22%29%2C%22%28%22%2C%22%22%29%2C+%22%29%22%2C%22%22%29+%3D+REPLACE%28REPLACE%28ifNULL%28tcj.session_param_value%2C%22%22%29%2C%22%28%22%2C%22%22%29%2C+%22%29%22%2C%22%22%29++++AND+%28+%28+tc.publisher_trackingcode_id+%3D+tcj.publisher_trackingcode_id+AND+tc.publisher_trackingcode_id+is+not+null+%29+OR+%28+tc.seo_id+%3D+tcj.seo_id+AND+tc.seo_id+is+not+null+%29+%29++WHERE++t.campaign_id+%3D+741++and+t.ts+between+%222015-08-15+00%3A00%3A00%22+and+%222015-09-17+23%3A59%3A59%22++++AND+li.id_line_item+in+%28-1%2C6496%2C6497%2C6498%2C6499%2C6500%2C6501%2C6502%2C6503%2C6542%2C6543%2C6544%2C6550%2C6551%2C6552%2C6553%2C6554%2C6555%2C6556%2C6557%2C6558%2C6559%2C6560%2C6561%2C6562%2C6563%2C6564%2C6725%2C6726%2C6727%2C6728%2C6729%2C6730%2C6731%2C6780%2C6781%2C6782%2C6791%2C6798%2C6799%2C6800%2C6801%2C6807%2C6808%2C6809%2C6810%2C6814%2C6838%2C6839%2C6840%2C6841%2C6842%2C6843%2C6844%2C6845%2C6859%2C6950%2C6984%2C6990%2C7157%2C7229%2C7231%2C7232%2C7292%2C7293%2C7294%2C7295%2C7296%2C7297%2C7298%2C7299%2C7300%2C7337%2C7341%2C7366%2C7376%2C7388%2C7406%2C7407%2C7420%2C7433%2C7459%2C7460%2C7472%2C7473%2C7475%2C7476%2C7842%2C8043%2C8233%2C8234%2C8235%2C9270%2C10779%2C10852%2C11152%2C11518%2C12194%2C12197%2C12571%2C12785%2C12825%2C13007%2C13169%2C13197%2C13198%2C13199%2C13200%2C13201%2C13240%2C13243%2C13567%2C13782%2C13879%2C13880%2C13881%2C14377%2C14649%2C14928%2C15103%2C15460%2C15634%2C15635%2C15636%2C15637%2C15638%2C15805%2C15806%2C15979%2C15980%2C15981%2C15982%2C15983%2C16019%2C16086%2C16153%2C16154%2C16155%2C16272%2C16291%2C16320%2C16595%2C16702%2C16711%2C16712%2C16714%2C16738%2C16756%2C16786%2C16787%2C16792%2C16794%2C17051%2C17068%2C17466%2C17844%29++++AND+IFNULL%28p.id_publisher%2Cseo_p.id_publisher%29+in+%28-1%2C5538%2C9824%2C5540%2C6625%2C8746%2C5539%2C9637%2C5541%2C5608%2C152%2C153%2C154%2C155%2C156%2C157%2C158%2C159%2C160%2C161%2C162%2C163%2C164%2C165%2C166%2C167%2C168%2C169%2C170%2C171%2C172%2C173%2C174%2C175%2C176%2C177%2C178%2C179%2C180%2C181%2C182%2C183%2C184%2C185%2C186%2C187%2C188%2C189%2C190%2C191%2C192%2C193%2C194%2C195%2C196%2C197%2C198%2C199%2C200%2C201%2C202%2C203%2C204%2C205%2C206%2C207%2C208%2C209%2C210%2C211%2C212%2C213%2C214%2C215%2C216%2C217%2C218%2C219%2C220%2C221%2C222%2C223%2C224%2C225%2C386%2C665%2C666%2C793%2C794%2C1738%2C1739%2C1740%2C1741%2C1742%2C1743%2C1744%2C1745%2C1746%2C1797%2C1798%2C1799%2C1800%2C1801%2C1802%2C1803%2C1804%2C1805%2C1806%2C1807%2C1808%2C1809%2C1810%2C1811%2C1812%2C1813%2C1814%2C1815%2C1816%2C1817%2C1818%2C1819%2C1820%2C1821%2C1822%2C1823%2C1824%2C1825%2C1826%2C1827%2C1828%2C1829%2C1830%2C1831%2C1832%2C1833%2C1834%2C1835%2C1836%2C1837%2C1838%2C1839%2C1840%2C1841%2C1842%2C1843%2C1844%2C1845%2C1846%2C1847%2C1848%2C1849%2C1850%2C1851%2C1852%2C1853%2C1854%2C1855%2C1856%2C1857%2C1858%2C1859%2C1860%2C1861%2C1862%2C1863%2C1864%2C1865%2C1866%2C1867%2C1868%2C1869%2C1870%2C1871%2C1872%2C1873%2C1874%2C1875%2C1876%2C1877%2C1878%2C1879%2C1880%2C1881%2C1882%2C1883%2C1884%2C1885%2C1886%2C1887%2C1888%2C1889%2C1890%2C1891%2C1892%2C1893%2C1894%2C1895%2C1896%2C1897%2C1898%2C1899%2C1900%2C1901%2C1902%2C1903%2C1904%2C1905%2C1906%2C1907%2C1908%2C1909%2C1910%2C1911%2C1912%2C1913%2C1914%2C1915%2C1916%2C1917%2C1918%2C1919%2C1920%2C1921%2C1922%2C1923%2C1924%2C1925%2C1926%2C1927%2C1928%2C1929%2C1930%2C1931%2C1932%2C1933%2C1934%2C1935%2C1936%2C1937%2C1938%2C1939%2C1940%2C1941%2C1942%2C1943%2C1944%2C1945%2C1946%2C1947%2C1948%2C1949%2C1950%2C1951%2C1952%2C1953%2C1954%2C1955%2C1956%2C1957%2C1958%2C1959%2C1960%2C1961%2C1962%2C1963%2C1964%2C1965%2C1966%2C1967%2C1968%2C1969%2C1970%2C1971%2C1972%2C1973%2C1974%2C1975%2C1976%2C1977%2C1978%2C1979%2C1980%2C1981%2C1982%2C1983%2C1984%2C1985%2C1986%2C1987%2C1988%2C1989%2C1990%2C1991%2C1992%2C1993%2C1994%2C1995%2C1996%2C1997%2C1998%2C1999%2C2000%2C2001%2C2002%2C2003%2C2004%2C2005%2C2006%2C2007%2C2008%2C2009%2C2010%2C2011%2C2012%2C2013%2C2014%2C2015%2C2016%2C2017%2C2018%2C2019%2C2020%2C2021%2C2022%2C2023%2C2024%2C2025%2C2026%2C2027%2C2028%2C2029%2C2030%2C2031%2C2032%2C2033%2C2034%2C2035%2C2036%2C2037%2C2038%2C2039%2C2040%2C2041%2C2042%2C2043%2C2044%2C2045%2C2046%2C2047%2C2048%2C2049%2C2050%2C2051%2C2052%2C2053%2C2054%2C2055%2C2056%2C2057%2C2058%2C2059%2C2060%2C2061%2C2062%2C2063%2C2064%2C2065%2C2066%2C2067%2C2068%2C2069%2C2070%2C2071%2C2072%2C2073%2C2074%2C2075%2C2076%2C2077%2C2078%2C2079%2C2080%2C2081%2C2082%2C2083%2C2084%2C2085%2C2086%2C2087%2C2088%2C2089%2C2090%2C2091%2C2092%2C2093%2C2094%2C2095%2C2096%2C2097%2C2098%2C2099%2C2100%2C2101%2C2102%2C2103%2C2104%2C2105%2C2106%2C2107%2C2108%2C2109%2C2110%2C2111%2C2112%2C2113%2C2114%2C2115%2C2116%2C2117%2C2118%2C2119%2C2120%2C2121%2C2122%2C2123%2C2124%2C2125%2C2126%2C2127%2C2128%2C2129%2C2130%2C2131%2C2132%2C2133%2C2134%2C2135%2C2136%2C2137%2C2138%2C2139%2C2140%2C2141%2C2142%2C2143%2C2144%2C2145%2C2146%2C2147%2C2148%2C2149%2C2150%2C2151%2C2152%2C2153%2C2154%2C2155%2C2156%2C2157%2C2158%2C2159%2C2160%2C2161%2C2162%2C2163%2C2164%2C2165%2C2166%2C2167%2C2168%2C2169%2C2170%2C2171%2C2172%2C2173%2C2174%2C2175%2C2176%2C2177%2C2178%2C2179%2C2180%2C2181%2C2182%2C2183%2C2184%2C2185%2C2186%2C2187%2C2188%2C2189%2C2190%2C2191%2C2192%2C2193%2C2194%2C2195%2C2196%2C2197%2C2198%2C2199%2C2200%2C2201%2C2202%2C2203%2C2204%2C2205%2C2206%2C2207%2C2208%2C2209%2C2210%2C2211%2C2212%2C2213%2C2214%2C2215%2C2216%2C2217%2C2218%2C2219%2C2220%2C2221%2C2222%2C2223%2C2224%2C2225%2C2226%2C2227%2C2228%2C2229%2C2230%2C2231%2C2232%2C2233%2C2234%2C2235%2C2236%2C2237%2C2238%2C2239%2C2240%2C2241%2C2242%2C2243%2C2244%2C2245%2C2246%2C2247%2C2248%2C2249%2C2250%2C2251%2C2252%2C2253%2C2254%2C2255%2C2256%2C2257%2C2258%2C2259%2C2260%2C2261%2C2262%2C2263%2C2264%2C2265%2C2266%2C2267%2C2268%2C2269%2C2270%2C2271%2C2272%2C2273%2C2274%2C2275%2C2276%2C2277%2C2278%2C2279%2C2280%2C2281%2C2282%2C2283%2C2284%2C2285%2C2286%2C2287%2C2288%2C2289%2C2290%2C2291%2C2292%2C2293%2C2294%2C2295%2C2296%2C2297%2C2298%2C2299%2C2300%2C2301%2C2302%2C2303%2C2304%2C2305%2C2306%2C2307%2C2308%2C2309%2C2310%2C2311%2C2312%2C2313%2C2314%2C2315%2C2316%2C2317%2C2318%2C2319%2C2320%2C2321%2C2322%2C2323%2C2324%2C2325%2C2326%2C2327%2C2328%2C2329%2C2330%2C2331%2C2332%2C2333%2C2334%2C2335%2C2336%2C2337%2C2338%2C2339%2C2340%2C2341%2C2342%2C2343%2C2344%2C2345%2C2346%2C2347%2C2348%2C2349%2C2350%2C2351%2C2352%2C2353%2C2354%2C2355%2C2356%2C2357%2C2358%2C2359%2C2360%2C2361%2C2362%2C2363%2C2364%2C2365%2C2366%2C2367%2C2368%2C2369%2C2370%2C2371%2C2372%2C2373%2C2374%2C2375%2C2376%2C2377%2C2378%2C2379%2C2380%2C2381%2C2382%2C2383%2C2384%2C2385%2C2386%2C2387%2C2388%2C2389%2C2390%2C2391%2C2392%2C2393%2C2394%2C2395%2C2396%2C2397%2C2398%2C2399%2C2400%2C2401%2C2402%2C2403%2C2404%2C2405%2C2406%2C2407%2C2408%2C2409%2C2410%2C2411%2C2412%2C2413%2C2414%2C2415%2C2416%2C2417%2C2418%2C2419%2C2420%2C2421%2C2422%2C2423%2C2424%2C2425%2C2426%2C2427%2C2428%2C2429%2C2430%2C2431%2C2432%2C2433%2C2434%2C2435%2C2436%2C2437%2C2438%2C2439%2C2440%2C2441%2C2442%2C2443%2C2444%2C2445%2C2446%2C2447%2C2448%2C2449%2C2450%2C2451%2C2452%2C2453%2C2454%2C2455%2C2456%2C2457%2C2458%2C2459%2C2460%2C2461%2C2462%2C2463%2C2464%2C2465%2C2466%2C4883%2C4884%2C6202%2C6203%2C6204%2C6205%2C6206%2C6207%2C6208%2C6209%2C6210%2C6211%2C6212%2C6213%2C6214%2C6215%2C6216%2C6217%2C6218%2C6219%2C6220%2C6221%2C6222%2C6223%2C6224%2C6225%2C6226%2C6227%2C6228%2C6229%2C6230%2C6231%2C6232%2C6233%2C6234%2C6235%2C6236%2C6237%2C6238%2C6239%2C6240%2C6241%2C6242%2C6243%2C6244%2C6245%2C6246%2C6247%2C6248%2C6249%2C6250%2C6251%2C6252%2C6253%2C6254%2C6255%2C6256%2C6257%2C6258%2C6259%2C6260%2C6261%2C6262%2C6263%2C6264%2C6265%2C6266%2C6267%2C6268%2C6269%2C6270%2C6271%2C6272%2C6273%2C6274%2C6275%2C6276%2C6277%2C6278%2C6279%2C6280%2C6281%2C6282%2C6283%2C6284%2C6285%2C6286%2C6287%2C6288%2C6289%2C6290%2C6291%2C6292%2C6293%2C6294%2C6295%2C6296%2C6297%2C6298%2C6299%2C6300%2C6301%2C6302%2C6303%2C6304%2C6305%2C6306%2C6307%2C6308%2C6309%2C6310%2C6311%2C6312%2C6313%2C6314%2C6315%2C6316%2C6317%2C6318%2C6319%2C6320%2C6321%2C6322%2C6323%2C6324%2C6325%2C6326%2C6327%2C6328%2C6329%2C6330%2C6331%2C6332%2C6333%2C6334%2C6335%2C6336%2C6337%2C6338%2C6339%2C6340%2C6341%2C6342%2C6343%2C6344%2C6345%2C6346%2C6347%2C6348%2C6349%2C6350%2C6351%2C6352%2C6353%2C6354%2C6355%2C6356%2C6357%2C6358%2C6359%2C6360%2C6361%2C6362%2C6363%2C6364%2C6365%2C6366%2C6367%2C6368%2C6369%2C6370%2C6371%2C6372%2C6373%2C6374%2C6375%2C6376%2C6377%2C6378%2C6379%2C6380%2C6381%2C6382%2C6383%2C6384%2C6385%2C8685%2C8686%2C8687%2C8688%2C8689%2C8690%2C8691%2C8692%2C8693%2C8694%2C8695%2C8696%2C8697%2C8698%2C8699%2C5609%2C5567%2C5616%2C5568%2C1754%2C1753%2C5613%2C5614%2C5615%2C5620%2C5617%2C5618%2C5619%2C5621%2C5622%2C5623%2C5624%2C6156%2C9687%2C6712%2C6188%2C6479%2C6200%2C6201%2C6567%2C6484%2C6607%2C6619%2C6714%2C6774%2C6777%2C6781%2C6782%2C6783%2C6784%2C6785%2C6786%2C6837%2C6856%2C6658%2C6660%2C6661%2C6662%2C6665%2C6669%2C6675%2C6676%2C6680%2C6685%2C6701%2C7705%2C7704%2C8524%2C8525%2C8903%2C8650%2C8970%2C8204%2C9021%2C9022%2C9023%2C9043%2C9328%2C9384%2C9385%2C8203%2C9631%2C9633%2C9634%2C9690%2C9636%2C6626%2C9721%2C9803%2C8881%2C9821%2C9836%2C9517%2C8884%2C10069%29++ORDER+BY+2+desc++LIMIT+0+%2C+25%0A'
          2        DO_FCALL                                      0  $0      
          3        ECHO                                                     $0
    4     4      > RETURN                                                   1

Generated using Vulcan Logic Dumper, using php 8.0.0