mysql> SELECT description, externalCampaign.ID, accountID ,searchEngineAccountID FROM externalCampaign left join tsacommon.accounts on accountID=accounts.id where externalCampaign.ID IN( '248260_GT', '251750_GT', '258970_GM', '261430_GM', '267061_GM', '271067_GM', '274334_GM', '274386_GM', '289250_GT', '295716_GM', '296616_GM', '301837_GT', '305561_GT', '312551_GT', '314541_GM', '315227_GT', '315716_GT', '316889_GT', '317439_GT', '334444_GT', '336899_GT', '339809_GT', '350151_GT', '351638_GT', '351756_GT', '354365_GT', '354826_GT', '355292_GT', '355699_GT', '356214_GT', '356221_GT', '356559_GT', '356763_GT', '356817_GT', '356904_GM', '356953_GT', '356991_GT', '356992_GT', '357048_GT', '357197_GT', '357263_GT', '357283_GT', '357303_GT', '357307_GT', '357317_GT', '357345_GT', '357525_GT', '357540_GT', '357586_GT', '357647_GT', '357750_GT', '357757_GT', '357888_GT', '357918_GT', '358068_GT', '358136_GT', '358155_GT', '358176_GT', '358197_GT', '358211_GT', '358214_GT', '358216_GT', '358384_GT', '358577_GT', '358695_GT', '358705_GT', '358809_GT', '358887_GT', '359186_GT', '359251_GT', '359260_GT', '359319_GT', '359555_GT', '359743_GT', '359846_GT', '359885_GT', '359904_GT', '360033_GT', '360092_GT', '360173_GT', '360246_GT', '360257_GT', '360621_GT', '361265_GT', '361299_GT', '361328_GT', '361351_GT', '361364_GT', '361475_GT', '362067_GT', '362128_GT', '362147_GT', '362148_GT', '362151_GM', '362159_GT', '362162_GM', '362268_GT', '362483_GM', '362612_GT', '362781_GT', '362809_GT', '363006_GT', '363172_GT', '363311_GT', '363382_GT', '363384_GT', '363472_GT', '363739_GM', '363936_GM', '365784_GT', '367081_GT', '368020_GT', '368804_GT', '369346_GT', '369364_GT', '369409_GT', '369479_GT', '369545_GM', '370204_GT', '370246_GM', '371729_GT', '372457_GT', '372599_GT', '374692_GT', '376593_GT', '377075_GT', '378086_GT', '378095_GT', '378231_GM', '378657_GT', '378683_GT', '379582_GM', '383672_GT', '384335_GT', '385176_GT', '385460_GT', '385733_GT', '386937_GT'); +-------------+-----------+-----------+-----------------------+ | description | ID | accountID | searchEngineAccountID | +-------------+-----------+-----------+-----------------------+ | 0016039942 | 248260_GT | 7132 | 28996 | | 0013589839 | 251750_GT | 7342 | 29114 | | 0016005537 | 258970_GM | 7851 | 27277 | | 0013688218 | 261430_GM | 7968 | 27937 | | 0015851563 | 267061_GM | 8229 | 48145 | | 0015917711 | 271067_GM | 8650 | 53608 | | 0014163825 | 274334_GM | 8738 | 54124 | | 0010179547 | 274386_GM | 8750 | 54170 | | 0010555307 | 289250_GT | 9510 | 63762 | | 0015357111 | 295716_GM | 9642 | 70617 | | 0016161305 | 296616_GM | 9729 | 71132 | | 0015777224 | 301837_GT | 9935 | NULL | | 0016144330 | 305561_GT | 10030 | 78837 | | 0010701943 | 312551_GT | 10369 | NULL | | 0014350661 | 314541_GM | 10431 | 81207 | | 0010168144 | 315227_GT | 10493 | 81626 | | 0010260902 | 315716_GT | 10536 | 81890 | | 0010801633 | 316889_GT | 10579 | 82134 | | 0014408152 | 317439_GT | 10650 | 82616 | | 0011382147 | 334444_GT | 11232 | 86266 | | 0015991056 | 336899_GT | 11781 | NULL | | 0010305119 | 339809_GT | 12213 | 91786 | | 0010687414 | 350151_GT | 13216 | 97796 | | 0014236111 | 351638_GT | 13447 | NULL | | 0014269821 | 351756_GT | 13357 | 98646 | | 0010354557 | 354365_GT | 13553 | 99850 | | 0015808614 | 354826_GT | 14077 | 102894 | | 0010272543 | 355292_GT | 13742 | 100920 | | 0015819885 | 355699_GT | 14095 | 103020 | | 0013534621 | 356214_GT | 14074 | 102870 | | 0010273463 | 356221_GT | 13896 | 101834 | | 0015158367 | 356559_GT | 13957 | 102208 | | 0010548285 | 356763_GT | 14110 | 103084 | | 0015768465 | 356817_GT | 14225 | 103782 | | 0014929588 | 356904_GM | 14216 | 103731 | | 0010095908 | 356953_GT | 14098 | 103024 | | 0010612619 | 356991_GT | 14138 | 103262 | | 0010509130 | 356992_GT | 14122 | 103152 | | 0012284088 | 357048_GT | 14143 | 103288 | | 0010263456 | 357197_GT | 14130 | 103220 | | 0010633476 | 357263_GT | 14150 | 103326 | | 0010532805 | 357283_GT | 14139 | 103264 | | 0010186639 | 357303_GT | 14120 | 103146 | | 0010394245 | 357307_GT | 14133 | 103226 | | 0010503629 | 357317_GT | 14137 | 103256 | | 0010844708 | 357345_GT | 14166 | 103450 | | 0010010305 | 357525_GT | 14238 | 103834 | | 0015269455 | 357540_GT | 14327 | 104328 | | 0014052034 | 357586_GT | 14378 | 104630 | | 0010214145 | 357647_GT | 14236 | 103832 | | 0015958847 | 357750_GT | 14441 | 105016 | | 0014566540 | 357757_GT | 14379 | 104634 | | 0015477974 | 357888_GT | 14383 | 104656 | | 0015290794 | 357918_GT | 14514 | 105520 | | 0014021896 | 358068_GT | 14477 | 105224 | | 0010752129 | 358136_GT | 14376 | 104622 | | 0012275384 | 358155_GT | 14447 | 105058 | | 0010381198 | 358176_GT | 14337 | 104386 | | 0014670957 | 358197_GT | 14390 | 104698 | | 0010601934 | 358211_GT | 14328 | 104330 | | 0011233224 | 358214_GT | 14429 | 104948 | | 0010055024 | 358216_GT | 14303 | 104212 | | 0010291458 | 358384_GT | 14306 | 105568 | | 0010169910 | 358577_GT | 14310 | 104244 | | 0010353884 | 358695_GT | 14451 | 105084 | | 0010076233 | 358705_GT | 14449 | 105066 | | 0010304356 | 358809_GT | 14431 | 104960 | | 0013256505 | 358887_GT | 14562 | 105814 | | 0010121055 | 359186_GT | 14308 | 104240 | | 0014525200 | 359251_GT | 14432 | 104974 | | 0013950689 | 359260_GT | 14565 | 105828 | | 0016087893 | 359319_GT | 14548 | 105752 | | 0013835107 | 359555_GT | 14484 | 105254 | | 0014463035 | 359743_GT | 14628 | 106220 | | 0010108478 | 359846_GT | 14342 | 104426 | | 0010475783 | 359885_GT | 14611 | 106130 | | 0015863557 | 359904_GT | 14573 | 105898 | | 0010845351 | 360033_GT | 14501 | 105446 | | 0014620996 | 360092_GT | 14581 | 105936 | | 0016203868 | 360173_GT | 14641 | 106294 | | 0014731066 | 360246_GT | 14631 | 106248 | | 0013995117 | 360257_GT | 14623 | 106210 | | 0010005368 | 360621_GT | 14605 | 106104 | | 0011109716 | 361265_GT | 14660 | 106412 | | 0010805262 | 361299_GT | 14658 | 106406 | | 0010245669 | 361328_GT | 14646 | 106336 | | 0010317858 | 361351_GT | 14593 | 106000 | | 0014825456 | 361364_GT | 14758 | 107094 | | 0015295276 | 361475_GT | 14677 | 106564 | | 0010517874 | 362067_GT | 14847 | 107712 | | 0010225825 | 362128_GT | 14813 | 107502 | | 0010234505 | 362147_GT | 14815 | 107514 | | 0013792753 | 362148_GT | 14700 | 106718 | | 0014031064 | 362151_GM | 14702 | 106731 | | 0010267072 | 362159_GT | 14899 | 108108 | | 0013686869 | 362162_GM | 14698 | 106711 | | 0014825433 | 362268_GT | 14705 | 106754 | | 0010489054 | 362483_GM | 14718 | 106833 | | 0010553841 | 362612_GT | 14721 | 106844 |Not-customized campaign | 0012698932 | 362781_GT | 14895 | 108076 | | 0010469572 | 362809_GT | 14839 | 107658 | | 0010386283 | 363006_GT | 14836 | 107634 | | 0013281300 | 363172_GT | 14896 | 108084 | | 0010465378 | 363311_GT | 14838 | 107648 | | 0010850692 | 363382_GT | 14883 | 107990 | | 0010263023 | 363384_GT | 14898 | 108096 | | 0010214465 | 363472_GT | 14812 | 107482 | | 0011443825 | 363739_GM | 15427 | 111247 | | 0014755385 | 363936_GM | 15359 | 110869 |Not-customized campaign | 0010592205 | 365784_GT | 14857 | 107840 | | 0013863870 | 367081_GT | 15079 | 109304 |Not-customized campaign | 0014649561 | 368020_GT | 15232 | 110112 | | 0010339311 | 368804_GT | 15179 | NULL | | 0010766373 | 369346_GT | 15141 | NULL | | 0013691154 | 369364_GT | 15148 | 109652 | | 0014093158 | 369409_GT | 15151 | 109670 | | 0010617144 | 369479_GT | 15540 | 111886 | | 0014309942 | 369545_GM | 15220 | 110059 | | 0010215108 | 370204_GT | 15267 | 110264 | | 0015288901 | 370246_GM | 15597 | 112177 |Not-customized campaign | 0010277743 | 371729_GT | 15729 | 112926 | | 0015470805 | 372457_GT | 15959 | 114156 |Not-customized campaign | 0010026442 | 372599_GT | 15784 | 113226 | | 0015783923 | 374692_GT | 16256 | 116004 | | 0016002408 | 376593_GT | 16334 | 116432 | | 0015817639 | 377075_GT | 16702 | 118566 | | 0014730603 | 378086_GT | 16675 | 118422 | | 0014087824 | 378095_GT | 16600 | 118020 | | 0015419289 | 378231_GM | 16535 | 117693 | | 0013413859 | 378657_GT | 16754 | 118818 | | 0014575480 | 378683_GT | 16746 | 118762 | | 0010230225 | 379582_GM | 16395 | 116839 | | 0016229000 | 383672_GT | 16781 | 118970 | | 0016209804 | 384335_GT | 17200 | 121672 |Not-customized campaign | 0010229695 | 385176_GT | 17408 | 122802 |Customized campaign | 0010756972 | 385460_GT | 17011 | 120330 |Customized campaign | 0010192666 | 385733_GT | 17119 | 121126 |Not-customized campaign with Google. | 0010295770 | 386937_GT | 17213 | 121728 | +-------------+-----------+-----------+-----------------------+ 138 rows in set (0.01 sec)