SELECT p.*, c.name as company_name, r.name as rate_center_name FROM prefix2 AS p  LEFT JOIN companies AS c ON c.id = p.company LEFT JOIN rate_centers AS r ON r.id = p.rate_center  WHERE 1  AND p.`area` = '919' AND p.`prefix` = '974' LIMIT 1;
Lost connection to MySQL server during query

SELECT * FROM numbers_new   WHERE 1  AND `prefix` = '974' AND `area` = '919' 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', '') ORDER BY last_complaint DESC;
MySQL server has gone away

SELECT COUNT(*) as cnt FROM numbers_new   WHERE 1  AND `prefix` = '974' AND `area` = '919' LIMIT 1;
MySQL server has gone away

SELECT c.*
                FROM reported_demo.comments c
                JOIN (
                    SELECT number, MAX(id) AS max_id
                    FROM reported_demo.comments
                    WHERE number LIKE '919974%'
                    GROUP BY number
                ) max_ids
                ON c.number = max_ids.number AND c.id = max_ids.max_id
                ORDER BY c.id DESC LIMIT 10
MySQL server has gone away