select cpe.sku, CONCAT(cpv.value , "?size=", size.value) from catalog_product_entity_varchar cpv left join catalog_product_entity cpe on cpe.row_id = cpv.row_id left join catalog_product_super_link sl on sl.product_id = cpe.entity_id left join catalog_product_entity par on par.row_id = sl.parent_id left join catalog_product_entity_varchar size on par.row_id = size.row_id and size.attribute_id = 635 and size.store_id = 0 where cpv.row_id in (select row_id from catalog_product_entity where sku in (000000000100005431,000000000100091633,000000000100107312,000000000100010428,000000000100097824,000000000100083117,000000000100093548,000000000100082096,000000000100087235,000000000100108212,000000000100096733,000000000100100948,000000000100006523,000000000100100756,000000000100086974,000000000100086913,000000000100086894,000000000100088795,000000000100108515,000000000100087156,000000000100088424,000000000100078665,000000000100092265,000000000100100944,000000000100088748,000000000100147966,000000000100107329,000000000100093699,000000000100097483,000000000100098119,000000000100095652,000000000100107125,000000000100100949,000000000100001671,000000000100108296,000000000100090643,000000000100005325,000000000100108389,000000000100093561,000000000100000677,000000000100005433,000000000100005282,000000000100127534,000000000100008736,000000000100120484,000000000100123337,000000000100088587,000000000100082948,000000000100097000,000000000100106157,000000000100091181,000000000100101448,000000000100001439,000000000100011492,000000000100106792,000000000100005736,000000000100088595,000000000100006585,000000000100011929,000000000100107132,000000000100086919,000000000100011086,000000000100081981,000000000100097821,000000000100004203,000000000100087687,000000000100106722,000000000100092575,000000000100086910,000000000100004171,000000000100004223,000000000100091423,000000000100108165,000000000100080946,000000000100005401,000000000100011585,000000000100091115,000000000100005429,000000000100087744,000000000100005286,000000000100084141,000000000100092305,000000000100084060,000000000100086934,000000000100088648,000000000100096182,000000000100010722,000000000100011079,000000000100000656,000000000100093585,000000000100088851,000000000100124853,000000000100008730,000000000100088642,000000000100088724,000000000100080708,000000000100106571,000000000100092267,000000000100120474,000000000100011403,000000000100080954,000000000100087701,000000000100097833,000000000100006531,000000000100006492,000000000100096728,000000000100120472,000000000100091634,000000000100009429,000000000100088701,000000000100107383,000000000100085939,000000000100120482,000000000100106286,000000000100106106,000000000100097020,000000000100083185,000000000100089835,000000000100009290,000000000100087273,000000000100097132,000000000100095840,000000000100005290,000000000100011490,000000000100108283,000000000100101421,000000000100085185,000000000100096882,000000000100005435,000000000100094923,000000000100088837,000000000100085384,000000000100004182,000000000100086972,000000000100096248,000000000100087860,000000000100093696,000000000100095650,000000000100091109,000000000100088340,000000000100108307,000000000100087682,000000000100087513,000000000100007373,000000000100107344,000000000100108305,000000000100096021,000000000100088646,000000000100120504,000000000100004903,000000000100120438,000000000100001661,000000000100005397,000000000100081703,000000000100108383,000000000100088505,000000000100097035,000000000100011948,000000000100089139,000000000100006560,000000000100004188,000000000100094927,000000000100087663,000000000100106171,000000000100106824,000000000100000740,000000000100001333,000000000100085972,000000000100087174,000000000100096742,000000000100081212,000000000100004235,000000000100106301,000000000100086916,000000000100090840,000000000100084069,000000000100106730,000000000100108206,000000000100082537,000000000100078026,000000000100086598,000000000100085184,000000000100094844,000000000100009276,000000000100081566,000000000100097126,000000000100092300,000000000100106826,000000000100090650,000000000100006543,000000000100097703,000000000100010682,000000000100125307,000000000100011937,000000000100106107,000000000100083523,000000000100107315,000000000100094428,000000000100116774,000000000100108294,000000000100093097,000000000100089171,000000000100137905,000000000100086817,000000000100106732,000000000100092268,000000000100096020,000000000100089049,000000000100106705,000000000100095569,000000000100011923,000000000100108198,000000000100106727,000000000100080980,000000000100097701,000000000100010693,000000000100106832,000000000100092455,000000000100087683,000000000100083894,000000000100001481,000000000100094831,000000000100092266,000000000100108326,000000000100093549,000000000100108376,000000000100106174,000000000100091523,000000000100137788,000000000100006557,000000000100088469,000000000100086635,000000000100121573,000000000100108284,000000000100088720,000000000100094914,000000000100096693,000000000100126537,000000000100084928,000000000100087277,000000000100087292,000000000100080966,000000000100088728,000000000100088280,000000000100091988,000000000100004165,000000000100084943,000000000100108170,000000000100093335,000000000100120505,000000000100088527,000000000100106794,000000000100010668,000000000100006483,000000000100005439,000000000100005320,000000000100001622,000000000100010758,000000000100008758,000000000100005306,000000000100092327,000000000100086971,000000000100087251,000000000100088329,000000000100107313,000000000100120479,000000000100088968,000000000100100941,000000000100088761,000000000100106637,000000000100011060,000000000100081196,000000000100106707,000000000100085679,000000000100095283,000000000100094381,000000000100010718,000000000100088749,000000000100080989,000000000100094333,000000000100081236,000000000100106825,000000000100092472,000000000100090660,000000000100081192,000000000100087414,000000000100005405,000000000100086597,000000000100097030,000000000100092148,000000000100086392,000000000100088480,000000000100094853,000000000100010663,000000000100092288,000000000100081983,000000000100088341,000000000100087312,000000000100092306,000000000100134526,000000000100106288,000000000100120529,000000000100005451,000000000100137891,000000000100097142,000000000100011405,000000000100100789,000000000100107117,000000000100095207,000000000100095203,000000000100108166,000000000100106726,000000000100089191,000000000100006513,000000000100101422,000000000100108173,000000000100123338,000000000100107356,000000000100010402,000000000100085038,000000000100010562,000000000100005370,000000000100011939,000000000100093904,000000000100096022,000000000100005280,000000000100098307,000000000100108238,000000000100108200,000000000100010705,000000000100097024,000000000100010432,000000000100087113,000000000100006551,000000000100108167,000000000100094427,000000000100096242,000000000100087802,000000000100085460,000000000100011393,000000000100006539,000000000100127532,000000000100120439,000000000100097818,000000000100096801,000000000100082535,000000000100005391,000000000100108171,000000000100007161,000000000100084288,000000000100108174,000000000100108387,000000000100087708,000000000100086630,000000000100098378,000000000100097239,000000000100005265,000000000100088606,000000000100137787,000000000100091637,000000000100100787,000000000100088387,000000000100006051,000000000100084909,000000000100001213,000000000100006533,000000000100092758,000000000100096246,000000000100087255,000000000100097026,000000000100098377,000000000100097018,000000000100096887,000000000100011416,000000000100087474,000000000100086812,000000000100134602,000000000100004240,000000000100005308,000000000100096990,000000000100092754,000000000100097834,000000000100097830,000000000100091209,000000000100106331,000000000100095570,000000000100088760,000000000100004266,000000000100084942,000000000100096694,000000000100106332,000000000100091593,000000000100107123,000000000100095843,000000000100090427,000000000100003847,000000000100080905,000000000100108384,000000000100087800,000000000100097109,000000000100096018,000000000100094920,000000000100011940,000000000100092568,000000000100010686,000000000100079556,000000000100091373,000000000100092122,000000000100101926,000000000100095205,000000000100108169,000000000100097125,000000000100093580,000000000100088940,000000000100082009,000000000100006742,000000000100106704,000000000100107131,000000000100000026,000000000100106240,000000000100107314,000000000100093710,000000000100091260,000000000100088824,000000000100006530,000000000100108375,000000000100005416,000000000100011925,000000000100005331,000000000100088461,000000000100095842,000000000100094683,000000000100088789,000000000100094366,000000000100092579,000000000100082255,000000000100094442,000000000100092341,000000000100107113,000000000100097482,000000000100011573,000000000100107380,000000000100078098,000000000100094840,000000000100086455,000000000100005340,000000000100089430,000000000100108172,000000000100092475,000000000100094331,000000000100087668,000000000100084740,000000000100107240,000000000100087554,000000000100096183,000000000100106717,000000000100088784,000000000100006500,000000000100088842,000000000100083735,000000000100107333,000000000100091622,000000000100000739,000000000100081756,000000000100108521,000000000100011078,000000000100095204,000000000100096768,000000000100091808,000000000100087275,000000000100011933,000000000100092329,000000000100091440,000000000100088463,000000000100006498,000000000100095571,000000000100009529,000000000100091509,000000000100086915,000000000100096685,000000000100093337,000000000100108487,000000000100095844,000000000100010664,000000000100107300,000000000100005342,000000000100096705,000000000100107241,000000000100106638,000000000100002696,000000000100010347,000000000100096175,000000000100007841,000000000100086893,000000000100083179,000000000100095028,000000000100107379,000000000100101927,000000000100088485,000000000100004251,000000000100096993,000000000100005426,000000000100009331,000000000100084194,000000000100081163,000000000100132657,000000000100108327,000000000100107239,000000000100092193,000000000100107134,000000000100107299,000000000100107128,000000000100094440,000000000100006564,000000000100097117,000000000100097244,000000000100004233,000000000100106721,000000000100087539,000000000100106827,000000000100092160,000000000100097120,000000000100093547,000000000100094425,000000000100011395,000000000100094977,000000000100083874,000000000100082371,000000000100002584,000000000100081211,000000000100096812,000000000100086899,000000000100084929,000000000100004259,000000000100107130,000000000100091375,000000000100002687,000000000100081134,000000000100001660,000000000100092285,000000000100120514,000000000100094335,000000000100096178,000000000100088782,000000000100011489,000000000100107111,000000000100095206,000000000100108306,000000000100004195,000000000100082949,000000000100096767,000000000100083177,000000000100127531,000000000100106170,000000000100083180,000000000100091467,000000000100089756,000000000100088447,000000000100107368,000000000100091376,000000000100091323,000000000100081177,000000000100106153,000000000100137893,000000000100094182,000000000100004169,000000000100083184,000000000100096174,000000000100005445,000000000100005356,000000000100002692,000000000100094902,000000000100087728,000000000100012001,000000000100091709,000000000100093336,000000000100081783,000000000100003841,000000000100098125,000000000100108213,000000000100005368,000000000100079551,000000000100107238,000000000100096241,000000000100095574,000000000100005981,000000000100121806,000000000100093697,000000000100088816,000000000100120509,000000000100090646,000000000100097002,000000000100086918,000000000100084780,000000000100011609,000000000100093339,000000000100010688,000000000100005389,000000000100084154,000000000100006496,000000000100006510,000000000100097240,000000000100107133,000000000100003956,000000000100097128,000000000100132177,000000000100133197,000000000100143246,000000000100097118,000000000100108205,000000000100107327,000000000100081000,000000000100087170,000000000100093569,000000000100081122,000000000100088360,000000000100077736,000000000100009311,000000000100101928,000000000100098120,000000000100086792,000000000100124860,000000000100006515,000000000100087213,000000000100087785,000000000100080952,000000000100094854,000000000100008367,000000000100080971,000000000100120523,000000000100088688,000000000100087157,000000000100097112,000000000100132297,000000000100002612,000000000100106728,000000000100005408,000000000100005366,000000000100083698,000000000100000741,000000000100087376,000000000100091527,000000000100006912,000000000100106636,000000000100090436,000000000100005333,000000000100120506,000000000100088386,000000000100098376,000000000100085179,000000000100011366,000000000100084923,000000000100134533,000000000100107298,000000000100011401,000000000100093332,000000000100093360,000000000100010674,000000000100097241,000000000100006580,000000000100096793,000000000100107339,000000000100003434,000000000100085050,000000000100091597,000000000100121250,000000000100005327,000000000100086396,000000000100081774,000000000100108393,000000000100100947,000000000100097828,000000000100001450,000000000100100943,000000000100090663,000000000100116733,000000000100081195,000000000100108287,000000000100108185,000000000100084908,000000000100005403,000000000100005293,000000000100108199,000000000100004176,000000000100009296,000000000100011108,000000000100005739,000000000100094682,000000000100097744,000000000100001972,000000000100083577,000000000100009306,000000000100137895,000000000100096181,000000000100091681,000000000100085031,000000000100080953,000000000100108325,000000000100106650,000000000100094833,000000000100123336,000000000100011960,000000000100086897,000000000100090004,000000000100093098,000000000100009300,000000000100083261,000000000100094855,000000000100120525,000000000100097738,000000000100093351,000000000100106795,000000000100011580,000000000100081584,000000000100097025,000000000100003271,000000000100088796,000000000100100800,000000000100100801,000000000100087314,000000000100126727,000000000100010659,000000000100088152,000000000100088465,000000000100093095,000000000100095159,000000000100108160,000000000100087322,000000000100006582,000000000100088320,000000000100084413,000000000100081569,000000000100091506,000000000100093545,000000000100005980,000000000100120517,000000000100091596,000000000100004225,000000000100086499,000000000100010716,000000000100088685,000000000100081001,000000000100091391,000000000100134258,000000000100005288,000000000100106823,000000000100090414,000000000100092043,000000000100088362,000000000100001415,000000000100004167,000000000100087153,000000000100094385,000000000100086511,000000000100086932,000000000100131569,000000000100088564,000000000100106158,000000000100002674,000000000100088529,000000000100108395,000000000100091503,000000000100084292,000000000100011931,000000000100081074,000000000100001989,000000000100096740,000000000100009357,000000000100108473,000000000100086850,000000000100087788,000000000100004180,000000000100005332,000000000100090495,000000000100081198,000000000100107301,000000000100093675,000000000100096177,000000000100091445,000000000100087760,000000000100006541,000000000100003782,000000000100007316,000000000100094827,000000000100084745,000000000100094013,000000000100123410,000000000100087318,000000000100087534,000000000100096016,000000000100088361,000000000100106725,000000000100095572,000000000100080758,000000000100088286,000000000100107326,000000000100007194,000000000100089718,000000000100094828,000000000100002610,000000000100127533,000000000100147959,000000000100087324,000000000100094900,000000000100093546,000000000100137907,000000000100087297,000000000100120477,000000000100094979,000000000100011076,000000000100092281,000000000100100751,000000000100106719,000000000100093560,000000000100120515,000000000100092149,000000000100005378,000000000100083121,000000000100088460,000000000100093352,000000000100094924,000000000100004193,000000000100094360,000000000100100961,000000000100091263,000000000100107350,000000000100087807,000000000100087740,000000000100001528,000000000100006520,000000000100007165,000000000100091358,000000000100004249,000000000100087173,000000000100009340,000000000100107318,000000000100097823,000000000100011104,000000000100086710,000000000100006549,000000000100092174,000000000100096872,000000000100087747,000000000100006535,000000000100088546,000000000100106639,000000000100084926,000000000100006528,000000000100087703,000000000100120489,000000000100078099,000000000100094424,000000000100088287,000000000100083829,000000000100011397,000000000100081176,000000000100106793,000000000100011958,000000000100093562,000000000100100962,000000000100137892,000000000100100755,000000000100097116,000000000100108276,000000000100002681,000000000100088365,000000000100106724,000000000100136025,000000000100128844,000000000100089198,000000000100108168,000000000100006487,000000000100006570,000000000100097737,000000000100134603,000000000100123339,000000000100001375,000000000100093698,000000000100097044,000000000100087512,000000000100100753,000000000100107302,000000000100127535,000000000100092428,000000000100011589,000000000100006547,000000000100006522,000000000100079652,000000000100108164,000000000100004197,000000000100106716,000000000100096245,000000000100010690,000000000100081773,000000000100084846,000000000100097237,000000000100097746,000000000100106706,000000000100120528,000000000100088787,000000000100091370,000000000100006578,000000000100077857,000000000100088762,000000000100097238,000000000100095284,000000000100096236,000000000100010498,000000000100010666,000000000100002695,000000000100089245,000000000100003836,000000000100107381,000000000100097484,000000000100086816,000000000100094426,000000000100011102,000000000100011935,000000000100084407,000000000100006038,000000000100097829,000000000100091183,000000000100079738,000000000100088281,000000000100087706,000000000100137773,000000000100092597,000000000100108186,000000000100005284,000000000100094429,000000000100084922,000000000100005006,000000000100087688,000000000100095223,000000000100096017,000000000100004229,000000000100116693,000000000100082280,000000000100088363,000000000100106796,000000000100093676,000000000100011584,000000000100121574,000000000100084924,000000000100107382,000000000100138506,000000000100097739,000000000100096886,000000000100084081,000000000100087789,000000000100005978,000000000100110415,000000000100006512,000000000100088522,000000000100095030,000000000100011582,000000000100007314,000000000100097243,000000000100101470,000000000100087913,000000000100088798,000000000100087596,000000000100004227,000000000100083160,000000000100137898,000000000100088600,000000000100101426,000000000100120507,000000000100106729,000000000100006562,000000000100108210,000000000100088625,000000000100091142,000000000100094338,000000000100082372,000000000100011927,000000000100088328,000000000100002604,000000000100088288,000000000100004245,000000000100002074,000000000100088833,000000000100095841,000000000100086791,000000000100097242,000000000100094891,000000000100009441,000000000100098375,000000000100004239,000000000100004184,000000000100004209,000000000100106715,000000000100107319,000000000100088802,000000000100088389,000000000100120490,000000000100006566,000000000100005256,000000000100005329,000000000100092260,000000000100000915,000000000100093091,000000000100088309,000000000100107297,000000000100088481,000000000100004237,000000000100087572,000000000100088596,000000000100092578,000000000100010672,000000000100006576,000000000100004242,000000000100011921,000000000100094848,000000000100107119,000000000100096991,000000000100088832,000000000100106334,000000000100088462,000000000100095653,000000000100096184,000000000100132181,000000000100093333,000000000100005734,000000000100108396,000000000100093903,000000000100087154,000000000100006583,000000000100107316,000000000100082466,000000000100010699,000000000100100788,000000000100092084,000000000100081782,000000000100011494,000000000100118050,000000000100089432,000000000100081194,000000000100087514,000000000100093353,000000000100094841,000000000100088788,000000000100093584,000000000100097031,000000000100079574,000000000100006545,000000000100106723,000000000100100754,000000000100100752,000000000100010655,000000000100092308)) and cpv.attribute_id = 129 and cpv.row_id not in (select row_id from catalog_product_entity where entity_id in (select product_id from catalog_product_super_link)) and cpv.store_id = 0 INTO OUTFILE '/var/lib/mysql-files/url_keys1.csv' FIELDS TERMINATED BY ' ' ENCLOSED BY '"' LINES TERMINATED BY '\n';