select companies.compid, companies.company, companies.date, DATE_FORMAT(companies.date, '%e %M, %Y') as formattedregistrationdate, locations.location, locations.countryid, companies.description, companies.bid, companies.logo, companies.siteid, companies.aaaa, companies.ip, (TO_DAYS(NOW()) - TO_DAYS(companies.lastlogindate)) as days_activity, companies.businesstypeids, companies.verifyid, companies.verifytime, companies.lastmodified, companies.lastlogindate, companies.totalpayments, companies.signuppayment, companies.mws, descriptionlength, companies.cantdoanything, companies.cantdoanythingdetails, companies.sellwords, companies.buywords, companies.tradeleadnumber, companies.productnumber from (companies, locations) where companies.locationid = locations.locationid and companies.cantdoanything = 0 and companies.compid in (405283,348746,680150,694612,529760,744639,484908,459484,425870,708039,150494,902386,338052,350268,225779,588414,721533,599001,768863,824371) and companies.compid in (224872,559890,1128346,838689,167927,293292,414126,537644,668129,768863,885599,949918,1038409,28006,222484,304986,362563,427815,469367,566533,680150,746542,836569,888533,937528,987441,1058829,1119393,153094,338389,437284,539350,676172,818587,924880,1071161,1030773,428084,826641,1142349,242748,845301,179038,467157,1087403,536545,199129,573374,1019786,321325,605032,251292,573122,1129794,919416,170656,301403,419171,541978,668752,779787,886424,950665,1051532,127214,229549,306109,368746,431375,470055,575545,682265,752848,840182,889081,939124,987591,1060539,1123411,155499,340143,438647,554264,679015,833824,931782,1074821,1058209,448119,839408,971739,936356,225779,285990,425870,1130450,539316,208740,615040,1051585,492968,517182,269609,585893,1140365,956367,173494,301909,420493,551641,669196,781782,894934,966881,1059647,139127,235538,307035,374581,433084,483705,578612,685895,752953,844246,889153,939400,988148,1064449,1126644,164936,343251,441928,555190,681480,834758,934200,1092347,150808,452804,844727,792371,903409,380933,470070,400033,1133233,597315,244764,689001,1054294,699649,439538,290464,649216,163661,989296,180412,302584,424266,554843,674973,786946,899393,967939,1066419,145907,237081,307246,374620,445074,484175,591307,686114,761205,845011,893328,946084,996157,1066210,1127970,167086,349134,451623,563823,690362,840318,944182,1092905,172515,498408,871036,901338,194360,695031,591428,390560,1137020,673926,268188,700652,1096872,733959,383009,297386,656666,249486,1023809,196053,315677,430551,576198,676972,806149,902386,972738,1082247,150494,239587,308031,378630,447150,489779,601220,687282,764581,846155,894006,957880,1002828,1066225,1128714,174977,355972,457088,569545,691015,849590,955126,1101505,188006,505622,899866,1010401,386733,817304,694612,378306,1124773,714176,286779,719037,1143494,775782,1071447,303579,678473,312192,1035424,202300,316849,441070,584581,719286,806947,904877,978527,1083230,159931,241977,308583,380576,449609,499017,602054,697602,775678,851442,900878,958798,1012110,1074389,1129623,176371,365152,459541,584284,692036,851733,975707,1150859,197547,523562,902445,979978,555150,416011,704007,370826,94530,956721,288731,735800,87099,784319,315148,716904,317646,1056035,211363,324415,457447,585961,720307,822534,911409,986296,1093323,160680,259582,318382,384098,453364,515824,613275,708039,783262,853761,902885,963504,1015674,1076850,1129886,180393,385687,466450,606004,708145,855095,975859,187415,270795,575437,905404,969289,903153,472025,590389,357381,184050,959611,298858,773985,140165,853831,353212,888942,322457,1081697,213759,361920,461049,593822,721533,826252,912073,988849,1094361,163095,276426,320908,393652,454240,519499,615935,710918,796238,859065,903637,969124,1016503,1078238,1135262,211120,390020,467221,622175,715947,862207,983352,348746,272464,608957,953458,945285,484950,812774,667536,321877,198547,991179,321831,786020,467468,1048054,465785,897700,509997,1101165,216006,366952,481122,594065,722436,827086,918519,990116,1097643,184870,278629,324051,397362,454673,523643,621064,711822,798295,861921,908824,978719,1016598,1082156,1137333,217616,392532,478509,629952,717939,870081,1000036,459484,284953,666821,984475,479018,652529,812209,599001,314299,228991,1007068,330037,840150,467590,1118360,482664,922961,625640,1135051,233632,375088,484908,603706,740785,829691,919511,992904,1098274,191478,281201,333911,403114,459209,541965,631846,716206,807995,865904,913490,980088,1024284,1085217,1148037,244385,392768,485920,631247,719535,877115,1001991,487083,284957,676904,1001990,914369,863950,785186,491120,262094,311932,1009994,368768,882161,485866,387698,492856,929054,669451,1053714,257400,393342,491882,607659,741000,831512,925055,994290,1102132,192335,287917,350268,406181,460922,543690,640125,719069,811842,866561,915143,980793,1027919,1086249,1150762,254144,405689,492430,631880,725701,886559,1002943,699607,316204,679147,1004435,940201,879751,1124007,549239,257113,338052,1028936,397178,899002,549333,802722,0,500716,934437,675525,1053717,260430,394701,502141,630341,742480,837684,937056,1000881,1102548,197086,295775,351039,407669,461345,546310,649730,721921,815975,882173,916935,981150,1030641,1093602,1151125,258383,405925,506676,633176,732378,887142,1029086,764279,323287,755659,1005667,263337,893234,781776,547451,231863,357614,1065718,414302,966636,658288,595921,61547,527780,939059,701920,6954,271271,395277,503338,637473,751140,852082,943445,1002859,1110126,208817,295861,354476,414852,462871,549572,663416,731096,817307,883536,919181,981535,1035706,1098634,1152366,293188,429168,512004,650504,739301,894135,1031791,823502,329711,759000,1010751,456885,871467,778742,545179,137816,405283,1073666,438989,966728,814730,785949,180332,547457,948440,763723,150765,274154,398603,506750,637495,755751,857576,945055,1016781,1142071,211523,298833,355848,420221,463802,562941,664238,731165,824371,884940,922077,984600,1041929,1103844,57244,309785,431540,528502,652977,757557,917707,1035077,831054,330901,767431,1018634,814544,732577,771942,532498,137509,432431,1085219,460796,974828,897738,723952,184154,554388,969227,781636,153440,279409,405542,531501,643070,756040,870130,945241,1034118,1143946,215904,299556,358047,424630,464672,564198,665174,734014,826813,886390,931698,985634,1042307,1108316,151297,327106,434349,538253,653695,759844,921709,1045303,870942,359954,782087,1043803,938100,466793,719755,512091,135128,495273,320004,507306,999343,163328,607765,191009,558299,1034377,800418,158163,283647,410631,534741,654828,760657,885171,947315,1036184,1155838,216428,302348,358758,424790,465274,565137,667918,744639,831573,887398,933885,987039,1046721,1109161,152730,328206,435461,539059,658869,793720,922989,1057300,977330,422812,812256,1118231,588414,849049,161209,472204,116469,516272,257,529760,1004858,258415,238488) order by companies.bid desc, companies.rating desc, companies.totalpayments desc, companies.logincounter desc, companies.signuppayment desc, descriptionlength desc, companies.compid desc