SELECT distinct CONVERT(SUBSTRING(td.ThesaurusDataValue, 1, 1) USING latin1) AS ShortWord, CONVERT(td.ThesaurusDataValue USING latin1) AS Caption FROM ThesaurusData AS td INNER JOIN ThesaurusDataIndex AS tdi, Articles AS a ON (td.ThesaurusDataId = tdi.ThesaurusDataIndexId) WHERE (tdi.ThesaurusDataIndexObjectId = a.ArticleID) && (a.ArticleFree = 1) && (a.ArticleArchive = 0) && (a.ArticleRelease <= UNIX_TIMESTAMP()) && ((a.SectionID IN(2588,2603,2448,2648,2458,2470,2488,2512,2516,2537,2567,2585,4165,2753,2927,2950,2954,3010,3038,3352,3409,4486,3712,3870,4387,4427,4430,4435,4438,4441,4461,4564,4609)) OR (a.SectionID IN(3224,3225,3226,3227,3683,2471,2522,3223,2949,2980,3084,3085,3228,3356,3488,2489,2490,2491,2492,2493,2494,2500,2501,2502,2503,2504,2505,3268,2959,3505,4076,4386,2514,2534,2535,3663,2541,2544,2548,3353,3494,3508,3509,3510,3511,3512,3513,3514,3515,3516,3517,3518,3519,3520,3521,3522,3523,3524,3525,3526,3527,3691,3529,3530,3531,3532,3533,3534,3536,3537,3538,3539,3540,3613,3614,3615,3616,3617,3618,3619,3620,3622,3623,3651,3652,3653,3655,3684,3690,3692,3693,3694,3698,3696,3697,3700,3701,3702,3703,3704)) OR (a.SectionID IN(3706,3707,3711,3768,3769,3877,3872,3873,3874,3876,3901,3907,3930,3975,4250,4253,4251,4252,4255,4254,2568,2571,2574,2578,2583,2967,2966,2591,2597,2708,2709,2720,4493,3208,4496,4331,4474,4616,4630,2606,2612,2615,4261,2742,3995,2756,2762,2763,3492,3946,3365,3146,3750,3863,4162,4273,4622,4645,4646,2651,2657,2660,2809,2814,2816,3771,4175,2749,3374,3375,3902,4551,4466,2515,2536,4483,2928,2930,2936,2939,2942,2944,2946,2947,2948,2979,3899,3070,3231,3648,3783,4256,3926,4128,4274,4284,4625,3071,3072,3074)) OR (a.SectionID IN(2445,2618,2663,2812,4093,2955,2962,3915,4317,4320,3134,3364,3410,3713,3714,3716,3717,3718,3719,3720,3721,3722,3731,3737,3217,3838,4166,4167,4581,4490,4473,4388,4395,4404,4407,4408,4422,4447,4623,4428,4429,4431,4432,4436,4437,4439,4440,2526,2594,2609,2624,2639,2654,2669,2933,3949,3951,4409,4487,4488,4489,4495)) OR (a.SectionID IN(2633,2509,2465,2467,2473,2474,2475,2476,2477,2478,2479,2485,2495,2496,2497,2499,2506,2510,4497,2525,2530,2531,3659,2543,2545,2546,2547,2549,2552,2573,2569,2570,2572,2575,2576,2584,2579,2582,2592,2593,2595,2596,2598,2599,2600,2607,2608,2610,2611,2613,2614,2616,2617,2621,2625,2626,2627,2630,2640,2641,2652,2653,2655,2656,2658,2659,2661,2662,2666,2670,2671,2672,2675,2711,2713,2715,3204,2718,2719,2723,2724,2725,2726,2727,2728,2729,2744,2746,3207,2750,2751,3354,2757,2759,2760,2761,2765,2766,2767,2768)) OR (a.SectionID IN(2772,2790,2795,2813,2815,2819,2837,2838,2843,2852,2853,2857,2858,2861,2865,2870,2876,2881,4627,2889,2896,4498,2914,2918,2931,2932,2934,2935,2937,2938,2940,2941,2958,2963,2964,2965,2968,3005,3031,3032,3054,3062,4568,3068,3069,3077,3078,3080,3206,3216,3433,3122,3136,3144,3145,3151,3150,3154,3157,3184,3175,3178,3188,3201,3218,3219,3220,3221,3222,3261,3232,3233,3234,3235,3236,3237,3246,3249,4605,3251,3253,3254,3255,3256,3257,3258,3272,3273,3283,3355,3357,3358,3390,3391,3392,3393,3394,3395,3396,3397)) OR (a.SectionID IN(3398,3399,3400,3411,3436,3472,3473,3474,3475,3476,3479,3485,3495,3497,3546,3891,3638,3972,3708,3709,3715,3723,3724,3734,3735,3736,3738,3739,3746,3747,3748,4567,3785,3811,3816,3818,3839,3840,3841,3842,3861,3892,3908,3914,3916,3917,3976,3987,3947,3948,3950,3952,3957,3964,3959,3960,3961,3962,3977,3978,3979,3980,3988,4047,4129,4161,4279,4324,4325,4327,4328,4329,4330,4333,4334,4335,4336,4337,4372,4339,4340,4341,4342,4374,4352,4353,4367,4434,4371,4544,4389,4390,4391,4392,4393,4396,4400,4401,4402,4403)) OR (a.SectionID IN(4405,4406,4410,4412,4540,4423,4426,4448,4631,4455,4467,4470,4472,4476,4477,4480,4628,4565,4610,4629,4644)) OR (a.SectionID IN(4557,4647,2527,2468,2469,2528,2480,2481,2482,2483,2484,3984,2511,3035,2519,2518,2523,2524,3037,4558,2601,2602,4554,4555,4545,2622,2623,2628,2629,2631,2632,2636,2642,2645,4484,2667,2668,2673,2674,2676,2677,3056,3055,3057,2730,2731,2732,2733,2734,2735,2740,4542,2769,2770,2775,2776,2778,2784,2785,2793,2792,2794,2796,2797,2798,2799,2800,2801,2802,2804,2806,2808,2817,2818,2820,2821,2822,2823,2824,2825,2826,2827,2828,2830,2832,2833,3369,2835,2836,2839,2840,2844,2846,2847,4259,2850,2851,2854,2855,2856)) OR (a.SectionID IN(2859,2860,2862,2863,2864,2866,2867,2868,2869,2871,2872,2874,2875,2877,2879,2880,2882,4485,2884,2885,2888,3277,4500,3086,3366,2915,2917,3259,2978,2956,2957,2984,2969,2970,2971,2972,2985,3021,3022,3024,3025,3026,3027,3028,4457,3033,3058,3059,3060,3061,3063,3064,3065,3067,3087,3088,3089,3090,3091,3092,3093,3094,3095,3096,3097,3098,3099,3100,3101,3102,3103,3104,3116,3132,3276,3275,3212,3189,3190,3191,3209,3211,3278,3213,3214,3215,3274,3230,3260,3240,3241,3242,3263,3982,3983,3370,3402,3437,4560,3484)) OR (a.SectionID IN(3486,3487,3611,3632,3634,3639,3642,3910,3649,3650,3666,4546,4503,4504,4502,3729,3744,4556,3770,3772,3774,3786,3788,3802,3804,3812,3843,3845,3846,4559,4269,3889,3890,3893,3894,3898,3909,3922,3923,3929,3989,3966,3967,3985,3990,4168,4266,4271,4272,4277,4282,4283,4347,4571,4362,4354,4355,4548,4547,4379,4380,4381,4382,4383,4456,4398,4399,4411,4414,4552,4419,4424,4425,2774,4442,4443,4451,4459,4460,4550,4468,4469,4561,4562,4563,4566,4576,4582,4587,4603,4611,4613,4614,4615,4617,4624,4635,4636,4637,4638)) OR (a.SectionID IN(4639,4640,4641,4642,4643))) GROUP BY ShortWord ORDER BY ShortWord ASC, td.ThesaurusDataValue ASC;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON (td.ThesaurusDataId = tdi.ThesaurusDataIndexId) WHERE (tdi.ThesaurusDataIndex' at line 1Stichworte A-Z
Hier finden Sie die wichtigsten Stichworte des IHK-Internetauftritts in alphabetischer Reihenfolge. Von A wie "Attempto" bis Z wie "Zwischenprüfung": hier werden Sie fündig.
1
4
A
Ä
B
C
D
E
F
G
H
I
J
K
L
M
N
O
Ö
P
Q
R
S
T
U
Ü
V
W
X
Y
Z
Sie können unseren Schlagwortkatalog auch gezielt durchsuchen:
Willkommen im Online-Shop der IHK Reutlingen. Hier finden Sie nützliche Broschüren, Fachbücher und Studien sowie zahlreiche Außenhandelsformulare. Schauen Sie sich einfach um und bestellen Sie die gewünschten Publikationen oder Formulare bequem per Mausklick.
