Liste Deutscher Schachbund e.V.

https://www.schachbund.de/

Anzeige auf der Karte

SQL query in 0.00072813034057617 - SELECT contact_id, contact, category_id, category, mother_contact_id
, 1 AS aktiv
, contacts.identifier
FROM contacts
LEFT JOIN categories
ON contacts.contact_category_id = categories.category_id
WHERE contacts.identifier = "dsb"

SQL query in 0.00080394744873047 - SELECT contact_id, contactdetail_id, identification, contact
, categories.parameters, category, label
, category_id
FROM contactdetails
LEFT JOIN contacts USING (contact_id)
LEFT JOIN categories
ON categories.category_id = contactdetails.provider_category_id
WHERE contact_id IN (26345)
ORDER BY categories.sequence, identification

SQL query in 0.0075180530548096 - SELECT contacts.contact_id, contact, category, contacts.identifier , (SELECT COUNT(*) FROM contacts_contacts WHERE contacts_contacts.main_contact_id = contacts.contact_id AND contacts_contacts.published = "yes" ) AS spielorte , members, members_female, members_u25, category_id ,mother_contact_id FROM contacts LEFT JOIN categories ON contacts.contact_category_id = categories.category_id LEFT JOIN vereinsdb_stats USING (contact_id) LEFT JOIN contacts_identifiers ON contacts_identifiers.contact_id = contacts.contact_id AND contacts_identifiers.current = "yes" WHERE mother_contact_id IN (26345) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier

SQL query in 0.010756969451904 - SELECT contacts.contact_id, contact, category, contacts.identifier , (SELECT COUNT(*) FROM contacts_contacts WHERE contacts_contacts.main_contact_id = contacts.contact_id AND contacts_contacts.published = "yes" ) AS spielorte , members, members_female, members_u25, category_id ,mother_contact_id FROM contacts LEFT JOIN categories ON contacts.contact_category_id = categories.category_id LEFT JOIN vereinsdb_stats USING (contact_id) LEFT JOIN contacts_identifiers ON contacts_identifiers.contact_id = contacts.contact_id AND contacts_identifiers.current = "yes" WHERE mother_contact_id IN (26349,26361,26392,26478,26340,26545,26393,26394,26482,26443,26405,26450,26464,26486,26519,26465,29099,26523,26471,26347,30049,26346) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier

SQL query in 0.067391872406006 - SELECT contacts.contact_id, contact, category, contacts.identifier , (SELECT COUNT(*) FROM contacts_contacts WHERE contacts_contacts.main_contact_id = contacts.contact_id AND contacts_contacts.published = "yes" ) AS spielorte , members, members_female, members_u25, category_id ,mother_contact_id FROM contacts LEFT JOIN categories ON contacts.contact_category_id = categories.category_id LEFT JOIN vereinsdb_stats USING (contact_id) LEFT JOIN contacts_identifiers ON contacts_identifiers.contact_id = contacts.contact_id AND contacts_identifiers.current = "yes" WHERE mother_contact_id IN (26350,26351,26352,26353,26354,26355,26356,26357,26358,26359,26360,29065,26362,26368,26369,26370,26374,26381,26382,26387,29058,26395,26396,26397,26398,26399,26400,26401,26402,26403,26404,29066,30101,26406,26415,26421,26427,26433,26437,29059,26444,26445,26446,26447,26448,26449,29060,26451,26456,26457,29070,26466,26467,26470,29097,29063,26472,26473,26474,26475,26476,26477,29061,26479,26480,26481,29275,29209,29204,29180,29157,29080,29223,26483,26484,26485,29067,26487,26494,26506,29072,26520,26521,26522,29062,26524,26530,26536,26542,29073,26341,29143,30048,28397,26312,26314,26316,26322,26326,26324,26310,26317,26319,26318,26320,26321,26323,29851,26331,26330,26325,26328,29722,26342,29064,27232,27233,27234,27235,27237,27238,27242,27243,27244,27245,27249,27251,27253,27256,27258,27259,27260,27261,27263,27264,27265,27266,27267,27268,27269,27270,29152,27250,27236,27241,27246,27247,27248,27252,27254,27255,27257,27262,30030,29267,27175,27177,27178,27179,27180,27181,27182,27183,27184,27185,27186,27187,27189,27192,27193,27198,27199,27201,27204,27205,27210,27211,27212,27213,27214,27216,27219,27220,27223,27224,27226,27228,27230,29932,29933,27176,27190,27209,27197,29276,27202,27215,27217,27218,29110,29746,27203,27206,29637,29090,29244,29232,29696,29217,29693,29200,29713,29068,28277,28278,28279,28283,28284,28285,28286,28287,28288,28290,28291,28292,28293,28294,28295,28296,28297,28298,28299,28300,28301,28302,28303,28304,28305,28306,28307,28308,28309,28311,28312,28313,28315,28316,28317,28318,28310,28280) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier

SQL query in 0.05850887298584 - SELECT contacts.contact_id, contact, category, contacts.identifier , (SELECT COUNT(*) FROM contacts_contacts WHERE contacts_contacts.main_contact_id = contacts.contact_id AND contacts_contacts.published = "yes" ) AS spielorte , members, members_female, members_u25, category_id ,mother_contact_id FROM contacts LEFT JOIN categories ON contacts.contact_category_id = categories.category_id LEFT JOIN vereinsdb_stats USING (contact_id) LEFT JOIN contacts_identifiers ON contacts_identifiers.contact_id = contacts.contact_id AND contacts_identifiers.current = "yes" WHERE mother_contact_id IN (26363,26364,26365,26366,26367,26371,26372,26373,26375,26376,26377,26378,26379,26380,26383,26384,26385,26386,26388,26389,26390,26391,26407,26408,26409,26410,26411,26412,26413,26416,26417,26418,26419,26420,26422,26423,26424,26425,26426,26428,26429,26430,26431,26432,26434,26435,26436,30037,26438,26439,26440,26441,26442,26452,26453,26454,26455,26458,26459,26460,26461,26462,26463,26488,26489,26490,26491,26492,26493,26495,26496,26497,26498,26499,26500,26501,26502,26503,26504,26505,26507,26508,26509,26510,26511,26512,26513,26514,26515,26516,26517,26518,26525,26526,26527,26528,26529,26531,26532,26533,26534,26535,26537,26538,26539,26540,26541,26543,29098,26544,29100,26547,26548,26550,26552,26553,26554,29101,26555,26556,26557,26558,26559,26560,26561,26562,26563,26564,26565,26566,26567,26568,26569,26570,26572,26573,26574,26575,26576,26578,26579,26580,26581,26583,26584,26585,26586,26587,26589,26590,26591,26592,29522,29729,26577,26593,26594,26595,26596,26597,26599,26600,26601,26603,26604,26605,26606,26607,26608,26609,26610,26611,26612,26613,26614,26615,26616,26617,26618,26619,26620,26621,26622,26623,26624,26625,26626,26627,26628,26602,26629,26630,26631,26632,26633,26634,26635,26637,26638,26639,26640,26641,26642,26643,26644,26645,26646,26636,26647,26648,26649,26650,26651,26652,26654,26656,26657,26658,26659,26662,26664,29528,26660,26661,26665,26666,26667,26668,26669,26670,26671,26672,26673,26674,26675,26676,26677,26678,26679,26681,26682,26684,26685,26686,26687,26688,26689,26690,26691,26693,26694,26698,26699,26700,26701,26702,26704,29529,29929,29968,26696,26683,26695,26705,26706,26707,26708,26709,26710,26711,26713,26714,26715,26716,26717,26718,26721,26722,29530,26724,26725,26726,26727,26728,26729,26730,26731,26732,26733,26808,26810,26811,26813,26814,26816,26817,26819,26820,26822,26823,26825,26826,26828,26829,26834,26835,26836,26838,26839,26840,26841,26843,30028,26812,26830,26807,26815,26827,26833,26842,26845,26846,26847,26848,26849,26850,26852,26853,26854,26855,26857,26858,26859,26860,26862,26864,26865,26866,26867,26868,26869,26871,26872,26856,26861,27016,27017,27018,27021,27022,27023,27025,27026,27027,27029,27030,27031,27032,27035,27036,27037,27038,27039,27040,27041,27042,27043,27044,27046,27047,27053,29536,27034,27020,27033,27045,27048,27049,27052,29535,27271,27273,27275,27276,27277,27278,27280,27281,27282,27283,27284,27285,27287,27288,27290,27291,27293,27294,27296,27297,27298,27299,27302,27300,29856,29948,27303,27304,27305,27306,27307,27308,27309,27310,27311,27312,27313,27314,27315,27316,27317,27318,27319,27320,27321,27322,27324,27325,27326,27327,27328,27330,27331,27332,27333,27334,29848,27335,27340,27341,27342,27343,27344,27345,27346,27347,27349,27350,27351,27352,27353,27354,27355,27357,27359,27361,27362,27365,27366,27367,27368,29264,27338,27348,27369,27370,27371,27372,27373,27374,29539,27375,27377,27378,27380,27381,27383,27384,27387,27388,27389,27390,27391,27382,27385,27386,27394,27395,27396,27397,27398,27399,27400,27401,27402,27403,27404,27405,27406,27407,27408,27409,27410,27411,27413,27414,27415,27393,27412,29119,27416,27417,27418,27419,27420,27421,27422,27423,27424,27425,27426,27427,27428,27429,27430,27431,27432,27433,27435,27436,27437,27438,27439,27434,27440,27441,27443,27445,27446,27447,27448,27449,27453,27442,27444,29849,27450,27451,27452,27454,27455,27456,27458,27459,27460,27461,29540,29153,27462,27463,27464,27465,27466,27467,27468,27470,27471,27474,27475,27949,27950,27952,27953,27954,27955,27956,27957,27958,27959,29104,27961,27962,27963,27964,27965,27966,27967,27968,27969,27970,27971,27972,27973,27974,27975,27976,27977,27979,27981,27982,27983,29105,27978,27960,27980,27984,27986,27987,30045,27989,27990,27991,27992,27993,27995,27996,27997,27998,28000,28001,28003,28004,28005,28006,28007,28063,28032,28009,28010,28011,28012,28013,28014,28015,28016,28017,28018,28019,28020,28022,28024,28025,28027,28028,28029,28030,28023,28026,28031,28034,28035,28036,28038,28039,28040,28041,28044,28045,28047,28048,28050,28051,28052,28054,28056,28057,28058,28059,28061,28064,28065,28067,28069,28070,28033,28042,28043,28046,28049,28068,28071,28074,28075,28076,28078,28079,28080,28082,28083,28084,28087,28088,28089,28090,28091,28093,28094,28095,28098,28099,28101,28073,30196,28102,28103,28104,28105,28106,28107,28108,28109,28110,28111,28112,28114,28116,28117,28118,28119,28120,28121,28122,28124,28125,28126,28128,28115,30031,28127,28195,28196,28197,29857,28199,28200,28202,28203,28204,28205,28207,28208,28209,28206,28210,28319,28320,28321,28323,28324,28326,28327,28329,28331,28322,29542,29949,28332,28333,28334,28335,28336,28338,29543,28341,28342,28343,28344,28347,28348,28349,28350,28377,28379,28380,28381,28382,28385,28386,28388,28389,28390,28392,28394,28395,28396,28383,28387,28352,28353,28354,28355,28356,28357,28358,28359,28360,28361,28364,28366,28368,28369,28370,28372,28374,28376,29969,30044,28362,28351,28371,28373,28367,28399,28400,28402,28403,28405,28407,28408,28409,28410,28411,28412,28413,28414,28415,28416,28417,28418,28419,28420,28421,28423,28424,28425,28430,28398,28401,28406,29724,28426,28427,28428,28429,28431,28432,28433,28434,28436,28437,28438,28439,28440,28441,28442,28443,28444,28445,28446,28447,28448,28449,28450,28451,28453,28454,28455,28456,28457,28458,28459,28460,28462,29725,28466,28467,28468,28469,28470,28471,28472,28474,28475,28476,28477,28478,28482,28483,28484,28485,28486,28487,28488,28489,28490,28491,28493,28494,28495,28496,28498,28499,28461,28463,28464,28465,28479,28492,28500,28501,28502,28503,28504,28505,28506,28507,28508,28509,28511,28512,28514,28515,28516,28517,28518,28519,28521,28523,28524,28525,28527,28510,28522,28528,28529,28530,28532,28534,28535,29145,29937,28536,28537,28538,28539,28540,28541,28542,28544,28545,28549,28550,28551,28552,28553,28554,28555,28556,28557,28558,28559,28560,28561,28562,28564,28565,28570,28572,28574,28531,28533,28543,28546,28547,28563,28567,28569,28571,28573,28576,28577,28578,28579,28580,28582,28583,30041,28585,28589,28590,28592,28593,28595,28596,28597,28599,28601,28602,28604,28605,28606,28607,28608,28609,28611,28612,28614,28615,28616,28617,28618,28620,28623,28624,28581,29928,28584,28586,28591,28594,28598,28600,28603,28613,28619,28626,29146,29726,28631,28633,28636,28642,28643,28629,28630,28632,28637,28644,28645,28646,29745,28651,28655,28656,28657,28659,28665,28647,28648,28649,28650,29938,28658,28661,28662,28663,28666,28668,28669,29727,29951,28673,28674,28675,28677,28678,28679,28681,28682,28683,28685,28686,28688,28690,28691,28692,28695,28670,30034,28672,28680,28689,28696,28667,28697,28698,28699,28702,28704,28707,28708,28709,28711,28700,28703,28705,28710,28714,28715,28716,28718,28720,28722,28725,28727,28713,28721,28724,28726,28728,28730,28731,28736,28737,28738,28734,28743,28739,28740,28742,28885,28886,28888,29149,28891,28892,28893,28894,28895,28896,28899,28900,28901,28902,28887,28889,28897,28898,28904,28907,28908,28909,28911,28912,29150,29154,29271,28913,28915,28917,28918,28920,28921,28923,28924,28925,28926,28916,28903,28906,28910,30047,28914,28919,28922,28928,28929,28930,28931,28932,28933,28934,28935,28883,29546,28936,28937,28938,28939,28942,28943,28944,28945,28947,28948,28951,28953,28954,28955,28956,28957,28958,29526,28960,28961,28962,28963,28964,28965,28968,28969,28941,28949,28950,28959,29667,29245,29569,29173,29616,29233,29718,29560,29168,29585,29214,29708,29559,29155,29189,29686,29552,29579,29184,29682,29551,29071,29574,29176,29675,29519,29571,29175,29580,29093,29608,29711,29195,29601,29699,29092,29598,29671,29694,29081,29246,29652,29243,29639,29227,29615,29719,29202,29554,29689,29567,29231,29622,29553,29670,29566,29203,29600,29550,29662,29564,29199,29583,29549,29647,29561,29179,29721,29578,29521,29644,29558,29704,29082,29573,29255,29634,29556,29690,29568,29237,29628,29575,29626,29163,29664,29572,29620,29085,29651,29249,29618,29648,29228,29607,29643,29208,29604,29638,29201,29581,29633,29187,29677,29235,29205,29158,29709,29076,29672,29563,29365,29229,29703,29198,29674,29183,29659,29075,29650,26337,29606,29238,26335,26336,29215,29258,29705,29210,29250,29691,29190,29236,29654,29162,29225,29649,29159,29222,29635,29084,29717,29220,29261,29712,29083,29655,29185,29697,29577,29632,29182,29692,29262,29630,29181,29688,29254,29621,29172,29680,29253,29599,29167,29679,29252,29589,29160,29660,29234,29714,29586,29609,29086,29590,29562,29710,29548,29700,29196,29685,29191,29612,29165,29623,29094,29241,29617,29087,29226,29611,29684,29219,29582,29676,29212,29570,29658,29169,29557,29627,29161,29251,29218,29625,29213,29610,29207,29602,29166,29591,29702,29077,29584,29695,29240,29576,29642,29706,29078,29242,29663,29074,29230,29653,29216,29645,29197,29619,29174,29605,29164,29565,29259,29657,29079,29239,29614,29698,29224,29587,29687,29211,29263,29683,29193,29260,29669,29171,29257,29665,29156,29256,29247,29641,29206,29629,29194,29613,29715,29192,29588,29673,29681,29186,29364,29668,29089,29330,29656,29520,29720,29248,29716,29221,29678,29188,29640,29178,29603,29088,29555,29636,29631,29707,29624,29701,29666,29661,29646) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier

SQL query in 0.010922908782959 - SELECT contacts.contact_id, contact, category, contacts.identifier , (SELECT COUNT(*) FROM contacts_contacts WHERE contacts_contacts.main_contact_id = contacts.contact_id AND contacts_contacts.published = "yes" ) AS spielorte , members, members_female, members_u25, category_id ,mother_contact_id FROM contacts LEFT JOIN categories ON contacts.contact_category_id = categories.category_id LEFT JOIN vereinsdb_stats USING (contact_id) LEFT JOIN contacts_identifiers ON contacts_identifiers.contact_id = contacts.contact_id AND contacts_identifiers.current = "yes" WHERE mother_contact_id IN (26737,26739,26740,26741,26742,26743,26744,26745,26746,26748,26749,29531,29946,26735,26750,29930,26752,26753,26754,26755,26756,26757,26759,26762,26763,26766,26767,26768,26772,26773,26774,29532,26751,26760,26761,26765,26769,30027,26775,26776,26777,26778,26779,26781,29846,26783,26786,26787,26790,26793,26794,26795,26784,26785,26791,26792,26796,26797,26798,26799,26800,26802,26803,26804,26805,26806,26875,26876,26877,26879,26880,26881,26882,26883,26890,26891,26893,26894,26895,26878,26885,26887,26889,26897,26899,26901,26902,26903,26905,26906,26907,26908,26909,26910,26911,26912,26913,26914,26917,26918,26919,26920,26921,26923,29730,30029,26900,26904,26915,26916,26922,26924,26926,26927,26929,26930,26933,26934,26937,26938,26939,26941,26942,26943,26945,26946,26947,26948,26950,26951,26952,29847,26925,26928,26931,26940,26949,26954,26955,26958,26960,26961,26962,26963,26964,26956,26957,26965,26966,26967,26968,26969,26972,26973,26974,26975,26976,26977,26979,26981,26982,26985,26986,29947,26970,26978,26980,26984,26987,26988,26990,26991,26993,26994,26989,26992,26996,26997,26998,26999,27000,27001,27003,27004,27005,29534,27002,27006,27007,27008,27009,27010,27011,27012,27014,27015,27013,27056,27057,27058,27061,27062,27063,27064,27065,27067,27068,27069,27070,27071,29744,29091,27054,27055,27059,27060,27066,27073,27074,27075,27076,27078,27079,27080,27081,29537,27072,27077,27082,27083,27085,27086,27089,27091,27092,27093,27088,27090,27094,27095,27096,27097,27098,27100,27101,27102,27103,27104,27105,27106,27107,29855,27108,27110,27115,27112,27114,27116,27118,27120,27121,27122,27123,27124,27125,27126,27129,27130,27128,27111,27119,27127,27133,27134,27135,27136,27138,27139,27141,27142,27144,27137,27131,27146,27148,27152,27153,27154,27158,27160,27161,27163,29538,29939,27147,27149,27150,27156,27157,27162,27164,27165,27166,27167,27168,27169,27172,27174,27109,27171,27173,27476,27477,27479,27481,27482,27483,27484,27485,27486,27487,27488,27489,27492,27480,27478,27495,27497,27498,27499,27502,27503,27504,27505,27507,27508,27509,27510,27511,27512,29273,27500,27501,27513,27514,27516,27517,27518,27519,27520,27522,27523,27524,27515,27521,27526,27527,27528,27529,27530,27531,27532,27533,27534,27535,27536,27538,27537,27540,27541,27542,27543,27544,27545,27546,27547,27548,27549,27550,30039,27551,27552,27553,27554,27555,27556,27557,27558,27559,27560,27561,27562,27563,27564,27566,27567,27569,27570,27573,27574,27575,27576,27577,27578,27579,27580,27581,27582,27583,27584,27585,27586,27587,27589,27590,27591,27571,27588,27594,27596,27597,27599,27600,27601,27603,27604,27605,27606,27607,27592,27595,27598,27602,27610,27611,27612,27613,27617,27618,27619,27615,27620,27621,30040,27623,27624,27625,27626,27627,27628,27629,27630,27631,27632,27633,27634,27635,27636,27637,27638,27639,27640,27641,27642,27643,27644,27646,27647,27649,27650,27651,27652,27654,27655,27656,27657,27658,27659,27661,27662,27663,29934,27665,27668,27669,27670,27671,27672,27674,27675,27676,27677,27678,27680,27666,27684,27685,27686,27687,27688,27690,27693,27694,27697,27698,27689,27699,27700,27701,27702,27703,27705,27706,27707,27708,27710,27336,29121,27714,27715,27716,27720,27719,27713,27682,27723,27724,27725,27726,27727,27728,27729,27730,27732,27733,27735,27736,27737,27738,27739,27740,27741,27742,27744,27745,27746,27747,27748,27749,27750,27752,27753,27754,27755,27751,29272,27756,27759,27760,27761,27762,27763,27766,27767,27768,29518,27764,27765,27770,27771,27772,27773,27774,27775,27776,27777,27781,27778,27780,27782,27783,27784,27785,29102,27786,27787,27788,27789,27790,27792,27793,27794,27795,27796,27797,27798,27799,27800,27801,27802,27803,27805,27806,27808,27809,27810,27812,27813,27814,27815,27816,27817,27818,27819,27821,27822,27823,27824,27825,27826,27827,27830,27831,27832,27829,27820,27834,27835,27836,27837,27839,27840,27842,27845,27846,27847,27850,27851,27852,27853,27833,27838,27843,27855,27856,27857,29103,27858,27859,27860,27861,27862,27864,27866,27867,27868,27928,27869,27870,27871,27872,27873,27875,27863,27874,27876,27877,27878,27879,27880,27881,27882,27883,27884,27885,27886,27888,27889,27890,27887,27892,27893,27895,29524,27896,27897,27898,27899,27900,27901,27902,27903,27904,27905,27907,27911,27912,27914,27915,27916,27917,27918,27919,27920,27921,27922,27913,27910,27908,27924,27925,29122,27926,27929,27930,27932,27933,27936,27931,27934,27935,27939,27940,27941,27942,27943,27944,27945,27946,27947,27948,28129,28130,29106,28131,28132,28133,28134,28135,28136,28137,28138,28140,28143,29732,28139,28142,28144,28145,28146,28147,28148,28149,28151,29733,28153,28154,28155,28157,28158,28160,28161,28152,28156,28159,28163,28164,28165,28166,28167,28169,28170,28171,28172,28173,28168,28176,28177,28178,28179,28181,28182,30032,28184,28185,28186,28193,28194,29541,28192,28180,28189,28211,28212,28214,28215,28216,28217,28218,28219,28221,28222,28213,28220,28223,28224,28226,28228,28229,28230,28231,28232,28233,28225,30033,28234,28236,28237,28239,28240,28238,28241,28242,28243,28244,28245,28246,28247,28248,28249,28250,28251,28252,28253,28254,28255,28256,28257,28258,28259,28262,28263,28264,28265,28266,28267,28150,28269,28270,28271,28272,28273,28274,28275,28276,28749,28750,28754,28755,28756,28757,28758,28759,28760,29056,28752,28751,28761,28763,28766,28770,28772,28773,28767,28768,28769,28771,28775,28777,28774,28776,29734,28778,28779,28780,28782,29852,28781,29109,28784,28785,28788,28786,28787,28789,28790,28791,28792,28793,28794,28795,28799,28800,28801,30102,28803,28806,28802,28804,28805,28807,28809,28810,28811,28808,28812,28813,28814,28815,28816,28817,28818,28820,28821,28822,28823,28824,28828,29147,28825,28829,28830,28831,28833,28834,28832,28836,28837,28835,28838,28839,28840,28841,28842,28843,28844,28845,28847,28848,28846,28850,28851,29545,28849,28852,28853,28855,28856,28857,28859,28860,28861,29525,28863,28864,28866,28868,28869,28870,28871,28872,28865,28867,28873,29148,28874,29853,28876,28877,28879,28878,28880,28881,28882,28971,28972,28973,28974,28976,28977,28978,28979,28980,28981,28983,28984,29952,28985,28986,28988,28991,28992,28989,28990,28993,28995,28994,30038,30198,28996,28997,29000,29001,28998,28999,29002,29003,29005,29006,29007,29008,29009,29010,29011,29012,29013,29014,29954,29016,29017,29018,29019,29270,29020,29021,29022,29023,29024,29025,29527,29026,29027,29028,29029,29030,29031,29033,29034,29035,29036,29269,29032,29037,29040,29041,29043,29045,29038,29039,29044,29046,29049,29050,29047,29051,28745,28746,28747,28748,28796,28797,29015) AND ISNULL(aufloesung) ORDER BY categories.sequence, contact_short, contacts_identifiers.identifier

SQL query in 0.0011389255523682 - SELECT mother_contact_id FROM contacts WHERE contact_id IN (26345)

SQL query in 0.00086617469787598 - SELECT setting_key, setting_value
FROM _settings
WHERE setting_key = "query_strings"

SQL query in 0.0010311603546143 - SHOW FIELDS FROM media

SQL query in 0.00053811073303223 - SHOW WARNINGS

SQL query in 0.00091385841369629 - SELECT page_id, medium_id, webpages_media.sequence
, IF(ISNULL(description), media.title, description) AS title
, description, alternative_text
, source, filename, version
, thumb_filetypes.extension AS thumb_extension
, media.date
, filetypes.extension AS extension
, filetypes.mime_content_type
, filetypes.mime_subtype
, filetypes.filetype
, filesize
, filetypes.filetype_description
, width_px, height_px
, IF(height_px > width_px, "portrait", "panorama") AS orientation
, CASE filetypes.mime_content_type
WHEN "image" THEN "images"
WHEN "video" THEN "videos"
ELSE "links" END
AS filecategory
FROM webpages_media
LEFT JOIN media USING (medium_id)
LEFT JOIN filetypes thumb_filetypes
ON media.thumb_filetype_id = thumb_filetypes.filetype_id
LEFT JOIN filetypes
ON media.filetype_id = filetypes.filetype_id
WHERE page_id IN (140)
AND published = "yes"
ORDER BY webpages_media.sequence, title, filename

SQL query in 0.0020430088043213 - SELECT page_id, title , CONCAT(identifier, IF(STRCMP(ending, 'none'), ending, '')) AS identifier , mother_page_id FROM webpages WHERE (website_id = 3) AND (live = "yes")

SQL query in 0.00069308280944824 - SELECT mother_page_id FROM webpages WHERE page_id = 140

SQL query in 0.00054001808166504 - SELECT mother_page_id FROM webpages WHERE page_id = 136

SQL query in 0.00087285041809082 - SELECT page_id, IF(LENGTH(title) > 24, SUBSTRING_INDEX(title, " ", 1), title) AS title , CONCAT(identifier, IF(ending != "none", ending, "")) AS url , mother_page_id, menu, description FROM webpages WHERE (NOT ISNULL(menu) AND live = 'yes' ) AND (website_id = 3) ORDER BY sequence