Created
September 7, 2015 01:25
-
-
Save amin007/2d2dcd404da7762b77f2 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| $sql = '(SELECT thn,F2201 as F22,F2301 as F23,F2401 as F24,concat_ws("-",F2501,F2542) as `F25`,concat_ws("-",F2601,F2642) as `F26`,concat_ws("-",F2701,F2742) as `F27`,F2801 as `%export F28`,F2901 as `kodUnit`,concat_ws("-",F3001,SUBSTRING(F3001,-10)) as `kodProduk`,( SELECT concat_ws("-",keterangan,kod_produk) FROM kod2010_output b WHERE b.kod_produk=SUBSTRING(F3001,-10) LIMIT 1) as nama_produk FROM `q14_2010` WHERE estab like '000000338955%' AND thn BETWEEN 2010 and 2012) | |
| UNION | |
| (SELECT thn,F2202 as F22,F2302 as F23,F2402 as F24,concat_ws("-",F2502,F2542) as `F25`,concat_ws("-",F2602,F2642) as `F26`,concat_ws("-",F2702,F2742) as `F27`,F2802 as `%export F28`,F2902 as `kodUnit`,concat_ws("-",F3002,SUBSTRING(F3002,-10)) as `kodProduk`,( SELECT concat_ws("-",keterangan,kod_produk) FROM kod2010_output b WHERE b.kod_produk=SUBSTRING(F3002,-10) LIMIT 1) as nama_produk FROM `q14_2010` WHERE estab like '000000338955%' AND thn BETWEEN 2010 and 2012) | |
| UNION | |
| (SELECT thn,F2203 as F22,F2303 as F23,F2403 as F24,concat_ws("-",F2503,F2542) as `F25`,concat_ws("-",F2603,F2642) as `F26`,concat_ws("-",F2703,F2742) as `F27`,F2803 as `%export F28`,F2903 as `kodUnit`,concat_ws("-",F3003,SUBSTRING(F3003,-10)) as `kodProduk`,( SELECT concat_ws("-",keterangan,kod_produk) FROM kod2010_output b WHERE b.kod_produk=SUBSTRING(F3003,-10) LIMIT 1) as nama_produk FROM `q14_2010` WHERE estab like '000000338955%' AND thn BETWEEN 2010 and 2012) | |
| UNION | |
| (SELECT thn,F2204 as F22,F2304 as F23,F2404 as F24,concat_ws("-",F2504,F2542) as `F25`,concat_ws("-",F2604,F2642) as `F26`,concat_ws("-",F2704,F2742) as `F27`,F2804 as `%export F28`,F2904 as `kodUnit`,concat_ws("-",F3004,SUBSTRING(F3004,-10)) as `kodProduk`,( SELECT concat_ws("-",keterangan,kod_produk) FROM kod2010_output b WHERE b.kod_produk=SUBSTRING(F3004,-10) LIMIT 1) as nama_produk FROM `q14_2010` WHERE estab like '000000338955%' AND thn BETWEEN 2010 and 2012) | |
| UNION | |
| (SELECT thn,F2205 as F22,F2305 as F23,F2405 as F24,concat_ws("-",F2505,F2542) as `F25`,concat_ws("-",F2605,F2642) as `F26`,concat_ws("-",F2705,F2742) as `F27`,F2805 as `%export F28`,F2905 as `kodUnit`,concat_ws("-",F3005,SUBSTRING(F3005,-10)) as `kodProduk`,( SELECT concat_ws("-",keterangan,kod_produk) FROM kod2010_output b WHERE b.kod_produk=SUBSTRING(F3005,-10) LIMIT 1) as nama_produk FROM `q14_2010` WHERE estab like '000000338955%' AND thn BETWEEN 2010 and 2012) | |
| UNION | |
| (SELECT thn,F2206 as F22,F2306 as F23,F2406 as F24,concat_ws("-",F2506,F2542) as `F25`,concat_ws("-",F2606,F2642) as `F26`,concat_ws("-",F2706,F2742) as `F27`,F2806 as `%export F28`,F2906 as `kodUnit`,concat_ws("-",F3006,SUBSTRING(F3006,-10)) as `kodProduk`,( SELECT concat_ws("-",keterangan,kod_produk) FROM kod2010_output b WHERE b.kod_produk=SUBSTRING(F3006,-10) LIMIT 1) as nama_produk FROM `q14_2010` WHERE estab like '000000338955%' AND thn BETWEEN 2010 and 2012) | |
| UNION | |
| (SELECT thn,F2207 as F22,F2307 as F23,F2407 as F24,concat_ws("-",F2507,F2542) as `F25`,concat_ws("-",F2607,F2642) as `F26`,concat_ws("-",F2707,F2742) as `F27`,F2807 as `%export F28`,F2907 as `kodUnit`,concat_ws("-",F3007,SUBSTRING(F3007,-10)) as `kodProduk`,( SELECT concat_ws("-",keterangan,kod_produk) FROM kod2010_output b WHERE b.kod_produk=SUBSTRING(F3007,-10) LIMIT 1) as nama_produk FROM `q14_2010` WHERE estab like '000000338955%' AND thn BETWEEN 2010 and 2012) | |
| UNION | |
| (SELECT thn,F2208 as F22,F2308 as F23,F2408 as F24,concat_ws("-",F2508,F2542) as `F25`,concat_ws("-",F2608,F2642) as `F26`,concat_ws("-",F2708,F2742) as `F27`,F2808 as `%export F28`,F2908 as `kodUnit`,concat_ws("-",F3008,SUBSTRING(F3008,-10)) as `kodProduk`,( SELECT concat_ws("-",keterangan,kod_produk) FROM kod2010_output b WHERE b.kod_produk=SUBSTRING(F3008,-10) LIMIT 1) as nama_produk FROM `q14_2010` WHERE estab like '000000338955%' AND thn BETWEEN 2010 and 2012) | |
| UNION | |
| (SELECT thn,F2209 as F22,F2309 as F23,F2409 as F24,concat_ws("-",F2509,F2542) as `F25`,concat_ws("-",F2609,F2642) as `F26`,concat_ws("-",F2709,F2742) as `F27`,F2809 as `%export F28`,F2909 as `kodUnit`,concat_ws("-",F3009,SUBSTRING(F3009,-10)) as `kodProduk`,( SELECT concat_ws("-",keterangan,kod_produk) FROM kod2010_output b WHERE b.kod_produk=SUBSTRING(F3009,-10) LIMIT 1) as nama_produk FROM `q14_2010` WHERE estab like '000000338955%' AND thn BETWEEN 2010 and 2012) | |
| UNION | |
| (SELECT thn,F2210 as F22,F2310 as F23,F2410 as F24,concat_ws("-",F2510,F2542) as `F25`,concat_ws("-",F2610,F2642) as `F26`,concat_ws("-",F2710,F2742) as `F27`,F2810 as `%export F28`,F2910 as `kodUnit`,concat_ws("-",F3010,SUBSTRING(F3010,-10)) as `kodProduk`,( SELECT concat_ws("-",keterangan,kod_produk) FROM kod2010_output b WHERE b.kod_produk=SUBSTRING(F3010,-10) LIMIT 1) as nama_produk FROM `q14_2010` WHERE estab like '000000338955%' AND thn BETWEEN 2010 and 2012) | |
| UNION | |
| (SELECT thn,F2211 as F22,F2311 as F23,F2411 as F24,concat_ws("-",F2511,F2542) as `F25`,concat_ws("-",F2611,F2642) as `F26`,concat_ws("-",F2711,F2742) as `F27`,F2811 as `%export F28`,F2911 as `kodUnit`,concat_ws("-",F3011,SUBSTRING(F3011,-10)) as `kodProduk`,( SELECT concat_ws("-",keterangan,kod_produk) FROM kod2010_output b WHERE b.kod_produk=SUBSTRING(F3011,-10) LIMIT 1) as nama_produk FROM `q14_2010` WHERE estab like '000000338955%' AND thn BETWEEN 2010 and 2012) | |
| UNION | |
| (SELECT thn,F2212 as F22,F2312 as F23,F2412 as F24,concat_ws("-",F2512,F2542) as `F25`,concat_ws("-",F2612,F2642) as `F26`,concat_ws("-",F2712,F2742) as `F27`,F2812 as `%export F28`,F2912 as `kodUnit`,concat_ws("-",F3012,SUBSTRING(F3012,-10)) as `kodProduk`,( SELECT concat_ws("-",keterangan,kod_produk) FROM kod2010_output b WHERE b.kod_produk=SUBSTRING(F3012,-10) LIMIT 1) as nama_produk FROM `q14_2010` WHERE estab like '000000338955%' AND thn BETWEEN 2010 and 2012) | |
| UNION | |
| (SELECT thn,F2213 as F22,F2313 as F23,F2413 as F24,concat_ws("-",F2513,F2542) as `F25`,concat_ws("-",F2613,F2642) as `F26`,concat_ws("-",F2713,F2742) as `F27`,F2813 as `%export F28`,F2913 as `kodUnit`,concat_ws("-",F3013,SUBSTRING(F3013,-10)) as `kodProduk`,( SELECT concat_ws("-",keterangan,kod_produk) FROM kod2010_output b WHERE b.kod_produk=SUBSTRING(F3013,-10) LIMIT 1) as nama_produk FROM `q14_2010` WHERE estab like '000000338955%' AND thn BETWEEN 2010 and 2012) | |
| UNION | |
| (SELECT thn,F2214 as F22,F2314 as F23,F2414 as F24,concat_ws("-",F2514,F2542) as `F25`,concat_ws("-",F2614,F2642) as `F26`,concat_ws("-",F2714,F2742) as `F27`,F2814 as `%export F28`,F2914 as `kodUnit`,concat_ws("-",F3014,SUBSTRING(F3014,-10)) as `kodProduk`,( SELECT concat_ws("-",keterangan,kod_produk) FROM kod2010_output b WHERE b.kod_produk=SUBSTRING(F3014,-10) LIMIT 1) as nama_produk FROM `q14_2010` WHERE estab like '000000338955%' AND thn BETWEEN 2010 and 2012) | |
| UNION | |
| (SELECT thn,F2215 as F22,F2315 as F23,F2415 as F24,concat_ws("-",F2515,F2542) as `F25`,concat_ws("-",F2615,F2642) as `F26`,concat_ws("-",F2715,F2742) as `F27`,F2815 as `%export F28`,F2915 as `kodUnit`,concat_ws("-",F3015,SUBSTRING(F3015,-10)) as `kodProduk`,( SELECT concat_ws("-",keterangan,kod_produk) FROM kod2010_output b WHERE b.kod_produk=SUBSTRING(F3015,-10) LIMIT 1) as nama_produk FROM `q14_2010` WHERE estab like '000000338955%' AND thn BETWEEN 2010 and 2012) | |
| UNION | |
| (SELECT thn,F2216 as F22,F2316 as F23,F2416 as F24,concat_ws("-",F2516,F2542) as `F25`,concat_ws("-",F2616,F2642) as `F26`,concat_ws("-",F2716,F2742) as `F27`,F2816 as `%export F28`,F2916 as `kodUnit`,concat_ws("-",F3016,SUBSTRING(F3016,-10)) as `kodProduk`,( SELECT concat_ws("-",keterangan,kod_produk) FROM kod2010_output b WHERE b.kod_produk=SUBSTRING(F3016,-10) LIMIT 1) as nama_produk FROM `q14_2010` WHERE estab like '000000338955%' AND thn BETWEEN 2010 and 2012) | |
| UNION | |
| (SELECT thn,F2217 as F22,F2317 as F23,F2417 as F24,concat_ws("-",F2517,F2542) as `F25`,concat_ws("-",F2617,F2642) as `F26`,concat_ws("-",F2717,F2742) as `F27`,F2817 as `%export F28`,F2917 as `kodUnit`,concat_ws("-",F3017,SUBSTRING(F3017,-10)) as `kodProduk`,( SELECT concat_ws("-",keterangan,kod_produk) FROM kod2010_output b WHERE b.kod_produk=SUBSTRING(F3017,-10) LIMIT 1) as nama_produk FROM `q14_2010` WHERE estab like '000000338955%' AND thn BETWEEN 2010 and 2012) | |
| UNION | |
| (SELECT thn,F2218 as F22,F2318 as F23,F2418 as F24,concat_ws("-",F2518,F2542) as `F25`,concat_ws("-",F2618,F2642) as `F26`,concat_ws("-",F2718,F2742) as `F27`,F2818 as `%export F28`,F2918 as `kodUnit`,concat_ws("-",F3018,SUBSTRING(F3018,-10)) as `kodProduk`,( SELECT concat_ws("-",keterangan,kod_produk) FROM kod2010_output b WHERE b.kod_produk=SUBSTRING(F3018,-10) LIMIT 1) as nama_produk FROM `q14_2010` WHERE estab like '000000338955%' AND thn BETWEEN 2010 and 2012) | |
| UNION | |
| (SELECT thn,"" as F22,"" as F23,"Nilai Produk Lain2" as F24,concat_ws("-",F2541,F2542) as `F25`,concat_ws("-",F2641,F2642) as `F26`,concat_ws("-",F2741,F2742) as `F27`,"" as `%export F28`,"" as `kodUnit`,F3041 as `kodProduk`,"" as produk FROM `q14_2010` WHERE estab like '000000338955%' AND thn BETWEEN 2010 and 2012)'; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment