mysql> SET SESSION group_concat_max_len = 134217728; Query OK, 0 rows affected (0.00 sec) mysql> SELECT GROUP_CONCAT(group_id SEPARATOR '::') from groups where is_public = 0 AND group_id > 100 AND status = 'A'; +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | GROUP_CONCAT(group_id SEPARATOR '::') | +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 1567::1516::3463::2224::336::1676::1697::606::3459::3357::3358::3359::3360::3361::3362::3363::3364::3365::3366::3367::2056::2731::729::2871::843::1740::2419::1684::1687::1688::1166::2369::2370::2687::1659::1435::1279::3425::1395::2896::1438::1442::1443::1444::1445::2853::1447::1448::1450::1451::1453::2987::1454::1455::1456::1457::1459::3587::1463::1464::1465::1466::1468::1469::1470::1471::1477::1489::1483::1486::1487::1490::1492::1497::1501::3190::3191::3193::3194::3196::1507::1511::1512::1513::1520::1521::1522::1524::1526::1527::1531::1537::1543::1545::1547::1549::1550::1558::1563::1564::1568::1569::1578::1573::1575::1577::1579::1580::1584::1628::1587::1588::1589::1592::1594::1607::1612::1613::1614::1616::1617::1618::1621::1623::1631::1632::1633::1635::1636::1637::1638::1646::1650::1651::1653::1655::1658::1661::1662::1663::1665::1666::1667::1672::1675::1678::1690::1692::1694::1695::1704::1705::3230::1708::1709::1711::1712::1713::1715::1716::1723::1726::1725::1730::1737::1738::2016::1744::1745::1746::1748::2276::1752::1754::1755::1756::1778::1768::1770::1784::1787::1789::1772::2014::1776::1889::1800::1803::1804::1813::1814::1820::1821::1824::1829::1830::1833::1840::1885::1844::4022::1846::1847::1848::1850::1979::1852::1853::1854::1855::1856::1857::1858::1859::1860::1862::1872::1870::1874::1877::1879::1881::3385::1884::1892::1893::1896::1897::2073::1901::1903::1904::1906::1914::1915::1917::1918::1925::1928::1927::1956::1929::1930::1933::1934::1937::1939::1942::1943::1944::1945::1949::1953::1954::1955::1957::1960::1961::1962::1963::1964::1966::1969::1970::1972::1973::1974::1977::1978::1981::1983::1984::1985::1986::1987::1988::1990::1991::1999::2003::2004::2006::2007::2008::2012::2010::2017::2019::2020::2021::2022::2025::2028::2029::2030::2031::2032::2033::2040::2041::2044::2049::2050::2051::2052::2053::2054::2055::2057::2058::2060::2062::2065::2067::2068::2072::2074::2075::2076::2077::2078::2082::2084::2086::2087::2090::2091::2095::2099::2103::2106::2112::2110::2111::2113::2115::2119::2120::2121::2124::2126::2129::2133::2135::2137::2139::2140::2143::2154::2155::2161::2163::2164::2169::2173::2175::2176::2177::2178::2179::2181::2182::2184::2188::2191::2192::2193::2194::2195::2197::2199::2200::2201::2203::2211::2212::2214::2221::2222::2225::2662::2228::2229::2231::2233::2238::2237::2263::2578::2243::2245::2246::2247::2250::2264::2254::2257::2259::2262::2268::2312::2269::2284::2271::2274::2277::2278::2279::2280::2281::2283::2285::2286::2287::2288::2290::2295::2332::2299::2301::2302::2331::2303::2306::2307::2373::2308::2310::2316::2320::2338::2321::2322::2323::2324::2325::2326::2328::2330::2333::2335::2336::2337::2342::2343::2345::2347::2357::2649::2353::2354::2355::2356::2358::2359::2360::2361::2365::2366::2367::2658::2663::2667::2670::2669::2671::2674::2679::2685::2691::2694::2375::2376::2378::2380::2383::2390::2385::2386::2387::2388::2389::2396::2399::2401::2402::2403::2405::2406::2407::2409::2413::2416::2417::2422::2423::2424::2428::2431::2432::2433::2434::2436::2503::2438::2552::2441::2444::2448::2449::2451::2452::2453::2455::2456::2457::2458::2462::2463::2465::2515::2471::2472::2474::2475::2477::2478::2479::2480::2481::3057::2482::3109::2484::2485::2488::2489::2493::2655::2497::2498::2500::2505::2507::2508::2553::2513::2522::2523::2524::2525::2526::2583::2530::2532::2533::2535::2537::2539::2540::2542::2543::2544::2545::2546::2547::2554::2558::2559::2565::2566::2577::2579::2584::2586::2587::2588::2592::2593::2596::2598::2599::2604::2605::2606::2607::2608::2609::2610::2612::2613::2614::2616::2675::2617::2618::2619::2620::2621::2622::2623::2624::2629::2633::2635::2637::2638::2639::2640::2641::2643::2654::2644::2645::2646::2647::2650::2652::2653::2697::2698::2699::2701::2702::2703::2704::2707::2714::2726::2728::2729::2732::2733::2734::2758::2736::2737::2738::2739::2743::2740::2741::2742::2744::3383::2745::2747::2749::2754::2755::2756::2760::2787::2790::2791::2793::2792::2794::2796::2797::2798::2799::2800::2802::2803::2806::2807::2883::2809::2823::2815::2816::2818::2819::2820::2821::2822::2825::2826::2829::2835::2836::2839::2840::2841::2842::2843::2845::2846::2850::2851::2855::2857::2860::2861::2865::2867::2868::2870::2872::2873::2875::2876::2878::2884::2879::2880::2882::2885::2888::2889::2890::2891::2892::2893::4177::2899::2900::2901::2902::2903::2904::2906::2907::2908::2909::2910::2914::2930::2916::2918::2920::2921::2923::2925::2927::2929::2932::2934::2935::2936::3407::2937::2938::2939::2940::2943::2944::2949::3192::3848::2951::2952::2955::2956::2958::2960::2961::2963::2964::2965::2966::2967::2969::2970::2971::2972::2973::2974::2978::2979::2980::2981::2983::2984::2988::2989::2990::2993::2997::2998::2999::3000::3001::3003::3004::3005::3008::3009::3016::3018::3023::3024::3025::3026::3027::3028::3029::3031::3032::3038::3070::3042::3043::3044::3046::3047::3050::3051::3055::3056::3058::3059::3060::3064::3065::3066::3067::3069::3075::3091::3092::3093::3095::3096::3097::3098::3100::3101::3102::3104::3105::3106::3108::3110::3111::3112::3113::3114::3115::3119::3121::3123::3126::3124::3127::3128::3129::3130::3131::3132::3133::3134::3135::3140::3142::3143::3145::3146::3147::3149::3152::3155::3158::3160::3161::3162::3164::3165::3166::3170::3172::3173::3175::3177::3178::3180::3182::3183::3186::3187::3198::3199::3200::3201::3202::3205::3207::3209::3213::3214::3215::3216::3217::3218::3219::3220::3222::3223::3225::3228::3229::3231::3232::3234::3236::3237::3239::3240::3242::3244::3246::3247::3249::3251::3255::3260::3261::3262::3268::3271::3272::3273::3274::3276::3277::3278::3283::3284::3285::3286::3288::3289::3290::3292::3293::3295::3296::3300::3301::3302::3303::3304::3305::3306::3309::3310::3311::3315::3317::3319::3321::3322::3324::3325::3328::3329::3330::3331::3333::3334::3342::3343::3346::3347::3348::3349::3350::3351::3352::3355::3356::3370::3372::3373::3374::3375::3378::3379::3380::3381::3406::3387::3388::3390::3392::3395::3396::3397::3399::3401::3403::3410::3411::3412::3413::3414::3416::3418::3420::3421::3422::3423::3424::3426::3427::3429::3430::3432::3433::3435::3441::3436::3437::3438::3439::3440::3442::3445::3446::3447::3448::3451::3452::3453::3454::3455::3456::3457::3460::3464::3465::3466::3469::3470::3472::3473::3474::3475::3478::3479::3481::3482::3483::3486::3487::3489::3491::3492::3495::3496::3498::3500::3501::3502::3504::3505::3506::3507::3509::3510::3511::3512::3513::3514::3516::3517::3520::3524::3526::3528::3529::3530::3531::3532::3533::3534::3537::3538::3541::3542::3543::3544::3545::3546::3606::3547::3550::3551::3552::3557::3558::3559::3560::3561::3562::3563::3662::3568::3570::3571::3572::3573::3574::3575::3576::3578::3579::3581::3582::3583::3585::3588::3589::3590::3594::3608::3611::3612::3613::3614::3616::3620::3621::3622::3624::3627::3628::3631::3763::3765::3768::3769::3770::3774::3860::3776::3778::3779::3782::3783::3784::3785::3789::3791::3794::3795::3796::3799::3800::3801::3802::3803::3804::3805::3808::3809::3815::3817::3819::3820::3821::3822::3823::3824::3825::3826::3827::3828::3829::3833::3834::3836::3837::3838::3841::3639::3640::3645::3648::3649::3651::3652::3653::3654::3655::3656::3658::3659::3663::3661::3664::3666::3668::3671::3673::3674::3813::3676::3678::3680::3681::3682::3683::3684::3685::3686::3694::3696::3697::3698::3700::3701::3703::3705::3708::3709::3710::3712::3716::3717::3718::3719::3720::3721::3723::3726::3727::3728::3729::3731::3733::3734::3738::3739::3740::3742::3745::3746::3748::3753::3755::3756::3758::3759::3760::3761::3830::3831::3832::3842::3843::3844::3845::3846::3857::3853::3854::3855::3856::3858::3861::3862::3864::3865::3866::3867::3871::3872::3873::3874::3875::3876::3877::3878::3938::4060::4030::4061::3985::3901::3879::3881::3882::3883::3885::3893::3894::3895::3897::4029::3902::3903::3904::3905::3907::3908::3910::3911::3912::3913::3914::3915::3916::3917::3922::3923::3929::3930::3932::3933::3935::3936::3937::3939::3940::3941::3942::3944::3945::3946::3947::3948::3949::3951::3953::3954::3955::3959::3960::3962::3964::3966::3967::3968::3969::3971::3972::3975::3981::3979::3980::3986::3987::3988::3989::3990::3992::3993::3994::3995::3996::3997::4005::4003::4004::4007::4008::4009::4010::4011::4012::4013::4014::4016::4018::4019::4020::4025::4026::4027::4031::4033::4034::4035::4037::4038::4039::4089::4042::4043::4044::4045::4047::4049::4051::4052::4053::4054::4055::4056::4057::4058::4063::4065::4066::4067::4070::4071::4074::4075::4077::4078::4079::4081::4082::4083::4084::4086::4087::4088::4090::4091::4094::4095::4096::4097::4098::4099::4100::4101::4102::4103::4104::4105::4106::4107::4108::4109::4110::4112::4113::4114::4115::4116::4119::4120::4123::4124::4125::4126::4127::4128::4129::4130::4131::4132::4134::4135::4137::4138::4139::4142::4146::4147::4148::4149::4183::4150::4152::4153::4154::4155::4157::4160::4161::4162::4165::4166::4246::4168::4169::4170::4171::4172::4175::4176::4178::4179::4180::4181::4182::4184::4186::4187::4188::4190::4191::4192::4193::4196::4198::4199::4201::4202::4203::4204::4206::4207::4208::4209::4210::4212::4214::4216::4218::4219::4220::4221::4222::4223::4227::4228::4229::4230::4231::4233::4236::4237::4239::4240::4241::4243::4244::4247::4249::4248::4252::4256::4257::4261::4262::4263::4264::4265::4266::4267::4268::4269::4270::4272::4273::4275::4277::4278::4279::4286::4287::4288::4289::4290::4291::4293 | +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> SHOW warnings; Empty set (0.00 sec)