Online PHP editor | output 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 ");