SELECT * FROM (SELECT /*+ FIRST_ROWS(50) */ SITE_CODE,(SELECT UNIT || ' ' || NAME FROM SITE WHERE SITE_CODE_EXIST=A.SITE_CODE AND SITE_TYPE_ID = 5) SITE_NAME,LOCATION_CODE,LOCATION_NAME,POWER,SUSPECT_CATEGORY,JUMLAH,ROW_NUMBER() OVER (ORDER BY POWER DESC) RN , MAX(ROWNUM) OVER ( ORDER BY NULL) CNT FROM ( SELECT SITE_CODE,LOCATION_CODE,LOCATION_NAME,POWER,SUSPECT_CATEGORY,COUNT(*) JUMLAH FROM SUSPECT_LOADPROFILE WHERE SUSPECT_CATEGORY = '1' AND DATE_READ BETWEEN '20190601' AND '20190610'    GROUP BY SITE_CODE,LOCATION_CODE,LOCATION_NAME,POWER,SUSPECT_CATEGORY ) A WHERE ( SITE_CODE IN ('SUM','11','11BNA','11110','11111','11112','11113','11114','11115','11LSA','11330','11331','11332','11333','11334','11335','11LSM','11220','11221','11222','11223','11224','11225','11226','11227','11228','11229','11230','11MBO','11440','11441','11442','11443','11444','11SBS','11550','11551','11552','11553','11554','11555','11556','11SGL','11660','11661','11662','12','12120','12001','12002','12003','12004','12010','12011','12012','12013','12014','12121','12101','12110','12111','12112','12113','12114','12115','12116','12117','12118','12119','12102','12122','12201','12202','12203','12210','12211','12212','12213','12214','12215','12216','12217','12218','12219','12221','12123','12301','12310','12311','12312','12313','12314','12315','12124','12401','12410','12411','12412','12413','12414','12415','12125','12501','12510','12511','12512','12513','12514','12515','12516','12126','12610','12611','12612','12613','12614','12615','12616','12617','12127','12710','12711','12712','12128','12801','12802','12803','12804','12129','12901','12902','12903','12904','12905','12906','13','13100','13101','13102','13103','13104','13105','13106','13107','13108','13109','13110','13111','13112','13200','13221','13222','13223','13224','13225','13226','13227','13300','13331','13332','13333','13334','13335','13336','13337','13338','13339','13400','13451','13452','13453','13454','14','14BKL','14500','14510','14600','14610','14620','14630','14640','14660','14680','14690','14JMB','14300','14310','14320','14350','14360','14390','14LHT','14700','14710','14720','14730','14740','14750','14760','14770','14780','14790','14850','14MBO','14400','14410','14420','14430','14440','14450','14460','14PLB','14100','14110','14120','14130','14200','14220','14230','14240','14250','14260','14OGI','14900','14910','14930','14920','16','16BGK','16100','16110','16120','16130','16140','16TJP','16300','16310','16320','17','17171','17100','17110','17120','17130','17131','17150','17180','17172','17200','17210','17220','17230','17240','17250','17260','17270','17280','17173','17300','17330','17360','17370','17380','17340','18','18DMI','18210','18220','18230','18240','18250','18260','18270','18PKU','18110','18111','18120','18130','18140','18150','18160','18170','18180','18190','18112','18113','18114','18RGT','18410','18420','18430','18440','18450','18TPI','18301','18302','18303','18304','18305','18306','18307','18308','18309','18310','JBB','54','54110','54110','54130','54130','54210','54210','54310','54310','54330','54330','54360','54360','54380','54380','54410','54410','54420','54420','54510','54510','54530','54530','54630','54630','54710','54710','54720','54720','54730','54730','54740','54740','54830','54840','56','56100','56110','56130','56120','56140','56150','56200','56210','56220','56230','56240','56610','56610','56620','56620','56640','56640','56660','56660','56820','56820','JBT','52','52000','52001','52002','52003','52004','52005','52006','52007','52008','52050','52051','52052','52053','52054','52055','52056','52057','52058','52059','52060','52061','52090','52099','52100','52101','52102','52103','52104','52105','52106','52107','52108','52150','52151','52152','52153','52154','52155','52156','52157','52200','52201','52202','52203','52204','52205','52206','52207','52250','52251','52252','52253','52254','52255','52256','52257','52258','52259','52260','52300','52301','52302','52303','52304','52305','52306','52308','52309','52310','52350','52351','52352','52353','52400','52401','52402','52403','52404','52405','52450','52451','52452','52453','52454','52500','52501','52502','52503','52504','52505','52506','52550','52551','52552','52553','52554','52650','52651','52652','52653','52654','52655','53','53BDG','53551','53555','53559','53563','53567','53571','53575','53577','53BGR','53811','53821','53825','53831','53841','53851','53853','53BKS','53711','53721','53731','53732','53741','53742','53751','53761','53762','53771','53CJR','53661','53671','53681','53691','53695','53CKR','53CMI','53581','53585','53589','53592','53595','53598','53599','53CRB','53311','53321','53331','53341','53351','53361','53371','53381','53DPK','53871','53872','53873','53874','53875','53GPI','53861','53865','53867','53GRT','53271','53276','53277','53286','53293','53KRW','53461','53468','53475','53476','53482','53MJA','53531','53532','53533','53534','53535','53536','53PWK','53411','53421','53425','53431','53444','53SKI','53611','53621','53631','53641','53651','53659','53SMD','53511','53517','53521','53527','53TSK','53211','53221','53231','53241','53251','53261','53265','53CKG','53701','53702','53703','53704','53IDM','53401','53402','53403','53404','JTBN','43','43FBB','43700','43730','43740','43760','43770','43FBT','43500','43530','43550','43570','43KPG','43100','43110','43130','43150','43160','43180','43190','43SMB','43300','43350','43380','44','44BIM','44300','44310','44320','44330','44340','44MTR','44110','44120','44130','44140','44150','44160','44SBW','44200','44210','44220','44230','44240','51','51BJN','51801','51802','51803','51804','51805','51806','51807','51808','51BWG','51670','51671','51672','51673','51675','51GSK','51120','51121','51122','51123','51JBR','51601','51602','51603','51604','51605','51606','51607','51608','51609','51KDR','51401','51402','51403','51404','51405','51406','51408','51409','51410','51411','51412','51MDN','51501','51503','51504','51505','51507','51508','51509','51MJK','51450','51452','51453','51454','51455','51456','51457','51458','51459','51460','51MLG','51301','51302','51303','51304','51305','51306','51307','51308','51309','51310','51311','51312','51313','51314','51PMK','51700','51710','51720','51730','51740','51750','51760','51770','51780','51790','51715','51PON','51540','51541','51542','51543','51PSR','51350','51351','51352','51353','51354','51355','51356','51357','51358','51SBB','51161','51162','51163','51SBS','51140','51141','51142','51143','51146','51SBU','51101','51102','51103','51104','51105','51106','51SDA','51180','51181','51182','51STB','51650','51651','51652','51653','51654','55','55JTM','55400','55410','55420','55SLT','55100','55110','55120','55130','55140','55TMR','55200','55210','55220','55230','55UTR','55300','55310','55320','55330','55340','KAL','21','21KTP','21400','21410','21420','21430','21PTK','21100','21101','21102','21110','21120','21121','21140','21SGU','21300','21310','21330','21360','21370','21380','21SKW','21200','21210','21220','21230','21240','21250','22','22BJM','22100','22110','22120','22130','22140','22150','22160','22BRB','22200','22210','22220','22230','22240','22250','22260','22270','22KKP','22500','22510','22520','22530','22540','22550','22KTB','22300','22320','22330','22PRY','22400','22410','22420','22430','22440','22450','22460','22470','22480','23','23BPN','23200','23201','23211','23220','23222','23230','23BRU','23300','23320','23350','23360','23BTG','23400','23420','23SMD','23100','23102','23112','23120','23141','23156','23157','23TRK','23500','SUL','31','31100','31101','31102','31110','31120','31130','31140','31150','31160','31170','31180','31190','31200','31210','31211','31220','31230','31240','31250','31260','31270','31280','31290','31500','31501','31520','31530','31540','31550','31600','31601','31610','31620','31630','31650','31700','31710','31720','31730','31740','31750','31760','31800','31801','31810','31820','31830','31840','31850','31860','31870','31900','31910','31920','31930','31940','31950','32','32AMS','32111','32121','32131','32141','32151','32161','32AMU','32010','32020','32030','32040','32CBB','32810','32820','32830','32840','32850','32CBK','32710','32720','32730','32740','32750','32760','32770','32CKD','32320','32330','32340','32350','32360','32370','32380','32CMJ','32910','32920','32930','32940','32950','32960','32CPG','32410','32420','32430','32440','32450','32CPL','32610','32620','32630','32640','32650','32660','32680','32CPR','32510','32520','32530','32540','32550','32560','32570','32CWP') OR SITE_CODE IN ('32210','32240','32250','32260','32270','32280','32MKS','32110','32120','32130','32140','32150','32156','32160','32170','32180','32190','MP','41','41ABN','41111','41130','41134','41140','41142','41150','41151','41160','41180','41189','41199','41MSH','41410','41420','41430','41440','41450','41SFF','41510','41520','41530','41540','41550','41560','41TAL','41310','41330','41350','41320','41380','41TNT','41210','41220','41230','41260','41280','41290','41291','41292','41TBO','41610','41620','41SLK','41710','41720','42','42BIK','42210','42220','42230','42240','42JYP','42110','42120','42130','42140','42150','42160','42170','42180','42MNK','42410','42420','42430','42440','42450','42MRK','42510','42520','42530','42540','42550','42SOR','42310','42320','42330','42340','42350','42360','42370','42TMK','42610','42620','42630','42NBR','42710','42720','42WMN','42810','42820','PST') )  )  WHERE RN BETWEEN (((1-1) * 100) + 1)  AND (1 * 100) ORDER BY RN