SELECT * FROM types  ;
MySQL server has gone away

SELECT * FROM locations   WHERE 1  AND `url` = '349' LIMIT 1;
MySQL server has gone away

SELECT a.*, l.location, l.country FROM areas AS a  LEFT JOIN locations AS l ON l.id = a.location  WHERE 1  AND a.`area` = '349' LIMIT 1;
MySQL server has gone away

SELECT MAX(n.last_complaint) as last_complaint, COUNT(n.number) as count, n.prefix FROM numbers_new AS n   WHERE 1  AND n.`area` = '349' AND n.number NOT IN('0000000000', '8003453452', '4017424376', '5025946898', '4017424376', '6142646386', '6266955561', '9737032046', '2157679159', '2032733148', '4017424376', '8584558400', '7732209807', '4168909882', '5166339750', '8584558400', '6302029819', '7204201227', '7204411544', '9547010884', '9083099649', '8002308103', '3212769784', '4044036439', '4694740489', '3522563939', '7327426126', '7182563210', '8017922010', '4052856441', '5012760565', '4135226102', '6128711145', '2817966865', '9177577058', '4152033420', '7272618747', '2482596806', '3108743294', '7154958147', '7154952887', '8478121800', '6129872195', '6025020125', '7083261582', '7083261042', '8152773987', '2177173223', '6187675008', '4698042967', '3303229952', '8774947606', '8885095601', '4145814615', '9892333224', '8005687708', '6462266922', '2392532531', '6233835658', '4253191414', '4356691942', '6514550636', '2093730582', '7072721566', '3604025349', '9512603948', '7756003796', '3014337589', '9036860071', '2122301078', '4152601421', '6093742815', '8322931934', '9165830077', '5127405120', '3037339234', '9542348058', '7542086239', '5023019220', '4153081989', '5128452482', '9709461141', '8184191707', '4049382932', '5134091678', '2129205496', '4153467975', '9174005311', '2095056891', '5039310902', '5038583067', '8607782383', '3078001470', '3524766543', '3479830205', '3018287983', '8018366788', '7083261060', '3373510329', '3376929497', '5032678732', '7608053659', '5165247482', '2014971010', '4029175354', '9083283959', '8187011575', '6023164773', '3035782196', '4074055153', '8043076106', '6129108149', '4252246645', '6602511623', '6602511575', '6602321344', '4087101357', '2088191873', '6192194601', '3053042618', '9739022524', '9727432905', '4436185804', '7205151738', '7026014711', '4784751757', '2066014959', '7323009136', '9728379939', '6096062824', '5308593952', '3107399308', '6613331363', '9739018183', '3606728402', '3608092964', '7752034205', '5025850929', '7142618544', '5183218302', '7034081713', '2566531047', '8183062385', '6199059997', '5183795153', '4155779573', '8188383600', '7145802000', '5083864040', '8303889553', '6233631445', '8019498233', '4256145573', '3369268945', '9145841536', '7133406122', '2163103781', '8479624121', '3018020909', '3233879695', '7403055011', '9786859095', '3233649719', '2145005884', '4802744720', '5037704822', '3023542625', '7048678607', '7047566020', '7042367406', '6235122790', '8139920303', '2016652807', '4087669701', '2105574635', '6026862743', '6466713145', '8054369396', '2024924457', '7737697528', '3233096595', '5098335586', '6196547227', '2406404084', '9522408812', '9162129282', '9163070974', '9168385630', '9169556634', '5304054518', '2565658874', '6148683851', '8003999395', '6156791688', '8439646055', '2063759659', '3373822202', '5109436373', '8283880988', '6263191015', '7143767003', '6142542665', '6144657401', '6146321458', '3472345198', '8137146110', '3307242495', '4109526586', '9095395481', '9522706718', '9253030358', '2019062193', '5166621026', '9176362222', '7189661093', '3232831954', '8138106261', '7608513941', '4094349333', '8288507788', '7602153727', '6616191117', '7608057167', '7372496006', '3602041375', '3602041374', '7036595704', '4029603392', '5616326145', '5617952461', '5612469005', '4075798009', '9102575476', '8609675698', '8058071932', '5593368864', '5595756284', '5593326868', '3108712906', '8057181643', '9404531861', '9177058179', '9095732920', '9095732921', '9093629113', '9096805649', '5057024380', '4154639930', '6783732997', '2095709441', '5702763980', '3018699812', '8058331148', '8054202060', '3103469729', '8476307272', '6788996782', '6782485340', '6788821186', '6788905013', '6788905096', '6788905107', '6788904355', '7038072351', '7039103824', '4156695457', '4159603769', '4154837661', '6788821311', '4159684920', '4152595304', '4155342731', '4155342988', '6789189218', '6787420133', '6692891025', '3147893122', '4703136459', '4707302973', '6788469341', '6174200826', '6787577217', '4703009864', '4704010846', '4704510023', '6783594041', '6783594056', '6788904668', '6787853427', '6787853290', '6787853408', '6783451734', '') GROUP BY n.prefix ORDER BY MAX(n.last_complaint) DESC;
MySQL server has gone away

SELECT COUNT(DISTINCT prefix) as cnt FROM numbers_new   WHERE 1  AND `area` = '349' AND number NOT IN('0000000000', '8003453452', '4017424376', '5025946898', '4017424376', '6142646386', '6266955561', '9737032046', '2157679159', '2032733148', '4017424376', '8584558400', '7732209807', '4168909882', '5166339750', '8584558400', '6302029819', '7204201227', '7204411544', '9547010884', '9083099649', '8002308103', '3212769784', '4044036439', '4694740489', '3522563939', '7327426126', '7182563210', '8017922010', '4052856441', '5012760565', '4135226102', '6128711145', '2817966865', '9177577058', '4152033420', '7272618747', '2482596806', '3108743294', '7154958147', '7154952887', '8478121800', '6129872195', '6025020125', '7083261582', '7083261042', '8152773987', '2177173223', '6187675008', '4698042967', '3303229952', '8774947606', '8885095601', '4145814615', '9892333224', '8005687708', '6462266922', '2392532531', '6233835658', '4253191414', '4356691942', '6514550636', '2093730582', '7072721566', '3604025349', '9512603948', '7756003796', '3014337589', '9036860071', '2122301078', '4152601421', '6093742815', '8322931934', '9165830077', '5127405120', '3037339234', '9542348058', '7542086239', '5023019220', '4153081989', '5128452482', '9709461141', '8184191707', '4049382932', '5134091678', '2129205496', '4153467975', '9174005311', '2095056891', '5039310902', '5038583067', '8607782383', '3078001470', '3524766543', '3479830205', '3018287983', '8018366788', '7083261060', '3373510329', '3376929497', '5032678732', '7608053659', '5165247482', '2014971010', '4029175354', '9083283959', '8187011575', '6023164773', '3035782196', '4074055153', '8043076106', '6129108149', '4252246645', '6602511623', '6602511575', '6602321344', '4087101357', '2088191873', '6192194601', '3053042618', '9739022524', '9727432905', '4436185804', '7205151738', '7026014711', '4784751757', '2066014959', '7323009136', '9728379939', '6096062824', '5308593952', '3107399308', '6613331363', '9739018183', '3606728402', '3608092964', '7752034205', '5025850929', '7142618544', '5183218302', '7034081713', '2566531047', '8183062385', '6199059997', '5183795153', '4155779573', '8188383600', '7145802000', '5083864040', '8303889553', '6233631445', '8019498233', '4256145573', '3369268945', '9145841536', '7133406122', '2163103781', '8479624121', '3018020909', '3233879695', '7403055011', '9786859095', '3233649719', '2145005884', '4802744720', '5037704822', '3023542625', '7048678607', '7047566020', '7042367406', '6235122790', '8139920303', '2016652807', '4087669701', '2105574635', '6026862743', '6466713145', '8054369396', '2024924457', '7737697528', '3233096595', '5098335586', '6196547227', '2406404084', '9522408812', '9162129282', '9163070974', '9168385630', '9169556634', '5304054518', '2565658874', '6148683851', '8003999395', '6156791688', '8439646055', '2063759659', '3373822202', '5109436373', '8283880988', '6263191015', '7143767003', '6142542665', '6144657401', '6146321458', '3472345198', '8137146110', '3307242495', '4109526586', '9095395481', '9522706718', '9253030358', '2019062193', '5166621026', '9176362222', '7189661093', '3232831954', '8138106261', '7608513941', '4094349333', '8288507788', '7602153727', '6616191117', '7608057167', '7372496006', '3602041375', '3602041374', '7036595704', '4029603392', '5616326145', '5617952461', '5612469005', '4075798009', '9102575476', '8609675698', '8058071932', '5593368864', '5595756284', '5593326868', '3108712906', '8057181643', '9404531861', '9177058179', '9095732920', '9095732921', '9093629113', '9096805649', '5057024380', '4154639930', '6783732997', '2095709441', '5702763980', '3018699812', '8058331148', '8054202060', '3103469729', '8476307272', '6788996782', '6782485340', '6788821186', '6788905013', '6788905096', '6788905107', '6788904355', '7038072351', '7039103824', '4156695457', '4159603769', '4154837661', '6788821311', '4159684920', '4152595304', '4155342731', '4155342988', '6789189218', '6787420133', '6692891025', '3147893122', '4703136459', '4707302973', '6788469341', '6174200826', '6787577217', '4703009864', '4704010846', '4704510023', '6783594041', '6783594056', '6788904668', '6787853427', '6787853290', '6787853408', '6783451734', '') LIMIT 1;
MySQL server has gone away