266.96 ms (58.70%)
|
1 |
SELECT pt.acco_id, pt.product_id, bp.price as minPrice, pt.rule type, pt.nights nights
FROM `steiermark_vacancies`.price_template pt
INNER JOIN
`steiermark_vacancies`.price_template_base_prices bp
ON bp.price_template_id = pt.id
WHERE pt.acco_id IN (191516,261287,180106,267915,103365,229144,86586,201425,256266,177439,191937,173849,188200,148211,162295,181966,228288,90325,154821,227190,97625,101229,76033,253939,164670,98143,163153,171766,150268,1173353,158731,255823,130455,1173742,260387,383021,104781,209213,121638,132704,162100,160120,138703,249413,14557855,81753,262837,106040,156918,113751,157149,161033,220403,34219679,203617,173602,114734,21161019,175319,90285,97332,120314,246836,128649,106445,228081,142725,208002,250696,265826,242815,268424,213326,136200,247967,257803,177240,131790,99678,147332,197648,260291,178599,206964,22892603,202479,257010,124000,78857,4061616,229314,241670,157521,176727,73645,256553,192306,383292,18355899,138331,256818,235840,144028,131018,259830,208109,157109,39225141,90162,241752,207763,221382,113085,125739,75414,180136,214015,41680612,51216654,156680,168086,241513,151492,171549,154608,268018,49169351,192842,191155,238918,151257,234239,141729,164627,262206,259974,27128134,229040,194565,9290160,94222,26648317,220348,171978,91679,81984,174338,197250,124606,78602,213843,244042,265255,154873,4791485,108105,199975,113626,243209,252258,33267404,3118747,5160340,192033,124694,203308,136181,383360,194797,209054,7715980,27808188,20059276,102266,113408,209292,255957,148562,233730,260733,26898515,172618,83792,140245,157466,384186,219765,117877,222898,176457,23455826,145409,31514436,211808,168744,128321,199742,3379819,148779,207109,141272,33072197,143736,109291,245784,160801,261487,47294199,259576,27224568,3411816,76427,38050667,201802,7599929,87467,221211,217376,44404593,209445,115416,121323,256865,193068,93789,74347,117916,9700325,155681,261884,267501,263716,265468,178433,262579,224332,213925,83429,134439,108664,44224029,10261747,89073,8722782,162146,203577,109501,175147,174583,41796413,47202201,254301,31719532,402843,141656,90791,80345,136555,86746,217510,36278962,108881,105748,226049,185795,111370,241827,266661,89261,172217,174737,106287,206854,135205,265066,23945599,222491,173273,98639,88121,225305,48897409,189123,267700,1173892,95043,218149,207780,242786,111091,171085,112984,209483,135519,224773,186795,77403,4791491,383578,110677,126702,208283,148079,161664,20708505,146129,4061812,170518,202690,30148041,75680,143950,23106697,13818591,104583,111341,87518,84605,34719290,193693,265878,119054,84693,218235,239049,212689,9887645,170725,139824,211891,185961,156556,115223,164309,171662,17594470,162820,100623,80509,186088,227892,261943,192003,242964,251865,21211748,189226,260943,129897,91149,111521,79610,77676,187810,168470,20627345,44869050,220655,95652,240404,382826,87340,255905,191047,154226,261090,101549,204528,194917,227481,245659,117486,79926,12253627,91383,87314,219299,102508,121533,223613,124718,145614,255407,176678,209921,75853,192523,139196,147221,212715,128992,223355,134831,170790,154459,97982,191407,200906,178544,169612,138939,96924,108989,15050850,97682,156120,2853495,190210,75643,76900,87071,201863,8591193,245886,3224898,228314,222990,209807,89549,3029831,168606,143351,222689,229470,204161,111003,106770,185439,205629,118332,225374,125266,107859,240971,159735,9700358,191266,187180,74473,27808178,118621,22568743,199850,115902,193028,79494,140059,143038,7599993,27199439,100682,84439,31789631,254574,75009,228572,3224895,8388337,89886,212164,41024653,79030,77798,86434,255713,5315068,229397,99548,212929,85349,168114,4061468,190504,21273299,263121,213063,242085,259743,262617,148602,114251,114017,139671,228856,114786,33072200,4791488,122718,27808362,111742,37667633,268989,106889,242703,92184,91180,72773,79701,205836,183075,114609,268647,173082,165937,109374,183391,210522,267851,20512295,200772,268384,23185284,28138429,179735,1173491,226977,150349,269658,170874,85437,210612,143785,18810400,202554,245060,88772,125397,190383,210702,195537,187883,161875,103051,174680,199831,42358761,20972969,165805,7186183,183290,118392,204827,5957905,210751,179767,160168,195225,116132,172344,122307,218829,200126,118221,383375,74427,182129,1173124,83176,9129444,125055,265768,132281,250245,242072,199572,182335,9517217,79212,246469,149700,74534,201319,82308,178072,260687,223960,114925,155523,245591,269445,182728,10039806,260577,263186,224600,42105593,75600,197379,220170,264308,180306,91582,170704,198994,91777,128052,142776,9282725,148975,120959,177255,120483,75959,383494,115150,81346,74121,268711,199275,85117,36566491,155984,130799,147033,199934,135829,27076239,2367452,145352,79424,226395,151031,101813,103499,265378,207573,162948,206641,154301,220948,197713,144112,141037,168884,147191,200283,110374,122101,39558144,268162,100061,174091,383672,82521,383826,4061779,213358,173543,89349,221136,89709,383286,208516,2977929,210887,266691,227732,162891,37038521,168676,108551,210439,267314,218032,98352,223447,193721,96112,199295,129814,105369,18810410,256504,135125,175690,82805,190874,246756,39599857,172317,181569,178916,96619,18323640,4061656,181441,139974,110254,17275737,164436,172512,177391,179201,148376,141995,171964,199538,96059,266341,199700,111651,219501,202588,261158,80881,84734,157061,169799,204342,163032,242260,219645,266888,87380,73318,244552,167765,126983,98382,143682,193837,155598,117646,241333,240120,135403,418173,191428,140362,155492,29649833,165025,145685,156310,155228,183196,220877,226215,141880,136036,35241603,74297,223652,188963,106094,3379718,266243,84203,189271,141472,259918,259359,4061962,229645,153833,145447,261224,166076,80793,93903,214424,190819,151300,126485,15668814,99420,191455,181278,207430,73135,102558,186109,227572,163958,164573,1173161,16306657,198534,242014,186921,186236,41752708,262446,94738,74091,8388408,263799,23106643,156053,147531,171116,157401,6797421,267530,179118,103592,21308116,185065,73764,133247,146150,174544,187735,113462,227046,142948,117802,87409,98021,192660,136066,82419,240534,189988,77069,89456,256958,227134,131774,199099,182482,180717,205724,261823,209351,160345,105154,173923,231694,1173158,89745,13723644,3379737,208831,88849,218293,267623,175232,96781,194023,220531,214433,268304,31665450,240386,119873,132556,383139,383006,134210,212320,185598,77540,145830,132606,196032,245926,156762,194884,157428,2566227,4442214,260788,106347,75482,101590,101260,178677,244711,211866,83126,149216,166529,126658,102868,1173542,129031,39355239,150639,251478,159064,108780,212020,82604,263334,26244429,48897791,147399,87899,92309,13979961,88890,266814,98451,87012,2470567,150070,161142,84906,267678,8566620,90455,43751656,134714,7941416,158481,51503593,187408,128777,101873,269773,103348,223733,145003,193518,22452518,222458,97550,107057,119718,101969,156724,175902,178962,165965,240646,183531,225267,91812,5315087,221512,47158244,192391,139070,252035,94404,164234,7016779,265584,189166,228125,101403,75106,136496,218042,128612,161406,227270,195022,181329,223466,146486,213132,188297,249659,43349109,218521,171431,176897,164128,195558,9872791,209589,7780777,218076,243999,128888,107555,196249,102976,203485,203394,76116,195136,14623690,198380,192497,261005,383027,108195,105395,160203,23184951,85808,250318,128526,172278,223510,176992,267023,194471,181045,138437,203729,228246,219157,180387,228944,154180,189670,264897,169035,166413,46461361,191815,132768,247180,134133,145258,212576,127120,72285,209859,212729,38723937,84542,81094,178215,124237,189598,149007,4442187,139875,102697,33664677,208674,74880,266112,185888,198187,142573,15659243,194307,38008495,195918,111604,75898,185864,73900,80548,261338,197565,180504,228789,87856,147869,179886,73395,108520,108052,116102,135012,213047,103833,41634802,266442,190634,35522295,260555,267186,119097,1173693,241860,240436,200867,115545,105712,168651,135252,8695139,149155,38621717,200595,151676,204204,99114,203147,151225,384102,154758,146259,135685,121033,228197,229095,210638,194960,1173603,146703,202441,174181,169959,88291,91914,154051,176975,142318,87219,224446,144833,210718,91843,96354,139042,150701,18332685,147969,135730,149400,209194,205753,104513,146983,74030,107333,182314,176068,135345,102814,242919,194713,30765443,143537,241967,269473,29311567,186138,171224,128254,105477,188477,72611,106657,99228,210768,142528,5315084,202202,8618578,243839,251539,244956,189617,195386,198307,87124,130741,10655859,107023,108003,227765,171586,113392,77134,78974,212394,196083,261973,143596,81720,162257,127993,226499,98121,41214843,167986,190920,188894,81316,12371222,72528,247088,211759,120394,127946,195347,269401,191210,241089,31419712,144860,182441,88688,81217,85536,110467,129206,46237639,204745,177333,175610,5957896,250174,192804,95872,241209,139584,83605,147915,156464,203131,104153,221094,202800,188242,80083,206894,3176489,144062,107364,177852,269023,142897,1173653,162969,207942,122838,176637,107594,94870,27808352,158648,186259,179813,4580718,197310,91479,130049,205199,22892606,121463,45539296,1173121,110338,203882,134322,22840856,88601,132156,250060,100829,178500,253709,249733,120883,170382,185698,268279,202332,206198,203636,244217,78111,92398,179680,262376,177510,226339,220914,263626,220546,148899,250658,162361,27807955,87970,151587,211256,128141,6771981,124113,98483,95383,247897,174987,140325,138609,150724,97116,248735,13400949,150874,31077769,94373,115604,240156,90081,188163,13377190,176111,382743,120627,163235,268917,159639,179171,72244,198814,246306,8870626,37868209,34037741,174035,261585,129501,109234,110842,131839,110435,157283,32979456,96266,113160,139146,151636,80940,222748,38622028,227403,227647,124337,266360,116231,251064,146288,163837,142256,81527,73343,149455,73556,211686,262061,225967,197746,109827,7599407,14669428,166611,101798,31215812,1904411,197835,164711,208378,130324,384041,167903,255495,86879,179242,201789,220238,223333,119029,254825,131179,144248,86366,125661,38300874,150752,257470,131085,115484,169525,143260,9700322,384050,81639,23220930,35700277,4061851,384128,124869,186869,147609,266549,17877742,239438,139730,146183,166027,163692,171164,166311,49539249,243243,100207,205363,185045,170902,114505,77357,91299,79763,119809,27486615,187530,181736,220755,223395,243765,218423,134094,11367104,114041,252403,227558,254246,227604,193372,89565,169666,198592,382988,9290146,166123,130955,122580,176200,198498,101167,156225,123820,192120,131135,245508,8722785,43581664,222266,4149175,4442184,383118,164198,160274,109732,22882595,190401,129096,118447,195113,251659,189874,133017,225195,133887,193149,213537,205800,80315,144374,176007,249148,263475,78233,195752,383497,34636746,96544,144556,218375,78778,1173251,224525,138736,159538,221173,158547,256037,208746,101745,46904829,146572,1845849,98309,257550,110779,244970,266061,15243082,9700388,26684056,152590,174941,174798,95803,113819,130026,4442181,180460,193204,252832,170491,49539259,204651,213869,186209,139639,260613,79343,219686,160845,107672,115132,139252,144517,208902,187460,204776,5957902,202099,253165,190061,203901,262167,143448,162656,94129,149098,176244,225007,181884,221593,250387,190546,173880,220693,103317,122139,37366700,105761,141562,39995931,252859,124829,91521,219012,147152,138273,265930,225114,95945,90363,247473,154116,156882,115753,158905,102372,150008,117438,5160343,192284,171353,135953,263240,160247,265965,76091,122810,9395965,206591,160614,89972,268951,145494,150197,32742951,220483,1173254,243956,223285,143202,103526,189797,245836,84306,254732,97583,205897,196171,76562,142376,132963,265305,257732,4061766,74757,73689,199364,97423,212470,125952,170268,264448,187757,214160,204973,9700382,100524,260508,187073,141808,90830,195314,223044,136417,149642,157541,6771978,185208,219804,114455,156617,140833,50388225,26970115,149059,213283,205493,129533,75190,6775934,187911,77600,7541413,221442,162327,111233,90672,208932,115353,155356,207463,2655510,263995,175792,245352,122780,177157,176296,157359,201732,193952,114320,200435,246876,244648,136526,17058949,165005,122527,212066,9517247,96500,98441,202896,251348,157224,220200,170765,11213840,180007,7967625,129250,77223,170037,46236871,268827,98180,248414,186176,218867,146397,383256,245240,250829,204855,190150,7678621,6614248,7217358,173474,249871,37868894,267580,38670305,21237158,178337,211155,164042,130267,111071,151568)
AND pt.stdOccupancy BETWEEN bp.occupancyFrom AND bp.occupancyTo
AND price > 0 and (select active from `steiermark`.object_6 product where product.o_id = pt.product_id)
order by minPrice
SELECT
pt.acco_id,
pt.product_id,
bp.price as minPrice,
pt.rule type,
pt.nights nights
FROM
`steiermark_vacancies`.price_template pt
INNER JOIN `steiermark_vacancies`.price_template_base_prices bp ON bp.price_template_id = pt.id
WHERE
pt.acco_id IN (
191516,
261287,
180106,
267915,
103365,
229144,
86586,
201425,
256266,
177439,
191937,
173849,
188200,
148211,
162295,
181966,
228288,
90325,
154821,
227190,
97625,
101229,
76033,
253939,
164670,
98143,
163153,
171766,
150268,
1173353,
158731,
255823,
130455,
1173742,
260387,
383021,
104781,
209213,
121638,
132704,
162100,
160120,
138703,
249413,
14557855,
81753,
262837,
106040,
156918,
113751,
157149,
161033,
220403,
34219679,
203617,
173602,
114734,
21161019,
175319,
90285,
97332,
120314,
246836,
128649,
106445,
228081,
142725,
208002,
250696,
265826,
242815,
268424,
213326,
136200,
247967,
257803,
177240,
131790,
99678,
147332,
197648,
260291,
178599,
206964,
22892603,
202479,
257010,
124000,
78857,
4061616,
229314,
241670,
157521,
176727,
73645,
256553,
192306,
383292,
18355899,
138331,
256818,
235840,
144028,
131018,
259830,
208109,
157109,
39225141,
90162,
241752,
207763,
221382,
113085,
125739,
75414,
180136,
214015,
41680612,
51216654,
156680,
168086,
241513,
151492,
171549,
154608,
268018,
49169351,
192842,
191155,
238918,
151257,
234239,
141729,
164627,
262206,
259974,
27128134,
229040,
194565,
9290160,
94222,
26648317,
220348,
171978,
91679,
81984,
174338,
197250,
124606,
78602,
213843,
244042,
265255,
154873,
4791485,
108105,
199975,
113626,
243209,
252258,
33267404,
3118747,
5160340,
192033,
124694,
203308,
136181,
383360,
194797,
209054,
7715980,
27808188,
20059276,
102266,
113408,
209292,
255957,
148562,
233730,
260733,
26898515,
172618,
83792,
140245,
157466,
384186,
219765,
117877,
222898,
176457,
23455826,
145409,
31514436,
211808,
168744,
128321,
199742,
3379819,
148779,
207109,
141272,
33072197,
143736,
109291,
245784,
160801,
261487,
47294199,
259576,
27224568,
3411816,
76427,
38050667,
201802,
7599929,
87467,
221211,
217376,
44404593,
209445,
115416,
121323,
256865,
193068,
93789,
74347,
117916,
9700325,
155681,
261884,
267501,
263716,
265468,
178433,
262579,
224332,
213925,
83429,
134439,
108664,
44224029,
10261747,
89073,
8722782,
162146,
203577,
109501,
175147,
174583,
41796413,
47202201,
254301,
31719532,
402843,
141656,
90791,
80345,
136555,
86746,
217510,
36278962,
108881,
105748,
226049,
185795,
111370,
241827,
266661,
89261,
172217,
174737,
106287,
206854,
135205,
265066,
23945599,
222491,
173273,
98639,
88121,
225305,
48897409,
189123,
267700,
1173892,
95043,
218149,
207780,
242786,
111091,
171085,
112984,
209483,
135519,
224773,
186795,
77403,
4791491,
383578,
110677,
126702,
208283,
148079,
161664,
20708505,
146129,
4061812,
170518,
202690,
30148041,
75680,
143950,
23106697,
13818591,
104583,
111341,
87518,
84605,
34719290,
193693,
265878,
119054,
84693,
218235,
239049,
212689,
9887645,
170725,
139824,
211891,
185961,
156556,
115223,
164309,
171662,
17594470,
162820,
100623,
80509,
186088,
227892,
261943,
192003,
242964,
251865,
21211748,
189226,
260943,
129897,
91149,
111521,
79610,
77676,
187810,
168470,
20627345,
44869050,
220655,
95652,
240404,
382826,
87340,
255905,
191047,
154226,
261090,
101549,
204528,
194917,
227481,
245659,
117486,
79926,
12253627,
91383,
87314,
219299,
102508,
121533,
223613,
124718,
145614,
255407,
176678,
209921,
75853,
192523,
139196,
147221,
212715,
128992,
223355,
134831,
170790,
154459,
97982,
191407,
200906,
178544,
169612,
138939,
96924,
108989,
15050850,
97682,
156120,
2853495,
190210,
75643,
76900,
87071,
201863,
8591193,
245886,
3224898,
228314,
222990,
209807,
89549,
3029831,
168606,
143351,
222689,
229470,
204161,
111003,
106770,
185439,
205629,
118332,
225374,
125266,
107859,
240971,
159735,
9700358,
191266,
187180,
74473,
27808178,
118621,
22568743,
199850,
115902,
193028,
79494,
140059,
143038,
7599993,
27199439,
100682,
84439,
31789631,
254574,
75009,
228572,
3224895,
8388337,
89886,
212164,
41024653,
79030,
77798,
86434,
255713,
5315068,
229397,
99548,
212929,
85349,
168114,
4061468,
190504,
21273299,
263121,
213063,
242085,
259743,
262617,
148602,
114251,
114017,
139671,
228856,
114786,
33072200,
4791488,
122718,
27808362,
111742,
37667633,
268989,
106889,
242703,
92184,
91180,
72773,
79701,
205836,
183075,
114609,
268647,
173082,
165937,
109374,
183391,
210522,
267851,
20512295,
200772,
268384,
23185284,
28138429,
179735,
1173491,
226977,
150349,
269658,
170874,
85437,
210612,
143785,
18810400,
202554,
245060,
88772,
125397,
190383,
210702,
195537,
187883,
161875,
103051,
174680,
199831,
42358761,
20972969,
165805,
7186183,
183290,
118392,
204827,
5957905,
210751,
179767,
160168,
195225,
116132,
172344,
122307,
218829,
200126,
118221,
383375,
74427,
182129,
1173124,
83176,
9129444,
125055,
265768,
132281,
250245,
242072,
199572,
182335,
9517217,
79212,
246469,
149700,
74534,
201319,
82308,
178072,
260687,
223960,
114925,
155523,
245591,
269445,
182728,
10039806,
260577,
263186,
224600,
42105593,
75600,
197379,
220170,
264308,
180306,
91582,
170704,
198994,
91777,
128052,
142776,
9282725,
148975,
120959,
177255,
120483,
75959,
383494,
115150,
81346,
74121,
268711,
199275,
85117,
36566491,
155984,
130799,
147033,
199934,
135829,
27076239,
2367452,
145352,
79424,
226395,
151031,
101813,
103499,
265378,
207573,
162948,
206641,
154301,
220948,
197713,
144112,
141037,
168884,
147191,
200283,
110374,
122101,
39558144,
268162,
100061,
174091,
383672,
82521,
383826,
4061779,
213358,
173543,
89349,
221136,
89709,
383286,
208516,
2977929,
210887,
266691,
227732,
162891,
37038521,
168676,
108551,
210439,
267314,
218032,
98352,
223447,
193721,
96112,
199295,
129814,
105369,
18810410,
256504,
135125,
175690,
82805,
190874,
246756,
39599857,
172317,
181569,
178916,
96619,
18323640,
4061656,
181441,
139974,
110254,
17275737,
164436,
172512,
177391,
179201,
148376,
141995,
171964,
199538,
96059,
266341,
199700,
111651,
219501,
202588,
261158,
80881,
84734,
157061,
169799,
204342,
163032,
242260,
219645,
266888,
87380,
73318,
244552,
167765,
126983,
98382,
143682,
193837,
155598,
117646,
241333,
240120,
135403,
418173,
191428,
140362,
155492,
29649833,
165025,
145685,
156310,
155228,
183196,
220877,
226215,
141880,
136036,
35241603,
74297,
223652,
188963,
106094,
3379718,
266243,
84203,
189271,
141472,
259918,
259359,
4061962,
229645,
153833,
145447,
261224,
166076,
80793,
93903,
214424,
190819,
151300,
126485,
15668814,
99420,
191455,
181278,
207430,
73135,
102558,
186109,
227572,
163958,
164573,
1173161,
16306657,
198534,
242014,
186921,
186236,
41752708,
262446,
94738,
74091,
8388408,
263799,
23106643,
156053,
147531,
171116,
157401,
6797421,
267530,
179118,
103592,
21308116,
185065,
73764,
133247,
146150,
174544,
187735,
113462,
227046,
142948,
117802,
87409,
98021,
192660,
136066,
82419,
240534,
189988,
77069,
89456,
256958,
227134,
131774,
199099,
182482,
180717,
205724,
261823,
209351,
160345,
105154,
173923,
231694,
1173158,
89745,
13723644,
3379737,
208831,
88849,
218293,
267623,
175232,
96781,
194023,
220531,
214433,
268304,
31665450,
240386,
119873,
132556,
383139,
383006,
134210,
212320,
185598,
77540,
145830,
132606,
196032,
245926,
156762,
194884,
157428,
2566227,
4442214,
260788,
106347,
75482,
101590,
101260,
178677,
244711,
211866,
83126,
149216,
166529,
126658,
102868,
1173542,
129031,
39355239,
150639,
251478,
159064,
108780,
212020,
82604,
263334,
26244429,
48897791,
147399,
87899,
92309,
13979961,
88890,
266814,
98451,
87012,
2470567,
150070,
161142,
84906,
267678,
8566620,
90455,
43751656,
134714,
7941416,
158481,
51503593,
187408,
128777,
101873,
269773,
103348,
223733,
145003,
193518,
22452518,
222458,
97550,
107057,
119718,
101969,
156724,
175902,
178962,
165965,
240646,
183531,
225267,
91812,
5315087,
221512,
47158244,
192391,
139070,
252035,
94404,
164234,
7016779,
265584,
189166,
228125,
101403,
75106,
136496,
218042,
128612,
161406,
227270,
195022,
181329,
223466,
146486,
213132,
188297,
249659,
43349109,
218521,
171431,
176897,
164128,
195558,
9872791,
209589,
7780777,
218076,
243999,
128888,
107555,
196249,
102976,
203485,
203394,
76116,
195136,
14623690,
198380,
192497,
261005,
383027,
108195,
105395,
160203,
23184951,
85808,
250318,
128526,
172278,
223510,
176992,
267023,
194471,
181045,
138437,
203729,
228246,
219157,
180387,
228944,
154180,
189670,
264897,
169035,
166413,
46461361,
191815,
132768,
247180,
134133,
145258,
212576,
127120,
72285,
209859,
212729,
38723937,
84542,
81094,
178215,
124237,
189598,
149007,
4442187,
139875,
102697,
33664677,
208674,
74880,
266112,
185888,
198187,
142573,
15659243,
194307,
38008495,
195918,
111604,
75898,
185864,
73900,
80548,
261338,
197565,
180504,
228789,
87856,
147869,
179886,
73395,
108520,
108052,
116102,
135012,
213047,
103833,
41634802,
266442,
190634,
35522295,
260555,
267186,
119097,
1173693,
241860,
240436,
200867,
115545,
105712,
168651,
135252,
8695139,
149155,
38621717,
200595,
151676,
204204,
99114,
203147,
151225,
384102,
154758,
146259,
135685,
121033,
228197,
229095,
210638,
194960,
1173603,
146703,
202441,
174181,
169959,
88291,
91914,
154051,
176975,
142318,
87219,
224446,
144833,
210718,
91843,
96354,
139042,
150701,
18332685,
147969,
135730,
149400,
209194,
205753,
104513,
146983,
74030,
107333,
182314,
176068,
135345,
102814,
242919,
194713,
30765443,
143537,
241967,
269473,
29311567,
186138,
171224,
128254,
105477,
188477,
72611,
106657,
99228,
210768,
142528,
5315084,
202202,
8618578,
243839,
251539,
244956,
189617,
195386,
198307,
87124,
130741,
10655859,
107023,
108003,
227765,
171586,
113392,
77134,
78974,
212394,
196083,
261973,
143596,
81720,
162257,
127993,
226499,
98121,
41214843,
167986,
190920,
188894,
81316,
12371222,
72528,
247088,
211759,
120394,
127946,
195347,
269401,
191210,
241089,
31419712,
144860,
182441,
88688,
81217,
85536,
110467,
129206,
46237639,
204745,
177333,
175610,
5957896,
250174,
192804,
95872,
241209,
139584,
83605,
147915,
156464,
203131,
104153,
221094,
202800,
188242,
80083,
206894,
3176489,
144062,
107364,
177852,
269023,
142897,
1173653,
162969,
207942,
122838,
176637,
107594,
94870,
27808352,
158648,
186259,
179813,
4580718,
197310,
91479,
130049,
205199,
22892606,
121463,
45539296,
1173121,
110338,
203882,
134322,
22840856,
88601,
132156,
250060,
100829,
178500,
253709,
249733,
120883,
170382,
185698,
268279,
202332,
206198,
203636,
244217,
78111,
92398,
179680,
262376,
177510,
226339,
220914,
263626,
220546,
148899,
250658,
162361,
27807955,
87970,
151587,
211256,
128141,
6771981,
124113,
98483,
95383,
247897,
174987,
140325,
138609,
150724,
97116,
248735,
13400949,
150874,
31077769,
94373,
115604,
240156,
90081,
188163,
13377190,
176111,
382743,
120627,
163235,
268917,
159639,
179171,
72244,
198814,
246306,
8870626,
37868209,
34037741,
174035,
261585,
129501,
109234,
110842,
131839,
110435,
157283,
32979456,
96266,
113160,
139146,
151636,
80940,
222748,
38622028,
227403,
227647,
124337,
266360,
116231,
251064,
146288,
163837,
142256,
81527,
73343,
149455,
73556,
211686,
262061,
225967,
197746,
109827,
7599407,
14669428,
166611,
101798,
31215812,
1904411,
197835,
164711,
208378,
130324,
384041,
167903,
255495,
86879,
179242,
201789,
220238,
223333,
119029,
254825,
131179,
144248,
86366,
125661,
38300874,
150752,
257470,
131085,
115484,
169525,
143260,
9700322,
384050,
81639,
23220930,
35700277,
4061851,
384128,
124869,
186869,
147609,
266549,
17877742,
239438,
139730,
146183,
166027,
163692,
171164,
166311,
49539249,
243243,
100207,
205363,
185045,
170902,
114505,
77357,
91299,
79763,
119809,
27486615,
187530,
181736,
220755,
223395,
243765,
218423,
134094,
11367104,
114041,
252403,
227558,
254246,
227604,
193372,
89565,
169666,
198592,
382988,
9290146,
166123,
130955,
122580,
176200,
198498,
101167,
156225,
123820,
192120,
131135,
245508,
8722785,
43581664,
222266,
4149175,
4442184,
383118,
164198,
160274,
109732,
22882595,
190401,
129096,
118447,
195113,
251659,
189874,
133017,
225195,
133887,
193149,
213537,
205800,
80315,
144374,
176007,
249148,
263475,
78233,
195752,
383497,
34636746,
96544,
144556,
218375,
78778,
1173251,
224525,
138736,
159538,
221173,
158547,
256037,
208746,
101745,
46904829,
146572,
1845849,
98309,
257550,
110779,
244970,
266061,
15243082,
9700388,
26684056,
152590,
174941,
174798,
95803,
113819,
130026,
4442181,
180460,
193204,
252832,
170491,
49539259,
204651,
213869,
186209,
139639,
260613,
79343,
219686,
160845,
107672,
115132,
139252,
144517,
208902,
187460,
204776,
5957902,
202099,
253165,
190061,
203901,
262167,
143448,
162656,
94129,
149098,
176244,
225007,
181884,
221593,
250387,
190546,
173880,
220693,
103317,
122139,
37366700,
105761,
141562,
39995931,
252859,
124829,
91521,
219012,
147152,
138273,
265930,
225114,
95945,
90363,
247473,
154116,
156882,
115753,
158905,
102372,
150008,
117438,
5160343,
192284,
171353,
135953,
263240,
160247,
265965,
76091,
122810,
9395965,
206591,
160614,
89972,
268951,
145494,
150197,
32742951,
220483,
1173254,
243956,
223285,
143202,
103526,
189797,
245836,
84306,
254732,
97583,
205897,
196171,
76562,
142376,
132963,
265305,
257732,
4061766,
74757,
73689,
199364,
97423,
212470,
125952,
170268,
264448,
187757,
214160,
204973,
9700382,
100524,
260508,
187073,
141808,
90830,
195314,
223044,
136417,
149642,
157541,
6771978,
185208,
219804,
114455,
156617,
140833,
50388225,
26970115,
149059,
213283,
205493,
129533,
75190,
6775934,
187911,
77600,
7541413,
221442,
162327,
111233,
90672,
208932,
115353,
155356,
207463,
2655510,
263995,
175792,
245352,
122780,
177157,
176296,
157359,
201732,
193952,
114320,
200435,
246876,
244648,
136526,
17058949,
165005,
122527,
212066,
9517247,
96500,
98441,
202896,
251348,
157224,
220200,
170765,
11213840,
180007,
7967625,
129250,
77223,
170037,
46236871,
268827,
98180,
248414,
186176,
218867,
146397,
383256,
245240,
250829,
204855,
190150,
7678621,
6614248,
7217358,
173474,
249871,
37868894,
267580,
38670305,
21237158,
178337,
211155,
164042,
130267,
111071,
151568
)
AND pt.stdOccupancy BETWEEN bp.occupancyFrom
AND bp.occupancyTo
AND price > 0
and (
select
active
from
`steiermark`.object_6 product
where
product.o_id = pt.product_id
)
order by
minPrice
SELECT pt.acco_id, pt.product_id, bp.price as minPrice, pt.rule type, pt.nights nights
FROM `steiermark_vacancies`.price_template pt
INNER JOIN
`steiermark_vacancies`.price_template_base_prices bp
ON bp.price_template_id = pt.id
WHERE pt.acco_id IN (191516,261287,180106,267915,103365,229144,86586,201425,256266,177439,191937,173849,188200,148211,162295,181966,228288,90325,154821,227190,97625,101229,76033,253939,164670,98143,163153,171766,150268,1173353,158731,255823,130455,1173742,260387,383021,104781,209213,121638,132704,162100,160120,138703,249413,14557855,81753,262837,106040,156918,113751,157149,161033,220403,34219679,203617,173602,114734,21161019,175319,90285,97332,120314,246836,128649,106445,228081,142725,208002,250696,265826,242815,268424,213326,136200,247967,257803,177240,131790,99678,147332,197648,260291,178599,206964,22892603,202479,257010,124000,78857,4061616,229314,241670,157521,176727,73645,256553,192306,383292,18355899,138331,256818,235840,144028,131018,259830,208109,157109,39225141,90162,241752,207763,221382,113085,125739,75414,180136,214015,41680612,51216654,156680,168086,241513,151492,171549,154608,268018,49169351,192842,191155,238918,151257,234239,141729,164627,262206,259974,27128134,229040,194565,9290160,94222,26648317,220348,171978,91679,81984,174338,197250,124606,78602,213843,244042,265255,154873,4791485,108105,199975,113626,243209,252258,33267404,3118747,5160340,192033,124694,203308,136181,383360,194797,209054,7715980,27808188,20059276,102266,113408,209292,255957,148562,233730,260733,26898515,172618,83792,140245,157466,384186,219765,117877,222898,176457,23455826,145409,31514436,211808,168744,128321,199742,3379819,148779,207109,141272,33072197,143736,109291,245784,160801,261487,47294199,259576,27224568,3411816,76427,38050667,201802,7599929,87467,221211,217376,44404593,209445,115416,121323,256865,193068,93789,74347,117916,9700325,155681,261884,267501,263716,265468,178433,262579,224332,213925,83429,134439,108664,44224029,10261747,89073,8722782,162146,203577,109501,175147,174583,41796413,47202201,254301,31719532,402843,141656,90791,80345,136555,86746,217510,36278962,108881,105748,226049,185795,111370,241827,266661,89261,172217,174737,106287,206854,135205,265066,23945599,222491,173273,98639,88121,225305,48897409,189123,267700,1173892,95043,218149,207780,242786,111091,171085,112984,209483,135519,224773,186795,77403,4791491,383578,110677,126702,208283,148079,161664,20708505,146129,4061812,170518,202690,30148041,75680,143950,23106697,13818591,104583,111341,87518,84605,34719290,193693,265878,119054,84693,218235,239049,212689,9887645,170725,139824,211891,185961,156556,115223,164309,171662,17594470,162820,100623,80509,186088,227892,261943,192003,242964,251865,21211748,189226,260943,129897,91149,111521,79610,77676,187810,168470,20627345,44869050,220655,95652,240404,382826,87340,255905,191047,154226,261090,101549,204528,194917,227481,245659,117486,79926,12253627,91383,87314,219299,102508,121533,223613,124718,145614,255407,176678,209921,75853,192523,139196,147221,212715,128992,223355,134831,170790,154459,97982,191407,200906,178544,169612,138939,96924,108989,15050850,97682,156120,2853495,190210,75643,76900,87071,201863,8591193,245886,3224898,228314,222990,209807,89549,3029831,168606,143351,222689,229470,204161,111003,106770,185439,205629,118332,225374,125266,107859,240971,159735,9700358,191266,187180,74473,27808178,118621,22568743,199850,115902,193028,79494,140059,143038,7599993,27199439,100682,84439,31789631,254574,75009,228572,3224895,8388337,89886,212164,41024653,79030,77798,86434,255713,5315068,229397,99548,212929,85349,168114,4061468,190504,21273299,263121,213063,242085,259743,262617,148602,114251,114017,139671,228856,114786,33072200,4791488,122718,27808362,111742,37667633,268989,106889,242703,92184,91180,72773,79701,205836,183075,114609,268647,173082,165937,109374,183391,210522,267851,20512295,200772,268384,23185284,28138429,179735,1173491,226977,150349,269658,170874,85437,210612,143785,18810400,202554,245060,88772,125397,190383,210702,195537,187883,161875,103051,174680,199831,42358761,20972969,165805,7186183,183290,118392,204827,5957905,210751,179767,160168,195225,116132,172344,122307,218829,200126,118221,383375,74427,182129,1173124,83176,9129444,125055,265768,132281,250245,242072,199572,182335,9517217,79212,246469,149700,74534,201319,82308,178072,260687,223960,114925,155523,245591,269445,182728,10039806,260577,263186,224600,42105593,75600,197379,220170,264308,180306,91582,170704,198994,91777,128052,142776,9282725,148975,120959,177255,120483,75959,383494,115150,81346,74121,268711,199275,85117,36566491,155984,130799,147033,199934,135829,27076239,2367452,145352,79424,226395,151031,101813,103499,265378,207573,162948,206641,154301,220948,197713,144112,141037,168884,147191,200283,110374,122101,39558144,268162,100061,174091,383672,82521,383826,4061779,213358,173543,89349,221136,89709,383286,208516,2977929,210887,266691,227732,162891,37038521,168676,108551,210439,267314,218032,98352,223447,193721,96112,199295,129814,105369,18810410,256504,135125,175690,82805,190874,246756,39599857,172317,181569,178916,96619,18323640,4061656,181441,139974,110254,17275737,164436,172512,177391,179201,148376,141995,171964,199538,96059,266341,199700,111651,219501,202588,261158,80881,84734,157061,169799,204342,163032,242260,219645,266888,87380,73318,244552,167765,126983,98382,143682,193837,155598,117646,241333,240120,135403,418173,191428,140362,155492,29649833,165025,145685,156310,155228,183196,220877,226215,141880,136036,35241603,74297,223652,188963,106094,3379718,266243,84203,189271,141472,259918,259359,4061962,229645,153833,145447,261224,166076,80793,93903,214424,190819,151300,126485,15668814,99420,191455,181278,207430,73135,102558,186109,227572,163958,164573,1173161,16306657,198534,242014,186921,186236,41752708,262446,94738,74091,8388408,263799,23106643,156053,147531,171116,157401,6797421,267530,179118,103592,21308116,185065,73764,133247,146150,174544,187735,113462,227046,142948,117802,87409,98021,192660,136066,82419,240534,189988,77069,89456,256958,227134,131774,199099,182482,180717,205724,261823,209351,160345,105154,173923,231694,1173158,89745,13723644,3379737,208831,88849,218293,267623,175232,96781,194023,220531,214433,268304,31665450,240386,119873,132556,383139,383006,134210,212320,185598,77540,145830,132606,196032,245926,156762,194884,157428,2566227,4442214,260788,106347,75482,101590,101260,178677,244711,211866,83126,149216,166529,126658,102868,1173542,129031,39355239,150639,251478,159064,108780,212020,82604,263334,26244429,48897791,147399,87899,92309,13979961,88890,266814,98451,87012,2470567,150070,161142,84906,267678,8566620,90455,43751656,134714,7941416,158481,51503593,187408,128777,101873,269773,103348,223733,145003,193518,22452518,222458,97550,107057,119718,101969,156724,175902,178962,165965,240646,183531,225267,91812,5315087,221512,47158244,192391,139070,252035,94404,164234,7016779,265584,189166,228125,101403,75106,136496,218042,128612,161406,227270,195022,181329,223466,146486,213132,188297,249659,43349109,218521,171431,176897,164128,195558,9872791,209589,7780777,218076,243999,128888,107555,196249,102976,203485,203394,76116,195136,14623690,198380,192497,261005,383027,108195,105395,160203,23184951,85808,250318,128526,172278,223510,176992,267023,194471,181045,138437,203729,228246,219157,180387,228944,154180,189670,264897,169035,166413,46461361,191815,132768,247180,134133,145258,212576,127120,72285,209859,212729,38723937,84542,81094,178215,124237,189598,149007,4442187,139875,102697,33664677,208674,74880,266112,185888,198187,142573,15659243,194307,38008495,195918,111604,75898,185864,73900,80548,261338,197565,180504,228789,87856,147869,179886,73395,108520,108052,116102,135012,213047,103833,41634802,266442,190634,35522295,260555,267186,119097,1173693,241860,240436,200867,115545,105712,168651,135252,8695139,149155,38621717,200595,151676,204204,99114,203147,151225,384102,154758,146259,135685,121033,228197,229095,210638,194960,1173603,146703,202441,174181,169959,88291,91914,154051,176975,142318,87219,224446,144833,210718,91843,96354,139042,150701,18332685,147969,135730,149400,209194,205753,104513,146983,74030,107333,182314,176068,135345,102814,242919,194713,30765443,143537,241967,269473,29311567,186138,171224,128254,105477,188477,72611,106657,99228,210768,142528,5315084,202202,8618578,243839,251539,244956,189617,195386,198307,87124,130741,10655859,107023,108003,227765,171586,113392,77134,78974,212394,196083,261973,143596,81720,162257,127993,226499,98121,41214843,167986,190920,188894,81316,12371222,72528,247088,211759,120394,127946,195347,269401,191210,241089,31419712,144860,182441,88688,81217,85536,110467,129206,46237639,204745,177333,175610,5957896,250174,192804,95872,241209,139584,83605,147915,156464,203131,104153,221094,202800,188242,80083,206894,3176489,144062,107364,177852,269023,142897,1173653,162969,207942,122838,176637,107594,94870,27808352,158648,186259,179813,4580718,197310,91479,130049,205199,22892606,121463,45539296,1173121,110338,203882,134322,22840856,88601,132156,250060,100829,178500,253709,249733,120883,170382,185698,268279,202332,206198,203636,244217,78111,92398,179680,262376,177510,226339,220914,263626,220546,148899,250658,162361,27807955,87970,151587,211256,128141,6771981,124113,98483,95383,247897,174987,140325,138609,150724,97116,248735,13400949,150874,31077769,94373,115604,240156,90081,188163,13377190,176111,382743,120627,163235,268917,159639,179171,72244,198814,246306,8870626,37868209,34037741,174035,261585,129501,109234,110842,131839,110435,157283,32979456,96266,113160,139146,151636,80940,222748,38622028,227403,227647,124337,266360,116231,251064,146288,163837,142256,81527,73343,149455,73556,211686,262061,225967,197746,109827,7599407,14669428,166611,101798,31215812,1904411,197835,164711,208378,130324,384041,167903,255495,86879,179242,201789,220238,223333,119029,254825,131179,144248,86366,125661,38300874,150752,257470,131085,115484,169525,143260,9700322,384050,81639,23220930,35700277,4061851,384128,124869,186869,147609,266549,17877742,239438,139730,146183,166027,163692,171164,166311,49539249,243243,100207,205363,185045,170902,114505,77357,91299,79763,119809,27486615,187530,181736,220755,223395,243765,218423,134094,11367104,114041,252403,227558,254246,227604,193372,89565,169666,198592,382988,9290146,166123,130955,122580,176200,198498,101167,156225,123820,192120,131135,245508,8722785,43581664,222266,4149175,4442184,383118,164198,160274,109732,22882595,190401,129096,118447,195113,251659,189874,133017,225195,133887,193149,213537,205800,80315,144374,176007,249148,263475,78233,195752,383497,34636746,96544,144556,218375,78778,1173251,224525,138736,159538,221173,158547,256037,208746,101745,46904829,146572,1845849,98309,257550,110779,244970,266061,15243082,9700388,26684056,152590,174941,174798,95803,113819,130026,4442181,180460,193204,252832,170491,49539259,204651,213869,186209,139639,260613,79343,219686,160845,107672,115132,139252,144517,208902,187460,204776,5957902,202099,253165,190061,203901,262167,143448,162656,94129,149098,176244,225007,181884,221593,250387,190546,173880,220693,103317,122139,37366700,105761,141562,39995931,252859,124829,91521,219012,147152,138273,265930,225114,95945,90363,247473,154116,156882,115753,158905,102372,150008,117438,5160343,192284,171353,135953,263240,160247,265965,76091,122810,9395965,206591,160614,89972,268951,145494,150197,32742951,220483,1173254,243956,223285,143202,103526,189797,245836,84306,254732,97583,205897,196171,76562,142376,132963,265305,257732,4061766,74757,73689,199364,97423,212470,125952,170268,264448,187757,214160,204973,9700382,100524,260508,187073,141808,90830,195314,223044,136417,149642,157541,6771978,185208,219804,114455,156617,140833,50388225,26970115,149059,213283,205493,129533,75190,6775934,187911,77600,7541413,221442,162327,111233,90672,208932,115353,155356,207463,2655510,263995,175792,245352,122780,177157,176296,157359,201732,193952,114320,200435,246876,244648,136526,17058949,165005,122527,212066,9517247,96500,98441,202896,251348,157224,220200,170765,11213840,180007,7967625,129250,77223,170037,46236871,268827,98180,248414,186176,218867,146397,383256,245240,250829,204855,190150,7678621,6614248,7217358,173474,249871,37868894,267580,38670305,21237158,178337,211155,164042,130267,111071,151568)
AND pt.stdOccupancy BETWEEN bp.occupancyFrom AND bp.occupancyTo
AND price > 0 and (select active from `steiermark`.object_6 product where product.o_id = pt.product_id)
order by minPrice
;
|
127.64 ms (28.07%)
|
14 |
SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (191516,261287,180106,267915,103365,229144,86586,201425,256266,177439,191937,173849,188200,148211,162295,181966,228288,90325,154821,227190,97625,101229,76033,253939,164670,98143,163153,171766,150268,1173353,158731,255823,130455,1173742,260387,383021,104781,209213,121638,132704,162100,160120,138703,249413,14557855,81753,262837,106040,156918,113751,161033,220403,34219679,203617,173602,114734,21161019,175319,90285,97332,120314,246836,128649,106445,228081,142725,208002,250696,265826,242815,268424,213326,136200,247967,257803,177240,131790,99678,147332,197648,260291,178599,206964,22892603,202479,257010,124000,78857,4061616,229314,241670,157521,176727,73645,256553,192306,383292,18355899,138331,256818,235840,144028,131018,259830,208109,157109,39225141,90162,241752,207763,221382,113085,125739,75414,180136,214015,41680612,51216654,156680,168086,241513,151492,171549,154608,268018,49169351,192842,191155,238918,151257,234239,141729,164627,262206,259974,27128134,229040,194565,9290160,94222,26648317,220348,171978,91679,81984,174338,197250,124606,78602,213843,244042,265255,154873,108105,199975,113626,243209,252258,33267404,3118747,5160340,192033,124694,203308,136181,383360,194797,209054,7715980,27808188,20059276,102266,113408,209292,255957,148562,233730,260733,26898515,172618,83792,140245,157466,384186,219765,222898,176457,23455826,145409,31514436,211808,168744,128321,199742,3379819,148779,207109,141272,33072197,143736,109291,245784,160801,261487,47294199,259576,27224568,3411816,76427,38050667,201802,7599929,87467,221211,217376,44404593,209445,115416,121323,256865,193068,93789,74347,117916,155681,261884,267501,263716,265468,178433,262579,224332,213925,83429,134439,108664,44224029,10261747,89073,8722782,162146,203577,109501,175147,174583,41796413,47202201,254301,31719532,402843,141656,90791,80345,136555,86746,217510,36278962,108881,105748,226049,185795,111370,241827,266661,89261,172217,174737,106287,206854,135205,265066,23945599,222491,173273,98639,88121,225305,48897409,189123,267700,1173892,95043,218149,207780,242786,111091,171085,112984,209483,135519,224773,186795,77403,4791491,383578,110677,126702,208283,148079,161664,20708505,146129,4061812,170518,202690,30148041,75680,143950,23106697,13818591,104583,111341,87518,84605,34719290,193693,265878,119054,84693,218235,239049,212689,9887645,170725,139824,211891,185961,156556,115223,164309,171662,17594470,162820,100623,80509,186088,227892,261943,192003,242964,251865,21211748,189226,260943,129897,91149,111521,79610,77676,187810,168470,20627345,44869050,220655,95652,240404,382826,87340,255905,191047,154226,261090,101549,204528,194917,227481,245659,117486,79926,12253627,91383,87314,219299,102508,121533,223613,124718,145614,255407,176678,209921,75853,192523,139196,147221,212715,128992,223355,134831,170790,154459,97982,191407,200906,178544,169612,138939,96924,108989,15050850,97682,156120,2853495,190210,75643,76900,87071,201863,8591193,245886,3224898,228314,222990,209807,89549,3029831,168606,143351,222689,229470,204161,111003,106770,185439,205629,118332,225374,125266,107859,240971,159735,9700358,191266,187180,74473,27808178,118621,22568743,199850,115902,193028,79494,140059,143038,7599993,27199439,100682,84439,31789631,254574,75009,228572,3224895,8388337,89886,212164,41024653,79030,77798,86434,255713,5315068,229397,99548,212929,85349,168114,4061468,190504,21273299,263121,213063,242085,262617,148602,114251,114017,139671,228856,114786,33072200,4791488,122718,27808362,111742,37667633,268989,106889,242703,92184,91180,72773,79701,205836,183075,114609,268647,173082,165937,109374,183391,210522,267851,20512295,200772,23185284,28138429,179735,1173491,226977,150349,269658,170874,85437,210612,143785,18810400,245060,88772,125397,190383,210702,195537,187883,161875,103051,174680,199831,42358761,20972969,165805,7186183,183290,118392,204827,210751,179767,160168,195225,116132,172344,122307,218829,200126,118221,383375,74427,182129,1173124,83176,9129444,125055,265768,132281,250245,242072,199572,182335,9517217,79212,246469,149700,74534,201319,82308,178072,260687,223960,114925,155523,245591,269445,182728,10039806,260577,263186,224600,42105593,75600,197379,220170,264308,180306,91582,170704,198994,91777,128052,142776,9282725,148975,120959,177255,120483,75959,383494,115150,81346,74121,268711,199275,85117,36566491,155984,130799,147033,199934,135829,27076239,2367452,145352,79424,226395,151031,101813,265378,207573,162948,206641,154301,220948,197713,144112,141037,168884,147191,200283,110374,122101,39558144,268162,100061,174091,383672,82521,383826,4061779,213358,173543,89349,221136,89709,383286,208516,2977929,210887,266691,227732,162891,37038521,168676,108551,210439,267314,218032,98352,223447,193721,96112,199295,129814,18810410,256504,135125,175690,82805,190874,246756,39599857,172317,181569,178916,96619,18323640,4061656,181441,139974,110254,17275737,164436,172512,177391,179201,148376,141995,171964,199538,96059,266341,199700,111651,219501,202588,261158,80881,84734,157061,169799,163032,242260,219645,266888,87380,73318,244552,167765,126983,98382,143682,193837,155598,117646,241333,240120,135403,418173,140362,155492,29649833,165025,145685,156310,155228,183196,220877,226215,141880,136036,35241603,74297,223652,188963,106094,3379718,266243,84203,189271,141472,259918,259359,4061962,229645,153833,145447,261224,166076,80793,93903,190819,151300,126485,15668814,99420,191455,207430,73135,102558,186109,227572,163958,164573,1173161,16306657,198534,242014,186921,186236,41752708,262446,94738,74091,8388408,263799,23106643,156053,147531,171116,157401,6797421,267530,179118,103592,21308116,185065,73764,133247,146150,174544,187735,113462,227046,142948,117802,87409,98021,192660,136066,82419,240534,189988,77069,89456,256958,227134,131774,199099,182482,180717,205724,261823,209351,160345,105154,173923,231694,89745,13723644,3379737,208831,88849,218293,267623,175232,96781,194023,214433,268304,31665450,240386,119873,132556,383139,383006,134210,212320,185598,77540,145830,132606,196032,245926,156762,194884,157428,2566227,4442214,260788,106347,75482,101590,101260,178677,244711,211866,83126,149216,166529,126658,102868,1173542,129031,39355239,150639,251478,159064,108780,212020,82604,263334,26244429,48897791,147399,87899,92309,13979961,88890,266814,98451,87012,2470567,150070,161142,84906,267678,8566620,90455,134714,7941416,158481,51503593,187408,128777,101873,269773,103348,223733,145003,193518,22452518,222458,97550,107057,119718,101969,156724,175902,178962,165965,240646,183531,225267,91812,5315087,221512,47158244,192391,139070,252035,94404,164234,7016779,265584,189166,228125,101403,75106,136496,218042,128612,161406,227270,195022,181329,223466,146486,213132,188297,249659,43349109,218521,171431,176897,164128,195558,9872791,209589,7780777,218076,243999,128888,107555,196249,102976,203485,203394,76116,195136,14623690,198380,192497,261005,383027,108195,105395,160203,23184951,85808,250318,128526,172278,223510,176992,267023,194471,181045,138437,203729,228246,219157,180387,228944,154180,189670,264897,169035,166413,46461361,191815,132768,247180,134133,145258,212576,127120,72285,209859,212729,38723937,84542,81094,178215,124237,189598,149007,4442187,139875,102697,33664677,208674,74880,266112,185888,198187,142573,15659243,194307,38008495,195918,111604,75898,185864,73900,80548,197565,180504,228789,87856,147869,179886,73395,108520,108052,116102,135012,213047,103833,41634802,266442,190634,35522295,260555,267186,119097,1173693,241860,240436,200867,115545,105712,168651,135252,8695139,149155,38621717,200595,151676,204204,99114,203147,151225,384102,154758,146259,135685,121033,228197,229095,210638,194960,1173603,146703,202441,174181,169959,88291,91914,154051,176975,142318,87219,224446,144833,210718,91843,96354,139042,150701,18332685,147969,135730,149400,209194,205753,104513,146983,74030,107333,182314,176068,135345,102814,242919,194713,30765443,143537,241967,269473,29311567,186138,171224,128254,105477,188477,72611,106657,99228,210768,142528,5315084,202202,8618578,243839,244956,189617,195386,198307,87124,130741,10655859,107023,227765,171586,113392,77134,78974,212394,196083,261973,143596,81720,162257,127993,226499,98121,41214843,167986,190920,188894,81316,12371222,72528,247088,211759,120394,127946,195347,269401,191210,241089,31419712,144860,182441,88688,81217,85536,110467,129206,46237639,204745,177333,175610,250174,192804,95872,241209,139584,83605,147915,156464,203131,104153,221094,202800,188242,80083,206894,3176489,144062,107364,177852,269023,142897,1173653,162969,207942,122838,176637,107594,94870,27808352,158648,186259,179813,4580718,197310,91479,130049,205199,22892606,121463,45539296,110338,203882,134322,22840856,88601,132156,250060,100829,178500,253709,249733,120883,170382,185698,268279,202332,206198,203636,244217,78111,92398,179680,262376,177510,226339,220914,263626,220546,148899,250658,162361,27807955,87970,151587,211256,128141,6771981,124113,98483,95383,174987,140325,138609,150724,97116,248735,13400949,150874,31077769,94373,115604,240156,90081,13377190,176111,382743,120627,268917,159639,179171,72244,198814,246306,8870626,37868209,34037741,174035,261585,129501,109234,110842,131839,110435,157283,32979456,96266,113160,139146,151636,80940,222748,227403,227647,124337,266360,116231,251064,146288,163837,142256,81527,73343,149455,73556,211686,262061,225967,197746,109827,7599407,14669428,166611,101798,31215812,1904411,197835,164711,208378,130324,384041,167903,255495,86879,179242,201789,220238,223333,119029,254825,131179,144248,86366,125661,38300874,150752,257470,131085,115484,169525,143260,384050,81639,23220930,35700277,4061851,124869,186869,147609,266549,17877742,239438,139730,146183,166027,163692,171164,166311,49539249,243243,100207,205363,185045,170902,114505,77357,91299,79763,119809,27486615,187530,181736,220755,223395,243765,218423,134094,11367104,114041,252403,227558,254246,227604,193372,89565,169666,198592,382988,9290146,166123,130955,122580,176200,198498,101167,156225,123820,192120,131135,245508,8722785,43581664,222266,4149175,4442184,383118,164198,160274,109732,190401,129096,118447,195113,251659,189874,133017,225195,133887,193149,213537,205800,80315,144374,176007,249148,263475,78233,195752,383497,34636746,96544,144556,218375,78778,1173251,224525,138736,159538,221173,158547,256037,208746,101745,46904829,146572,1845849,98309,257550,110779,244970,266061,15243082,26684056,152590,174941,174798,95803,113819,130026,4442181,180460,193204,252832,170491,49539259,204651,213869,186209,139639,260613,79343,219686,160845,107672,115132,139252,144517,208902,187460,204776,202099,253165,190061,203901,262167,143448,162656,94129,149098,176244,225007,181884,221593,250387,190546,173880,220693,103317,122139,37366700,105761,141562,39995931,252859,124829,91521,219012,147152,138273,265930,225114,95945,90363,247473,154116,156882,115753,158905,102372,150008,117438,5160343,192284,171353,135953,263240,160247,265965,76091,122810,9395965,206591,160614,89972,268951,145494,150197,32742951,220483,1173254,243956,223285,103526,189797,245836,84306,254732,97583,205897,196171,76562,142376,132963,265305,257732,4061766,74757,73689,199364,97423,212470,125952,170268,264448,187757,214160,204973,100524,260508,187073,141808,90830,195314,223044,136417,149642,157541,185208,219804,114455,156617,140833,50388225,26970115,149059,213283,205493,129533,75190,6775934,187911,77600,7541413,221442,162327,111233,90672,208932,115353,155356,207463,2655510,263995,175792,245352,122780,177157,176296,157359,201732,193952,114320,200435,246876,244648,136526,165005,122527,212066,9517247,96500,98441,202896,251348,157224,220200,170765,11213840,180007,7967625,129250,77223,170037,46236871,268827,98180,248414,186176,218867,146397,383256,245240,250829,204855,190150,7678621,6614248,7217358,173474,249871,37868894,267580,38670305,21237158,178337,211155,164042,130267,111071,151568,157149,4791485,117877,9700325,259743,268384,202554,5957905,103499,105369,204342,191428,214424,181278,1173158,220531,43751656,261338,251539,108003,5957896,1173121,247897,188163,163235,38622028,9700322,384128,22882595,9700388,5957902,143202,9700382,6771978,17058949) AND dacco.o_published = 1 AND (dacco.town__id IN (11195, 11196, 11191, 11194, 11190, 3192509, 11197, 11409)) GROUP BY dacco.oo_id ORDER BY RAND(662)
SELECT
dacco.isTop,
dacco.bookable,
dacco.oo_id oo_id
FROM
`steiermark`.object_8 dacco
WHERE
dacco.oo_id IN (
191516,
261287,
180106,
267915,
103365,
229144,
86586,
201425,
256266,
177439,
191937,
173849,
188200,
148211,
162295,
181966,
228288,
90325,
154821,
227190,
97625,
101229,
76033,
253939,
164670,
98143,
163153,
171766,
150268,
1173353,
158731,
255823,
130455,
1173742,
260387,
383021,
104781,
209213,
121638,
132704,
162100,
160120,
138703,
249413,
14557855,
81753,
262837,
106040,
156918,
113751,
161033,
220403,
34219679,
203617,
173602,
114734,
21161019,
175319,
90285,
97332,
120314,
246836,
128649,
106445,
228081,
142725,
208002,
250696,
265826,
242815,
268424,
213326,
136200,
247967,
257803,
177240,
131790,
99678,
147332,
197648,
260291,
178599,
206964,
22892603,
202479,
257010,
124000,
78857,
4061616,
229314,
241670,
157521,
176727,
73645,
256553,
192306,
383292,
18355899,
138331,
256818,
235840,
144028,
131018,
259830,
208109,
157109,
39225141,
90162,
241752,
207763,
221382,
113085,
125739,
75414,
180136,
214015,
41680612,
51216654,
156680,
168086,
241513,
151492,
171549,
154608,
268018,
49169351,
192842,
191155,
238918,
151257,
234239,
141729,
164627,
262206,
259974,
27128134,
229040,
194565,
9290160,
94222,
26648317,
220348,
171978,
91679,
81984,
174338,
197250,
124606,
78602,
213843,
244042,
265255,
154873,
108105,
199975,
113626,
243209,
252258,
33267404,
3118747,
5160340,
192033,
124694,
203308,
136181,
383360,
194797,
209054,
7715980,
27808188,
20059276,
102266,
113408,
209292,
255957,
148562,
233730,
260733,
26898515,
172618,
83792,
140245,
157466,
384186,
219765,
222898,
176457,
23455826,
145409,
31514436,
211808,
168744,
128321,
199742,
3379819,
148779,
207109,
141272,
33072197,
143736,
109291,
245784,
160801,
261487,
47294199,
259576,
27224568,
3411816,
76427,
38050667,
201802,
7599929,
87467,
221211,
217376,
44404593,
209445,
115416,
121323,
256865,
193068,
93789,
74347,
117916,
155681,
261884,
267501,
263716,
265468,
178433,
262579,
224332,
213925,
83429,
134439,
108664,
44224029,
10261747,
89073,
8722782,
162146,
203577,
109501,
175147,
174583,
41796413,
47202201,
254301,
31719532,
402843,
141656,
90791,
80345,
136555,
86746,
217510,
36278962,
108881,
105748,
226049,
185795,
111370,
241827,
266661,
89261,
172217,
174737,
106287,
206854,
135205,
265066,
23945599,
222491,
173273,
98639,
88121,
225305,
48897409,
189123,
267700,
1173892,
95043,
218149,
207780,
242786,
111091,
171085,
112984,
209483,
135519,
224773,
186795,
77403,
4791491,
383578,
110677,
126702,
208283,
148079,
161664,
20708505,
146129,
4061812,
170518,
202690,
30148041,
75680,
143950,
23106697,
13818591,
104583,
111341,
87518,
84605,
34719290,
193693,
265878,
119054,
84693,
218235,
239049,
212689,
9887645,
170725,
139824,
211891,
185961,
156556,
115223,
164309,
171662,
17594470,
162820,
100623,
80509,
186088,
227892,
261943,
192003,
242964,
251865,
21211748,
189226,
260943,
129897,
91149,
111521,
79610,
77676,
187810,
168470,
20627345,
44869050,
220655,
95652,
240404,
382826,
87340,
255905,
191047,
154226,
261090,
101549,
204528,
194917,
227481,
245659,
117486,
79926,
12253627,
91383,
87314,
219299,
102508,
121533,
223613,
124718,
145614,
255407,
176678,
209921,
75853,
192523,
139196,
147221,
212715,
128992,
223355,
134831,
170790,
154459,
97982,
191407,
200906,
178544,
169612,
138939,
96924,
108989,
15050850,
97682,
156120,
2853495,
190210,
75643,
76900,
87071,
201863,
8591193,
245886,
3224898,
228314,
222990,
209807,
89549,
3029831,
168606,
143351,
222689,
229470,
204161,
111003,
106770,
185439,
205629,
118332,
225374,
125266,
107859,
240971,
159735,
9700358,
191266,
187180,
74473,
27808178,
118621,
22568743,
199850,
115902,
193028,
79494,
140059,
143038,
7599993,
27199439,
100682,
84439,
31789631,
254574,
75009,
228572,
3224895,
8388337,
89886,
212164,
41024653,
79030,
77798,
86434,
255713,
5315068,
229397,
99548,
212929,
85349,
168114,
4061468,
190504,
21273299,
263121,
213063,
242085,
262617,
148602,
114251,
114017,
139671,
228856,
114786,
33072200,
4791488,
122718,
27808362,
111742,
37667633,
268989,
106889,
242703,
92184,
91180,
72773,
79701,
205836,
183075,
114609,
268647,
173082,
165937,
109374,
183391,
210522,
267851,
20512295,
200772,
23185284,
28138429,
179735,
1173491,
226977,
150349,
269658,
170874,
85437,
210612,
143785,
18810400,
245060,
88772,
125397,
190383,
210702,
195537,
187883,
161875,
103051,
174680,
199831,
42358761,
20972969,
165805,
7186183,
183290,
118392,
204827,
210751,
179767,
160168,
195225,
116132,
172344,
122307,
218829,
200126,
118221,
383375,
74427,
182129,
1173124,
83176,
9129444,
125055,
265768,
132281,
250245,
242072,
199572,
182335,
9517217,
79212,
246469,
149700,
74534,
201319,
82308,
178072,
260687,
223960,
114925,
155523,
245591,
269445,
182728,
10039806,
260577,
263186,
224600,
42105593,
75600,
197379,
220170,
264308,
180306,
91582,
170704,
198994,
91777,
128052,
142776,
9282725,
148975,
120959,
177255,
120483,
75959,
383494,
115150,
81346,
74121,
268711,
199275,
85117,
36566491,
155984,
130799,
147033,
199934,
135829,
27076239,
2367452,
145352,
79424,
226395,
151031,
101813,
265378,
207573,
162948,
206641,
154301,
220948,
197713,
144112,
141037,
168884,
147191,
200283,
110374,
122101,
39558144,
268162,
100061,
174091,
383672,
82521,
383826,
4061779,
213358,
173543,
89349,
221136,
89709,
383286,
208516,
2977929,
210887,
266691,
227732,
162891,
37038521,
168676,
108551,
210439,
267314,
218032,
98352,
223447,
193721,
96112,
199295,
129814,
18810410,
256504,
135125,
175690,
82805,
190874,
246756,
39599857,
172317,
181569,
178916,
96619,
18323640,
4061656,
181441,
139974,
110254,
17275737,
164436,
172512,
177391,
179201,
148376,
141995,
171964,
199538,
96059,
266341,
199700,
111651,
219501,
202588,
261158,
80881,
84734,
157061,
169799,
163032,
242260,
219645,
266888,
87380,
73318,
244552,
167765,
126983,
98382,
143682,
193837,
155598,
117646,
241333,
240120,
135403,
418173,
140362,
155492,
29649833,
165025,
145685,
156310,
155228,
183196,
220877,
226215,
141880,
136036,
35241603,
74297,
223652,
188963,
106094,
3379718,
266243,
84203,
189271,
141472,
259918,
259359,
4061962,
229645,
153833,
145447,
261224,
166076,
80793,
93903,
190819,
151300,
126485,
15668814,
99420,
191455,
207430,
73135,
102558,
186109,
227572,
163958,
164573,
1173161,
16306657,
198534,
242014,
186921,
186236,
41752708,
262446,
94738,
74091,
8388408,
263799,
23106643,
156053,
147531,
171116,
157401,
6797421,
267530,
179118,
103592,
21308116,
185065,
73764,
133247,
146150,
174544,
187735,
113462,
227046,
142948,
117802,
87409,
98021,
192660,
136066,
82419,
240534,
189988,
77069,
89456,
256958,
227134,
131774,
199099,
182482,
180717,
205724,
261823,
209351,
160345,
105154,
173923,
231694,
89745,
13723644,
3379737,
208831,
88849,
218293,
267623,
175232,
96781,
194023,
214433,
268304,
31665450,
240386,
119873,
132556,
383139,
383006,
134210,
212320,
185598,
77540,
145830,
132606,
196032,
245926,
156762,
194884,
157428,
2566227,
4442214,
260788,
106347,
75482,
101590,
101260,
178677,
244711,
211866,
83126,
149216,
166529,
126658,
102868,
1173542,
129031,
39355239,
150639,
251478,
159064,
108780,
212020,
82604,
263334,
26244429,
48897791,
147399,
87899,
92309,
13979961,
88890,
266814,
98451,
87012,
2470567,
150070,
161142,
84906,
267678,
8566620,
90455,
134714,
7941416,
158481,
51503593,
187408,
128777,
101873,
269773,
103348,
223733,
145003,
193518,
22452518,
222458,
97550,
107057,
119718,
101969,
156724,
175902,
178962,
165965,
240646,
183531,
225267,
91812,
5315087,
221512,
47158244,
192391,
139070,
252035,
94404,
164234,
7016779,
265584,
189166,
228125,
101403,
75106,
136496,
218042,
128612,
161406,
227270,
195022,
181329,
223466,
146486,
213132,
188297,
249659,
43349109,
218521,
171431,
176897,
164128,
195558,
9872791,
209589,
7780777,
218076,
243999,
128888,
107555,
196249,
102976,
203485,
203394,
76116,
195136,
14623690,
198380,
192497,
261005,
383027,
108195,
105395,
160203,
23184951,
85808,
250318,
128526,
172278,
223510,
176992,
267023,
194471,
181045,
138437,
203729,
228246,
219157,
180387,
228944,
154180,
189670,
264897,
169035,
166413,
46461361,
191815,
132768,
247180,
134133,
145258,
212576,
127120,
72285,
209859,
212729,
38723937,
84542,
81094,
178215,
124237,
189598,
149007,
4442187,
139875,
102697,
33664677,
208674,
74880,
266112,
185888,
198187,
142573,
15659243,
194307,
38008495,
195918,
111604,
75898,
185864,
73900,
80548,
197565,
180504,
228789,
87856,
147869,
179886,
73395,
108520,
108052,
116102,
135012,
213047,
103833,
41634802,
266442,
190634,
35522295,
260555,
267186,
119097,
1173693,
241860,
240436,
200867,
115545,
105712,
168651,
135252,
8695139,
149155,
38621717,
200595,
151676,
204204,
99114,
203147,
151225,
384102,
154758,
146259,
135685,
121033,
228197,
229095,
210638,
194960,
1173603,
146703,
202441,
174181,
169959,
88291,
91914,
154051,
176975,
142318,
87219,
224446,
144833,
210718,
91843,
96354,
139042,
150701,
18332685,
147969,
135730,
149400,
209194,
205753,
104513,
146983,
74030,
107333,
182314,
176068,
135345,
102814,
242919,
194713,
30765443,
143537,
241967,
269473,
29311567,
186138,
171224,
128254,
105477,
188477,
72611,
106657,
99228,
210768,
142528,
5315084,
202202,
8618578,
243839,
244956,
189617,
195386,
198307,
87124,
130741,
10655859,
107023,
227765,
171586,
113392,
77134,
78974,
212394,
196083,
261973,
143596,
81720,
162257,
127993,
226499,
98121,
41214843,
167986,
190920,
188894,
81316,
12371222,
72528,
247088,
211759,
120394,
127946,
195347,
269401,
191210,
241089,
31419712,
144860,
182441,
88688,
81217,
85536,
110467,
129206,
46237639,
204745,
177333,
175610,
250174,
192804,
95872,
241209,
139584,
83605,
147915,
156464,
203131,
104153,
221094,
202800,
188242,
80083,
206894,
3176489,
144062,
107364,
177852,
269023,
142897,
1173653,
162969,
207942,
122838,
176637,
107594,
94870,
27808352,
158648,
186259,
179813,
4580718,
197310,
91479,
130049,
205199,
22892606,
121463,
45539296,
110338,
203882,
134322,
22840856,
88601,
132156,
250060,
100829,
178500,
253709,
249733,
120883,
170382,
185698,
268279,
202332,
206198,
203636,
244217,
78111,
92398,
179680,
262376,
177510,
226339,
220914,
263626,
220546,
148899,
250658,
162361,
27807955,
87970,
151587,
211256,
128141,
6771981,
124113,
98483,
95383,
174987,
140325,
138609,
150724,
97116,
248735,
13400949,
150874,
31077769,
94373,
115604,
240156,
90081,
13377190,
176111,
382743,
120627,
268917,
159639,
179171,
72244,
198814,
246306,
8870626,
37868209,
34037741,
174035,
261585,
129501,
109234,
110842,
131839,
110435,
157283,
32979456,
96266,
113160,
139146,
151636,
80940,
222748,
227403,
227647,
124337,
266360,
116231,
251064,
146288,
163837,
142256,
81527,
73343,
149455,
73556,
211686,
262061,
225967,
197746,
109827,
7599407,
14669428,
166611,
101798,
31215812,
1904411,
197835,
164711,
208378,
130324,
384041,
167903,
255495,
86879,
179242,
201789,
220238,
223333,
119029,
254825,
131179,
144248,
86366,
125661,
38300874,
150752,
257470,
131085,
115484,
169525,
143260,
384050,
81639,
23220930,
35700277,
4061851,
124869,
186869,
147609,
266549,
17877742,
239438,
139730,
146183,
166027,
163692,
171164,
166311,
49539249,
243243,
100207,
205363,
185045,
170902,
114505,
77357,
91299,
79763,
119809,
27486615,
187530,
181736,
220755,
223395,
243765,
218423,
134094,
11367104,
114041,
252403,
227558,
254246,
227604,
193372,
89565,
169666,
198592,
382988,
9290146,
166123,
130955,
122580,
176200,
198498,
101167,
156225,
123820,
192120,
131135,
245508,
8722785,
43581664,
222266,
4149175,
4442184,
383118,
164198,
160274,
109732,
190401,
129096,
118447,
195113,
251659,
189874,
133017,
225195,
133887,
193149,
213537,
205800,
80315,
144374,
176007,
249148,
263475,
78233,
195752,
383497,
34636746,
96544,
144556,
218375,
78778,
1173251,
224525,
138736,
159538,
221173,
158547,
256037,
208746,
101745,
46904829,
146572,
1845849,
98309,
257550,
110779,
244970,
266061,
15243082,
26684056,
152590,
174941,
174798,
95803,
113819,
130026,
4442181,
180460,
193204,
252832,
170491,
49539259,
204651,
213869,
186209,
139639,
260613,
79343,
219686,
160845,
107672,
115132,
139252,
144517,
208902,
187460,
204776,
202099,
253165,
190061,
203901,
262167,
143448,
162656,
94129,
149098,
176244,
225007,
181884,
221593,
250387,
190546,
173880,
220693,
103317,
122139,
37366700,
105761,
141562,
39995931,
252859,
124829,
91521,
219012,
147152,
138273,
265930,
225114,
95945,
90363,
247473,
154116,
156882,
115753,
158905,
102372,
150008,
117438,
5160343,
192284,
171353,
135953,
263240,
160247,
265965,
76091,
122810,
9395965,
206591,
160614,
89972,
268951,
145494,
150197,
32742951,
220483,
1173254,
243956,
223285,
103526,
189797,
245836,
84306,
254732,
97583,
205897,
196171,
76562,
142376,
132963,
265305,
257732,
4061766,
74757,
73689,
199364,
97423,
212470,
125952,
170268,
264448,
187757,
214160,
204973,
100524,
260508,
187073,
141808,
90830,
195314,
223044,
136417,
149642,
157541,
185208,
219804,
114455,
156617,
140833,
50388225,
26970115,
149059,
213283,
205493,
129533,
75190,
6775934,
187911,
77600,
7541413,
221442,
162327,
111233,
90672,
208932,
115353,
155356,
207463,
2655510,
263995,
175792,
245352,
122780,
177157,
176296,
157359,
201732,
193952,
114320,
200435,
246876,
244648,
136526,
165005,
122527,
212066,
9517247,
96500,
98441,
202896,
251348,
157224,
220200,
170765,
11213840,
180007,
7967625,
129250,
77223,
170037,
46236871,
268827,
98180,
248414,
186176,
218867,
146397,
383256,
245240,
250829,
204855,
190150,
7678621,
6614248,
7217358,
173474,
249871,
37868894,
267580,
38670305,
21237158,
178337,
211155,
164042,
130267,
111071,
151568,
157149,
4791485,
117877,
9700325,
259743,
268384,
202554,
5957905,
103499,
105369,
204342,
191428,
214424,
181278,
1173158,
220531,
43751656,
261338,
251539,
108003,
5957896,
1173121,
247897,
188163,
163235,
38622028,
9700322,
384128,
22882595,
9700388,
5957902,
143202,
9700382,
6771978,
17058949
)
AND dacco.o_published = 1
AND (
dacco.town__id IN (
11195, 11196, 11191, 11194, 11190, 3192509,
11197, 11409
)
)
GROUP BY
dacco.oo_id
ORDER BY
RAND(662)
SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (191516,261287,180106,267915,103365,229144,86586,201425,256266,177439,191937,173849,188200,148211,162295,181966,228288,90325,154821,227190,97625,101229,76033,253939,164670,98143,163153,171766,150268,1173353,158731,255823,130455,1173742,260387,383021,104781,209213,121638,132704,162100,160120,138703,249413,14557855,81753,262837,106040,156918,113751,161033,220403,34219679,203617,173602,114734,21161019,175319,90285,97332,120314,246836,128649,106445,228081,142725,208002,250696,265826,242815,268424,213326,136200,247967,257803,177240,131790,99678,147332,197648,260291,178599,206964,22892603,202479,257010,124000,78857,4061616,229314,241670,157521,176727,73645,256553,192306,383292,18355899,138331,256818,235840,144028,131018,259830,208109,157109,39225141,90162,241752,207763,221382,113085,125739,75414,180136,214015,41680612,51216654,156680,168086,241513,151492,171549,154608,268018,49169351,192842,191155,238918,151257,234239,141729,164627,262206,259974,27128134,229040,194565,9290160,94222,26648317,220348,171978,91679,81984,174338,197250,124606,78602,213843,244042,265255,154873,108105,199975,113626,243209,252258,33267404,3118747,5160340,192033,124694,203308,136181,383360,194797,209054,7715980,27808188,20059276,102266,113408,209292,255957,148562,233730,260733,26898515,172618,83792,140245,157466,384186,219765,222898,176457,23455826,145409,31514436,211808,168744,128321,199742,3379819,148779,207109,141272,33072197,143736,109291,245784,160801,261487,47294199,259576,27224568,3411816,76427,38050667,201802,7599929,87467,221211,217376,44404593,209445,115416,121323,256865,193068,93789,74347,117916,155681,261884,267501,263716,265468,178433,262579,224332,213925,83429,134439,108664,44224029,10261747,89073,8722782,162146,203577,109501,175147,174583,41796413,47202201,254301,31719532,402843,141656,90791,80345,136555,86746,217510,36278962,108881,105748,226049,185795,111370,241827,266661,89261,172217,174737,106287,206854,135205,265066,23945599,222491,173273,98639,88121,225305,48897409,189123,267700,1173892,95043,218149,207780,242786,111091,171085,112984,209483,135519,224773,186795,77403,4791491,383578,110677,126702,208283,148079,161664,20708505,146129,4061812,170518,202690,30148041,75680,143950,23106697,13818591,104583,111341,87518,84605,34719290,193693,265878,119054,84693,218235,239049,212689,9887645,170725,139824,211891,185961,156556,115223,164309,171662,17594470,162820,100623,80509,186088,227892,261943,192003,242964,251865,21211748,189226,260943,129897,91149,111521,79610,77676,187810,168470,20627345,44869050,220655,95652,240404,382826,87340,255905,191047,154226,261090,101549,204528,194917,227481,245659,117486,79926,12253627,91383,87314,219299,102508,121533,223613,124718,145614,255407,176678,209921,75853,192523,139196,147221,212715,128992,223355,134831,170790,154459,97982,191407,200906,178544,169612,138939,96924,108989,15050850,97682,156120,2853495,190210,75643,76900,87071,201863,8591193,245886,3224898,228314,222990,209807,89549,3029831,168606,143351,222689,229470,204161,111003,106770,185439,205629,118332,225374,125266,107859,240971,159735,9700358,191266,187180,74473,27808178,118621,22568743,199850,115902,193028,79494,140059,143038,7599993,27199439,100682,84439,31789631,254574,75009,228572,3224895,8388337,89886,212164,41024653,79030,77798,86434,255713,5315068,229397,99548,212929,85349,168114,4061468,190504,21273299,263121,213063,242085,262617,148602,114251,114017,139671,228856,114786,33072200,4791488,122718,27808362,111742,37667633,268989,106889,242703,92184,91180,72773,79701,205836,183075,114609,268647,173082,165937,109374,183391,210522,267851,20512295,200772,23185284,28138429,179735,1173491,226977,150349,269658,170874,85437,210612,143785,18810400,245060,88772,125397,190383,210702,195537,187883,161875,103051,174680,199831,42358761,20972969,165805,7186183,183290,118392,204827,210751,179767,160168,195225,116132,172344,122307,218829,200126,118221,383375,74427,182129,1173124,83176,9129444,125055,265768,132281,250245,242072,199572,182335,9517217,79212,246469,149700,74534,201319,82308,178072,260687,223960,114925,155523,245591,269445,182728,10039806,260577,263186,224600,42105593,75600,197379,220170,264308,180306,91582,170704,198994,91777,128052,142776,9282725,148975,120959,177255,120483,75959,383494,115150,81346,74121,268711,199275,85117,36566491,155984,130799,147033,199934,135829,27076239,2367452,145352,79424,226395,151031,101813,265378,207573,162948,206641,154301,220948,197713,144112,141037,168884,147191,200283,110374,122101,39558144,268162,100061,174091,383672,82521,383826,4061779,213358,173543,89349,221136,89709,383286,208516,2977929,210887,266691,227732,162891,37038521,168676,108551,210439,267314,218032,98352,223447,193721,96112,199295,129814,18810410,256504,135125,175690,82805,190874,246756,39599857,172317,181569,178916,96619,18323640,4061656,181441,139974,110254,17275737,164436,172512,177391,179201,148376,141995,171964,199538,96059,266341,199700,111651,219501,202588,261158,80881,84734,157061,169799,163032,242260,219645,266888,87380,73318,244552,167765,126983,98382,143682,193837,155598,117646,241333,240120,135403,418173,140362,155492,29649833,165025,145685,156310,155228,183196,220877,226215,141880,136036,35241603,74297,223652,188963,106094,3379718,266243,84203,189271,141472,259918,259359,4061962,229645,153833,145447,261224,166076,80793,93903,190819,151300,126485,15668814,99420,191455,207430,73135,102558,186109,227572,163958,164573,1173161,16306657,198534,242014,186921,186236,41752708,262446,94738,74091,8388408,263799,23106643,156053,147531,171116,157401,6797421,267530,179118,103592,21308116,185065,73764,133247,146150,174544,187735,113462,227046,142948,117802,87409,98021,192660,136066,82419,240534,189988,77069,89456,256958,227134,131774,199099,182482,180717,205724,261823,209351,160345,105154,173923,231694,89745,13723644,3379737,208831,88849,218293,267623,175232,96781,194023,214433,268304,31665450,240386,119873,132556,383139,383006,134210,212320,185598,77540,145830,132606,196032,245926,156762,194884,157428,2566227,4442214,260788,106347,75482,101590,101260,178677,244711,211866,83126,149216,166529,126658,102868,1173542,129031,39355239,150639,251478,159064,108780,212020,82604,263334,26244429,48897791,147399,87899,92309,13979961,88890,266814,98451,87012,2470567,150070,161142,84906,267678,8566620,90455,134714,7941416,158481,51503593,187408,128777,101873,269773,103348,223733,145003,193518,22452518,222458,97550,107057,119718,101969,156724,175902,178962,165965,240646,183531,225267,91812,5315087,221512,47158244,192391,139070,252035,94404,164234,7016779,265584,189166,228125,101403,75106,136496,218042,128612,161406,227270,195022,181329,223466,146486,213132,188297,249659,43349109,218521,171431,176897,164128,195558,9872791,209589,7780777,218076,243999,128888,107555,196249,102976,203485,203394,76116,195136,14623690,198380,192497,261005,383027,108195,105395,160203,23184951,85808,250318,128526,172278,223510,176992,267023,194471,181045,138437,203729,228246,219157,180387,228944,154180,189670,264897,169035,166413,46461361,191815,132768,247180,134133,145258,212576,127120,72285,209859,212729,38723937,84542,81094,178215,124237,189598,149007,4442187,139875,102697,33664677,208674,74880,266112,185888,198187,142573,15659243,194307,38008495,195918,111604,75898,185864,73900,80548,197565,180504,228789,87856,147869,179886,73395,108520,108052,116102,135012,213047,103833,41634802,266442,190634,35522295,260555,267186,119097,1173693,241860,240436,200867,115545,105712,168651,135252,8695139,149155,38621717,200595,151676,204204,99114,203147,151225,384102,154758,146259,135685,121033,228197,229095,210638,194960,1173603,146703,202441,174181,169959,88291,91914,154051,176975,142318,87219,224446,144833,210718,91843,96354,139042,150701,18332685,147969,135730,149400,209194,205753,104513,146983,74030,107333,182314,176068,135345,102814,242919,194713,30765443,143537,241967,269473,29311567,186138,171224,128254,105477,188477,72611,106657,99228,210768,142528,5315084,202202,8618578,243839,244956,189617,195386,198307,87124,130741,10655859,107023,227765,171586,113392,77134,78974,212394,196083,261973,143596,81720,162257,127993,226499,98121,41214843,167986,190920,188894,81316,12371222,72528,247088,211759,120394,127946,195347,269401,191210,241089,31419712,144860,182441,88688,81217,85536,110467,129206,46237639,204745,177333,175610,250174,192804,95872,241209,139584,83605,147915,156464,203131,104153,221094,202800,188242,80083,206894,3176489,144062,107364,177852,269023,142897,1173653,162969,207942,122838,176637,107594,94870,27808352,158648,186259,179813,4580718,197310,91479,130049,205199,22892606,121463,45539296,110338,203882,134322,22840856,88601,132156,250060,100829,178500,253709,249733,120883,170382,185698,268279,202332,206198,203636,244217,78111,92398,179680,262376,177510,226339,220914,263626,220546,148899,250658,162361,27807955,87970,151587,211256,128141,6771981,124113,98483,95383,174987,140325,138609,150724,97116,248735,13400949,150874,31077769,94373,115604,240156,90081,13377190,176111,382743,120627,268917,159639,179171,72244,198814,246306,8870626,37868209,34037741,174035,261585,129501,109234,110842,131839,110435,157283,32979456,96266,113160,139146,151636,80940,222748,227403,227647,124337,266360,116231,251064,146288,163837,142256,81527,73343,149455,73556,211686,262061,225967,197746,109827,7599407,14669428,166611,101798,31215812,1904411,197835,164711,208378,130324,384041,167903,255495,86879,179242,201789,220238,223333,119029,254825,131179,144248,86366,125661,38300874,150752,257470,131085,115484,169525,143260,384050,81639,23220930,35700277,4061851,124869,186869,147609,266549,17877742,239438,139730,146183,166027,163692,171164,166311,49539249,243243,100207,205363,185045,170902,114505,77357,91299,79763,119809,27486615,187530,181736,220755,223395,243765,218423,134094,11367104,114041,252403,227558,254246,227604,193372,89565,169666,198592,382988,9290146,166123,130955,122580,176200,198498,101167,156225,123820,192120,131135,245508,8722785,43581664,222266,4149175,4442184,383118,164198,160274,109732,190401,129096,118447,195113,251659,189874,133017,225195,133887,193149,213537,205800,80315,144374,176007,249148,263475,78233,195752,383497,34636746,96544,144556,218375,78778,1173251,224525,138736,159538,221173,158547,256037,208746,101745,46904829,146572,1845849,98309,257550,110779,244970,266061,15243082,26684056,152590,174941,174798,95803,113819,130026,4442181,180460,193204,252832,170491,49539259,204651,213869,186209,139639,260613,79343,219686,160845,107672,115132,139252,144517,208902,187460,204776,202099,253165,190061,203901,262167,143448,162656,94129,149098,176244,225007,181884,221593,250387,190546,173880,220693,103317,122139,37366700,105761,141562,39995931,252859,124829,91521,219012,147152,138273,265930,225114,95945,90363,247473,154116,156882,115753,158905,102372,150008,117438,5160343,192284,171353,135953,263240,160247,265965,76091,122810,9395965,206591,160614,89972,268951,145494,150197,32742951,220483,1173254,243956,223285,103526,189797,245836,84306,254732,97583,205897,196171,76562,142376,132963,265305,257732,4061766,74757,73689,199364,97423,212470,125952,170268,264448,187757,214160,204973,100524,260508,187073,141808,90830,195314,223044,136417,149642,157541,185208,219804,114455,156617,140833,50388225,26970115,149059,213283,205493,129533,75190,6775934,187911,77600,7541413,221442,162327,111233,90672,208932,115353,155356,207463,2655510,263995,175792,245352,122780,177157,176296,157359,201732,193952,114320,200435,246876,244648,136526,165005,122527,212066,9517247,96500,98441,202896,251348,157224,220200,170765,11213840,180007,7967625,129250,77223,170037,46236871,268827,98180,248414,186176,218867,146397,383256,245240,250829,204855,190150,7678621,6614248,7217358,173474,249871,37868894,267580,38670305,21237158,178337,211155,164042,130267,111071,151568,157149,4791485,117877,9700325,259743,268384,202554,5957905,103499,105369,204342,191428,214424,181278,1173158,220531,43751656,261338,251539,108003,5957896,1173121,247897,188163,163235,38622028,9700322,384128,22882595,9700388,5957902,143202,9700382,6771978,17058949) AND dacco.o_published = 1 AND (dacco.town__id IN (11195, 11196, 11191, 11194, 11190, 3192509, 11197, 11409)) GROUP BY dacco.oo_id ORDER BY RAND(662) ;
|
26.85 ms (5.90%)
|
1 |
SELECT dest_id, count(src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (6812, 6815, 6830, 6813, 6825, 6809, 6831, 6806, 6839, 12662, 6814, 6807, 6838, 6824, 6826, 6817, 6816, 6819, 6832, 6820, 6822)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
group by dest_id
SELECT dest_id, count(src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (6812, 6815, 6830, 6813, 6825, 6809, 6831, 6806, 6839, 12662, 6814, 6807, 6838, 6824, 6826, 6817, 6816, 6819, 6832, 6820, 6822)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
group by dest_id ;
|
11.40 ms (2.51%)
|
1 |
SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.o_published = 1 AND (dacco.town__id IN (11195, 11196, 11191, 11194, 11190, 3192509, 11197, 11409)) GROUP BY dacco.oo_id ORDER BY RAND(662)
SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.o_published = 1 AND (dacco.town__id IN (11195, 11196, 11191, 11194, 11190, 3192509, 11197, 11409)) GROUP BY dacco.oo_id ORDER BY RAND(662) ;
|
7.82 ms (1.72%)
|
1 |
SELECT dest_id, count(src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (11190, 11409, 11191, 11196, 11194, 11197, 11195)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
group by dest_id
SELECT dest_id, count(src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (11190, 11409, 11191, 11196, 11194, 11197, 11195)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
group by dest_id ;
|
1.82 ms (0.40%)
|
1 |
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (9944)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (9944)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
;
|
1.60 ms (0.35%)
|
14 |
create TEMPORARY table `steiermark`.accoIdsTowns(
id int(11) NOT NULL,
PRIMARY KEY (`id`)
)
engine=memory;
insert into `steiermark`.accoIdsTowns (id) values (119718),(166027),(160345),(189874),(8722782),(110338),(90162),(46461361),(86879),(187735),(156724),(151300),(263334),(79212),(256504),(214433),(4580718),(91679),(130799),(107364),(128321),(121323),(383021),(7599407),(141995),(141272),(178916),(84203),(75600),(49539259),(89349),(130324),(229470),(79343),(384050),(159538),(254301),(204204),(194917),(74473),(199295),(210887),(263121),(32979456),(204973),(260291),(27486615),(217510),(168884),(87518),(110374),(218032),(171586),(383256),(33664677),(190819),(212689),(75190),(186921),(171978),(145409),(95652),(37868209),(190210),(226049),(27808352),(200772),(241860),(266360),(166123),(128141),(205800),(107333),(5315068),(110842),(125661),(73764),(107859),(201802),(125055),(203394),(143260),(82419),(41634802),(208932),(209859),(254825),(223613),(173602),(225007),(203882),(226339),(82521),(267530),(191937),(201789),(183531),(46904829),(156617),(4061468),(220238),(178500),(125397),(185439),(131085),(240436),(200283),(157149),(220348),(220914),(267186),(167986),(75680),(134831),(171766),(105154),(194713),(103499),(6771978),(220948),(266888),(177510),(9282725),(106094),(36566491),(133017),(9700388),(192391),(145003),(253709),(128052),(100829),(114609),(148376),(114505),(169525),(200435),(121463),(161406),(189797),(209054),(176296),(227765),(141472),(243209),(178599),(73135),(107555),(176678),(34219679),(135345),(97116),(193372),(147033),(252859),(173273),(228246),(111341),(98483),(73556),(186176),(253165),(219012),(178962),(209921),(149007),(255713),(146572),(195022),(200595),(265965),(212066),(26970115),(265468),(13818591),(99114),(167903),(149700),(250060),(186869),(201732),(145447),(157521),(268989),(383672),(174798),(198307),(21211748),(127946),(171116),(245352),(7186183),(7967625),(142318),(98382),(97682),(194471),(94129),(201319),(266442),(72773),(98180),(18810400),(218149),(268917),(210439),(171164),(9700322),(150752),(244648),(149098),(121638),(178337),(247180),(135953),(156680),(41214843),(269473),(261338),(151225),(115223),(261090),(223333),(252035),(136181),(154821),(189226),(205897),(79424),(243243),(160274),(134094),(198592),(98021),(79763),(204745),(242919),(229314),(7599993),(48897409),(43751656),(4061766),(234239),(32742951),(129814),(102697),(242786),(198534),(186109),(204342),(38622028),(166611),(77223),(95803),(183075),(124606),(250696),(85349),(241752),(29311567),(6614248),(267700),(136555),(104153),(157428),(20708505),(263626),(8722785),(141729),(259918),(163958),(108881),(213047),(254574),(227604),(122780),(247088),(166076),(259576),(154608),(147915),(384128),(13979961),(195113),(219686),(113408),(105477),(119097),(211256),(208283),(141880),(30148041),(384102),(8388337),(192804),(83126),(81753),(91521),(110779),(77403),(191407),(200867),(9517217),(193721),(205493),(160168),(190546),(165025),(84542),(157224),(255823),(88772),(207463),(187757),(47202201),(161664),(168086),(383292),(250829),(189166),(130955),(187810),(18355899),(188477),(249733),(147969),(265305),(156310),(122718),(224446),(260788),(206641),(185961),(172512),(266243),(157541),(190874),(217376),(265826),(106347),(94870),(100207),(175902),(124113),(73343),(6775934),(266814),(266549),(89549),(213843),(146129),(246836),(156918),(159064),(73318),(213283),(251539),(212394),(255957),(202332),(1173251),(214015),(384041),(223733),(268711),(239438),(93789),(194307),(223466),(142897),(120627),(192003),(228081),(97423),(154873),(180136),(243839),(262579),(204528),(85536),(75853),(204827),(197835),(6797421),(121033),(130455),(5315087),(114017),(9129444),(135730),(87071),(31419712),(100682),(183196),(85117),(3379819),(222458),(169035),(136066),(117646),(242085),(176457),(1173892),(187073),(199742),(101813),(187460),(134714),(158731),(162100),(113085),(134133),(268951),(179171),(262167),(197310),(195347),(146259),(259974),(202099),(244552),(269658),(211759),(22840856),(198187),(110677),(111370),(245926),(228789),(129897),(156464),(212715),(265066),(78111),(2977929),(196171),(22452518),(102868),(97625),(122527),(79610),(162327),(138437),(100623),(139070),(120314),(37667633),(1173491),(263240),(246876),(44404593),(256553),(170037),(101798),(164670),(91479),(203901),(206591),(9290160),(91843),(268384),(21161019),(113751),(39225141),(208378),(138273),(134322),(38050667),(209194),(144028),(87380),(176244),(51503593),(77600),(187530),(104513),(27807955),(257470),(119809),(74534),(265878),(34719290),(33072200),(205199),(9887645),(248414),(124829),(91383),(96500),(202690),(37868894),(78233),(241827),(151587),(192033),(244042),(103365),(128649),(73395),(383006),(239049),(80315),(261224),(199700),(207780),(185598),(229095),(251659),(149059),(189670),(213537),(263995),(98441),(182482),(204651),(206894),(197379),(144556),(220877),(131018),(210638),(245060),(140833),(212729),(240156),(191155),(128992),(7941416),(1173603),(164128),(108780),(96112),(44224029),(227572),(181045),(214424),(129533),(266341),(117438),(212320),(91149),(75898),(247473),(202441),(180717),(266691),(43349109),(186088),(229645),(117486),(142528),(219157),(260943),(1845849),(227190),(268304),(4442181),(4061616),(243956),(147221),(9290146),(9700358),(222748),(162361),(176992),(240386),(84306),(175319),(246306),(260577),(101229),(166413),(206964),(142948),(124869),(46237639),(170725),(2367452),(382743),(34636746),(383139),(257732),(35700277),(181736),(250174),(191428),(1173353),(102976),(130741),(252403),(173923),(113626),(145685),(23184951),(252258),(96924),(23185284),(223285),(178072),(191047),(133247),(382826),(260387),(98309),(211891),(131790),(228288),(144374),(250318),(235840),(7217358),(226395),(111003),(182129),(203729),(41024653),(114320),(115132),(165805),(97332),(188242),(198994),(261884),(162146),(169666),(260555),(39599857),(135012),(199275),(162257),(76116),(210702),(91180),(143682),(83176),(180387),(135519),(227481),(117877),(225195),(7599929),(191455),(244970),(202479),(266061),(250387),(182314),(93903),(164627),(226499),(229040),(101745),(105712),(204776),(169959),(43581664),(176637),(246756),(173474),(126983),(225305),(228197),(164198),(186138),(109291),(182441),(228125),(172618),(128526),(209807),(402843),(50388225),(179242),(31789631),(41752708),(124000),(269773),(8870626),(9700325),(4061962),(175232),(189988),(219765),(219804),(181884),(267623),(111742),(112984),(149642),(177391),(153833),(174544),(227134),(246469),(165937),(189271),(223510),(26898515),(123820),(267023),(170518),(244956),(38723937),(139730),(213326),(138331),(147191),(240120),(15659243),(181569),(87970),(189617),(4149175),(41680612),(86586),(13400949),(163032),(200906),(245784),(143785),(101403),(145352),(242964),(262376),(170382),(3224895),(113819),(97550),(242703),(27076239),(251348),(96059),(210751),(207573),(199934),(134210),(143596),(221094),(173082),(77798),(204855),(90325),(110467),(92309),(36278962),(143448),(156225),(176727),(98451),(79701),(115484),(38300874),(220693),(88601),(383494),(183290),(146183),(202588),(268424),(383360),(143537),(101873),(142776),(154459),(195314),(76427),(107057),(88849),(190634),(229144),(224332),(75482),(162969),(181441),(179201),(193204),(223044),(108195),(250658),(166529),(244711),(105369),(91299),(20059276),(181966),(160614),(11367104),(155356),(151031),(132281),(136036),(100061),(102372),(109732),(89456),(109501),(7541413),(132606),(188200),(199850),(195225),(102558),(150639),(104583),(3176489),(179735),(251865),(51216654),(148779),(221512),(86434),(22892603),(203636),(267678),(160120),(262206),(119029),(144062),(125266),(85808),(132556),(3379737),(87856),(49539249),(203147),(168676),(31719532),(15668814),(132156),(180460),(194565),(264448),(162656),(8695139),(238918),(72611),(129096),(242014),(222898),(136496),(77134),(241967),(193149),(129250),(268279),(220655),(191266),(256037),(138736),(140059),(96354),(156762),(262837),(179767),(187180),(7780777),(72244),(144112),(181329),(174091),(144517),(141562),(147609),(105748),(150268),(74347),(256865),(240534),(31077769),(87219),(78857),(245591),(157061),(97982),(134439),(213869),(201863),(4791485),(220170),(163837),(89709),(189123),(144833),(257010),(223395),(177157),(22882595),(265768),(151492),(124694),(214160),(151257),(222266),(261487),(221382),(139252),(224600),(98352),(256818),(118447),(89972),(174338),(220531),(27199439),(122810),(4061779),(17058949),(1173542),(75643),(267501),(218375),(89073),(129206),(42358761),(265584),(221442),(72528),(211808),(89261),(20627345),(263716),(197713),(94738),(77069),(111651),(244217),(77540),(83605),(33267404),(225114),(188894),(163235),(225267),(148602),(149455),(27808188),(164436),(150008),(382988),(88890),(158648),(193068),(98143),(99548),(171224),(2853495),(223447),(177852),(213132),(218293),(88688),(200126),(146983),(48897791),(96266),(181278),(210768),(188963),(179118),(110254),(195558),(132963),(154758),(76091),(128254),(150724),(76900),(106287),(128888),(108664),(139875),(4442187),(209213),(249659),(100524),(261005),(91812),(17877742),(221173),(98639),(141656),(227732),(2655510),(208109),(227403),(156120),(259359),(81217),(21308116),(4442184),(128612),(208831),(190504),(74880),(179813),(8618578),(231694),(22892606),(74121),(150070),(254246),(193837),(84734),(247897),(101969),(27808178),(261585),(79494),(20972969),(18332685),(178544),(261287),(135685),(149400),(151568),(192306),(247967),(117802),(145614),(87012),(260687),(105761),(27808362),(213925),(218867),(168651),(253939),(101167),(4442214),(198380),(20512295),(90830),(218042),(21237158),(209589),(4061812),(1173742),(2566227),(148211),(242815),(163692),(203485),(13723644),(130049),(241513),(242072),(261823),(256266),(88121),(222491),(80509),(84439),(205753),(175147),(5957905),(131135),(128777),(190150),(23220930),(383118),(168470),(260613),(220546),(206198),(264897),(171662),(80345),(167765),(75009),(150197),(155523),(164042),(154180),(120483),(142573),(27224568),(189598),(91777),(152590),(155984),(172344),(89886),(154226),(186259),(45539296),(194960),(146486),(186209),(383375),(72285),(207430),(135403),(268018),(5160340),(115150),(103592),(183391),(75414),(177333),(174680),(146703),(3118747),(140245),(262617),(264308),(114455),(182335),(212164),(269445),(151676),(147869),(41796413),(74427),(162295),(172217),(31665450),(8388408),(228572),(83429),(6771981),(227270),(220200),(85437),(148899),(96544),(202896),(101590),(74297),(15050850),(90791),(147399),(267915),(185795),(3411816),(174181),(267851),(265930),(212576),(145494),(140325),(142256),(94373),(2470567),(176897),(192497),(125739),(204161),(74757),(266661),(23945599),(107594),(3379718),(23106697),(138703),(114734),(139042),(218076),(205363),(210612),(197648),(18810410),(138939),(80083),(207109),(202554),(219645),(103348),(87899),(177240),(212470),(180106),(174035),(176975),(240404),(169612),(171431),(383497),(193518),(92398),(180007),(199831),(119873),(192842),(257803),(259830),(186795),(245886),(1173121),(195918),(146150),(186236),(95945),(80940),(47158244),(233730),(179680),(228856),(241670),(199572),(162948),(124237),(174583),(127993),(81094),(26244429),(142725),(103833),(190061),(190383),(174737),(227046),(195752),(28138429),(139639),(172317),(1173693),(102508),(157401),(206854),(102266),(9517247),(173543),(211866),(205724),(39995931),(196249),(108105),(168606),(80548),(115353),(101549),(108003),(130026),(209483),(266112),(143038),(111233),(49169351),(159735),(151636),(209445),(192660),(109827),(113160),(255905),(155492),(194884),(133887),(127120),(108052),(208674),(248735),(161033),(203308),(199099),(77357),(113462),(202800),(81720),(218423),(78974),(82308),(124337),(175690),(165005),(171549),(120959),(91914),(108989),(115753),(124718),(47294199),(209292),(109234),(16306657),(106889),(21273299),(180306),(23455826),(110435),(170268),(170704),(170765),(7715980),(17594470),(185698),(26648317),(82604),(125952),(263799),(78778),(87340),(96619),(249148),(208516),(256958),(191516),(160203),(198814),(1173254),(267580),(146397),(99420),(166311),(228314),(95043),(383578),(240971),(224773),(39558144),(268827),(83792),(143950),(114251),(177255),(136200),(120394),(130267),(269023),(122838),(255407),(192120),(227892),(251064),(122307),(4061656),(109374),(99678),(201425),(182728),(177439),(154051),(185045),(203131),(195136),(171085),(171353),(260508),(169799),(155681),(11213840),(107672),(14623690),(171964),(115545),(222689),(15243082),(242260),(164711),(207763),(131774),(132768),(107023),(241089),(77676),(1904411),(225374),(195537),(157109),(223355),(211155),(91582),(131179),(205629),(164309),(155598),(150349),(97583),(26684056),(147332),(175792),(7678621),(173880),(174941),(139196),(149216),(250245),(245508),(185208),(120883),(4791488),(116132),(219501),(18323640),(35241603),(80881),(5957902),(95383),(87467),(197565),(145830),(226215),(218235),(14557855),(265255),(106445),(44869050),(136526),(39355239),(96781),(261973),(144860),(174987),(99228),(193028),(199364),(193693),(211686),(1173653),(14669428),(207942),(7016779),(27128134),(241333),(105395),(224525),(103526),(261158),(106770),(12253627),(23106643),(383027),(115416),(265378),(121533),(165965),(118332),(176111),(220483),(1173158),(12371222),(103317),(37366700),(158547),(17275737),(37038521),(111091),(90672),(158481),(8591193),(111521),(188297),(81527),(84906),(22568743),(139584),(115902),(94404),(176068),(179886),(208002),(187883),(74091),(157283),(243765),(220403),(9872791),(257550),(245240),(384186),(103051),(106657),(203617),(252832),(175610),(213063),(383286),(98121),(213358),(255495),(135252),(117916),(188163),(118221),(160845),(143736),(144248),(4791491),(115604),(198498),(141808),(142376),(157359),(75959),(1173161),(164573),(148562),(84605),(3029831),(122139),(89745),(164234),(262061),(29649833),(143202),(38008495),(102814),(178677),(114786),(4061851),(90285),(195386),(267314),(135205),(139824),(139671),(161875),(149155),(129031),(111604),(90363),(145258),(197746),(8566620),(185888),(170902),(170874),(82805),(194797),(114925),(156053),(95872),(194023),(81316),(227647),(187408),(126485),(196083),(10261747),(245659),(249871),(86746),(205836),(259743),(225967),(192523),(199975),(202202),(1173124),(168114),(122580),(241209),(260733),(81984),(129501),(81346),(141037),(162820),(221136),(178433),(263186),(261943),(147152),(240646),(223652),(79030),(220755),(162891),(176200),(104781),(219299),(245836),(116102),(108551),(94222),(263475),(118392),(42105593),(46236871),(113392),(170491),(138609),(191210),(226977),(203577),(161142),(159639),(73645),(31215812),(168744),(108520),(243999),(132704),(210522),(118621),(89565),(86366),(221593),(76033),(173849),(172278),(31514436),(150701),(170790),(140362),(227558),(251478),(30765443),(73900),(76562),(221211),(81639),(126658),(268647),(78602),(218521),(269401),(229397),(10039806),(383826),(156882),(196032),(87124),(84693),(154301),(92184),(9700382),(193952),(223960),(74030),(180504),(222990),(163153),(158905),(212020),(106040),(192284),(190920),(135125),(148079),(197250),(38621717),(156556),(135829),(35522295),(208902),(114041),(262446),(13377190),(87314),(185065),(147531),(268162),(191815),(75106),(119054),(228944),(34037741),(150874),(212929),(136417),(199538),(79926),(210718),(254732),(157466),(160801),(178215),(146288),(122101),(10655859),(155228),(73689),(209351),(9395965),(3224898),(249413),(418173),(5957896),(176007),(33072197),(131839),(101260),(5315084),(218829),(208746),(90081),(116231),(185864),(90455),(160247),(154116),(5160343),(80793),(139146),(38670305),(190401),(111071),(187911),(87409),(88291),(139974),(143351),(126702),(148975)
create TEMPORARY table `steiermark`.accoIdsTowns(
id int(11) NOT NULL,
PRIMARY KEY (`id`)
) engine = memory; insert into `steiermark`.accoIdsTowns (id)
values
(119718),
(166027),
(160345),
(189874),
(8722782),
(110338),
(90162),
(46461361),
(86879),
(187735),
(156724),
(151300),
(263334),
(79212),
(256504),
(214433),
(4580718),
(91679),
(130799),
(107364),
(128321),
(121323),
(383021),
(7599407),
(141995),
(141272),
(178916),
(84203),
(75600),
(49539259),
(89349),
(130324),
(229470),
(79343),
(384050),
(159538),
(254301),
(204204),
(194917),
(74473),
(199295),
(210887),
(263121),
(32979456),
(204973),
(260291),
(27486615),
(217510),
(168884),
(87518),
(110374),
(218032),
(171586),
(383256),
(33664677),
(190819),
(212689),
(75190),
(186921),
(171978),
(145409),
(95652),
(37868209),
(190210),
(226049),
(27808352),
(200772),
(241860),
(266360),
(166123),
(128141),
(205800),
(107333),
(5315068),
(110842),
(125661),
(73764),
(107859),
(201802),
(125055),
(203394),
(143260),
(82419),
(41634802),
(208932),
(209859),
(254825),
(223613),
(173602),
(225007),
(203882),
(226339),
(82521),
(267530),
(191937),
(201789),
(183531),
(46904829),
(156617),
(4061468),
(220238),
(178500),
(125397),
(185439),
(131085),
(240436),
(200283),
(157149),
(220348),
(220914),
(267186),
(167986),
(75680),
(134831),
(171766),
(105154),
(194713),
(103499),
(6771978),
(220948),
(266888),
(177510),
(9282725),
(106094),
(36566491),
(133017),
(9700388),
(192391),
(145003),
(253709),
(128052),
(100829),
(114609),
(148376),
(114505),
(169525),
(200435),
(121463),
(161406),
(189797),
(209054),
(176296),
(227765),
(141472),
(243209),
(178599),
(73135),
(107555),
(176678),
(34219679),
(135345),
(97116),
(193372),
(147033),
(252859),
(173273),
(228246),
(111341),
(98483),
(73556),
(186176),
(253165),
(219012),
(178962),
(209921),
(149007),
(255713),
(146572),
(195022),
(200595),
(265965),
(212066),
(26970115),
(265468),
(13818591),
(99114),
(167903),
(149700),
(250060),
(186869),
(201732),
(145447),
(157521),
(268989),
(383672),
(174798),
(198307),
(21211748),
(127946),
(171116),
(245352),
(7186183),
(7967625),
(142318),
(98382),
(97682),
(194471),
(94129),
(201319),
(266442),
(72773),
(98180),
(18810400),
(218149),
(268917),
(210439),
(171164),
(9700322),
(150752),
(244648),
(149098),
(121638),
(178337),
(247180),
(135953),
(156680),
(41214843),
(269473),
(261338),
(151225),
(115223),
(261090),
(223333),
(252035),
(136181),
(154821),
(189226),
(205897),
(79424),
(243243),
(160274),
(134094),
(198592),
(98021),
(79763),
(204745),
(242919),
(229314),
(7599993),
(48897409),
(43751656),
(4061766),
(234239),
(32742951),
(129814),
(102697),
(242786),
(198534),
(186109),
(204342),
(38622028),
(166611),
(77223),
(95803),
(183075),
(124606),
(250696),
(85349),
(241752),
(29311567),
(6614248),
(267700),
(136555),
(104153),
(157428),
(20708505),
(263626),
(8722785),
(141729),
(259918),
(163958),
(108881),
(213047),
(254574),
(227604),
(122780),
(247088),
(166076),
(259576),
(154608),
(147915),
(384128),
(13979961),
(195113),
(219686),
(113408),
(105477),
(119097),
(211256),
(208283),
(141880),
(30148041),
(384102),
(8388337),
(192804),
(83126),
(81753),
(91521),
(110779),
(77403),
(191407),
(200867),
(9517217),
(193721),
(205493),
(160168),
(190546),
(165025),
(84542),
(157224),
(255823),
(88772),
(207463),
(187757),
(47202201),
(161664),
(168086),
(383292),
(250829),
(189166),
(130955),
(187810),
(18355899),
(188477),
(249733),
(147969),
(265305),
(156310),
(122718),
(224446),
(260788),
(206641),
(185961),
(172512),
(266243),
(157541),
(190874),
(217376),
(265826),
(106347),
(94870),
(100207),
(175902),
(124113),
(73343),
(6775934),
(266814),
(266549),
(89549),
(213843),
(146129),
(246836),
(156918),
(159064),
(73318),
(213283),
(251539),
(212394),
(255957),
(202332),
(1173251),
(214015),
(384041),
(223733),
(268711),
(239438),
(93789),
(194307),
(223466),
(142897),
(120627),
(192003),
(228081),
(97423),
(154873),
(180136),
(243839),
(262579),
(204528),
(85536),
(75853),
(204827),
(197835),
(6797421),
(121033),
(130455),
(5315087),
(114017),
(9129444),
(135730),
(87071),
(31419712),
(100682),
(183196),
(85117),
(3379819),
(222458),
(169035),
(136066),
(117646),
(242085),
(176457),
(1173892),
(187073),
(199742),
(101813),
(187460),
(134714),
(158731),
(162100),
(113085),
(134133),
(268951),
(179171),
(262167),
(197310),
(195347),
(146259),
(259974),
(202099),
(244552),
(269658),
(211759),
(22840856),
(198187),
(110677),
(111370),
(245926),
(228789),
(129897),
(156464),
(212715),
(265066),
(78111),
(2977929),
(196171),
(22452518),
(102868),
(97625),
(122527),
(79610),
(162327),
(138437),
(100623),
(139070),
(120314),
(37667633),
(1173491),
(263240),
(246876),
(44404593),
(256553),
(170037),
(101798),
(164670),
(91479),
(203901),
(206591),
(9290160),
(91843),
(268384),
(21161019),
(113751),
(39225141),
(208378),
(138273),
(134322),
(38050667),
(209194),
(144028),
(87380),
(176244),
(51503593),
(77600),
(187530),
(104513),
(27807955),
(257470),
(119809),
(74534),
(265878),
(34719290),
(33072200),
(205199),
(9887645),
(248414),
(124829),
(91383),
(96500),
(202690),
(37868894),
(78233),
(241827),
(151587),
(192033),
(244042),
(103365),
(128649),
(73395),
(383006),
(239049),
(80315),
(261224),
(199700),
(207780),
(185598),
(229095),
(251659),
(149059),
(189670),
(213537),
(263995),
(98441),
(182482),
(204651),
(206894),
(197379),
(144556),
(220877),
(131018),
(210638),
(245060),
(140833),
(212729),
(240156),
(191155),
(128992),
(7941416),
(1173603),
(164128),
(108780),
(96112),
(44224029),
(227572),
(181045),
(214424),
(129533),
(266341),
(117438),
(212320),
(91149),
(75898),
(247473),
(202441),
(180717),
(266691),
(43349109),
(186088),
(229645),
(117486),
(142528),
(219157),
(260943),
(1845849),
(227190),
(268304),
(4442181),
(4061616),
(243956),
(147221),
(9290146),
(9700358),
(222748),
(162361),
(176992),
(240386),
(84306),
(175319),
(246306),
(260577),
(101229),
(166413),
(206964),
(142948),
(124869),
(46237639),
(170725),
(2367452),
(382743),
(34636746),
(383139),
(257732),
(35700277),
(181736),
(250174),
(191428),
(1173353),
(102976),
(130741),
(252403),
(173923),
(113626),
(145685),
(23184951),
(252258),
(96924),
(23185284),
(223285),
(178072),
(191047),
(133247),
(382826),
(260387),
(98309),
(211891),
(131790),
(228288),
(144374),
(250318),
(235840),
(7217358),
(226395),
(111003),
(182129),
(203729),
(41024653),
(114320),
(115132),
(165805),
(97332),
(188242),
(198994),
(261884),
(162146),
(169666),
(260555),
(39599857),
(135012),
(199275),
(162257),
(76116),
(210702),
(91180),
(143682),
(83176),
(180387),
(135519),
(227481),
(117877),
(225195),
(7599929),
(191455),
(244970),
(202479),
(266061),
(250387),
(182314),
(93903),
(164627),
(226499),
(229040),
(101745),
(105712),
(204776),
(169959),
(43581664),
(176637),
(246756),
(173474),
(126983),
(225305),
(228197),
(164198),
(186138),
(109291),
(182441),
(228125),
(172618),
(128526),
(209807),
(402843),
(50388225),
(179242),
(31789631),
(41752708),
(124000),
(269773),
(8870626),
(9700325),
(4061962),
(175232),
(189988),
(219765),
(219804),
(181884),
(267623),
(111742),
(112984),
(149642),
(177391),
(153833),
(174544),
(227134),
(246469),
(165937),
(189271),
(223510),
(26898515),
(123820),
(267023),
(170518),
(244956),
(38723937),
(139730),
(213326),
(138331),
(147191),
(240120),
(15659243),
(181569),
(87970),
(189617),
(4149175),
(41680612),
(86586),
(13400949),
(163032),
(200906),
(245784),
(143785),
(101403),
(145352),
(242964),
(262376),
(170382),
(3224895),
(113819),
(97550),
(242703),
(27076239),
(251348),
(96059),
(210751),
(207573),
(199934),
(134210),
(143596),
(221094),
(173082),
(77798),
(204855),
(90325),
(110467),
(92309),
(36278962),
(143448),
(156225),
(176727),
(98451),
(79701),
(115484),
(38300874),
(220693),
(88601),
(383494),
(183290),
(146183),
(202588),
(268424),
(383360),
(143537),
(101873),
(142776),
(154459),
(195314),
(76427),
(107057),
(88849),
(190634),
(229144),
(224332),
(75482),
(162969),
(181441),
(179201),
(193204),
(223044),
(108195),
(250658),
(166529),
(244711),
(105369),
(91299),
(20059276),
(181966),
(160614),
(11367104),
(155356),
(151031),
(132281),
(136036),
(100061),
(102372),
(109732),
(89456),
(109501),
(7541413),
(132606),
(188200),
(199850),
(195225),
(102558),
(150639),
(104583),
(3176489),
(179735),
(251865),
(51216654),
(148779),
(221512),
(86434),
(22892603),
(203636),
(267678),
(160120),
(262206),
(119029),
(144062),
(125266),
(85808),
(132556),
(3379737),
(87856),
(49539249),
(203147),
(168676),
(31719532),
(15668814),
(132156),
(180460),
(194565),
(264448),
(162656),
(8695139),
(238918),
(72611),
(129096),
(242014),
(222898),
(136496),
(77134),
(241967),
(193149),
(129250),
(268279),
(220655),
(191266),
(256037),
(138736),
(140059),
(96354),
(156762),
(262837),
(179767),
(187180),
(7780777),
(72244),
(144112),
(181329),
(174091),
(144517),
(141562),
(147609),
(105748),
(150268),
(74347),
(256865),
(240534),
(31077769),
(87219),
(78857),
(245591),
(157061),
(97982),
(134439),
(213869),
(201863),
(4791485),
(220170),
(163837),
(89709),
(189123),
(144833),
(257010),
(223395),
(177157),
(22882595),
(265768),
(151492),
(124694),
(214160),
(151257),
(222266),
(261487),
(221382),
(139252),
(224600),
(98352),
(256818),
(118447),
(89972),
(174338),
(220531),
(27199439),
(122810),
(4061779),
(17058949),
(1173542),
(75643),
(267501),
(218375),
(89073),
(129206),
(42358761),
(265584),
(221442),
(72528),
(211808),
(89261),
(20627345),
(263716),
(197713),
(94738),
(77069),
(111651),
(244217),
(77540),
(83605),
(33267404),
(225114),
(188894),
(163235),
(225267),
(148602),
(149455),
(27808188),
(164436),
(150008),
(382988),
(88890),
(158648),
(193068),
(98143),
(99548),
(171224),
(2853495),
(223447),
(177852),
(213132),
(218293),
(88688),
(200126),
(146983),
(48897791),
(96266),
(181278),
(210768),
(188963),
(179118),
(110254),
(195558),
(132963),
(154758),
(76091),
(128254),
(150724),
(76900),
(106287),
(128888),
(108664),
(139875),
(4442187),
(209213),
(249659),
(100524),
(261005),
(91812),
(17877742),
(221173),
(98639),
(141656),
(227732),
(2655510),
(208109),
(227403),
(156120),
(259359),
(81217),
(21308116),
(4442184),
(128612),
(208831),
(190504),
(74880),
(179813),
(8618578),
(231694),
(22892606),
(74121),
(150070),
(254246),
(193837),
(84734),
(247897),
(101969),
(27808178),
(261585),
(79494),
(20972969),
(18332685),
(178544),
(261287),
(135685),
(149400),
(151568),
(192306),
(247967),
(117802),
(145614),
(87012),
(260687),
(105761),
(27808362),
(213925),
(218867),
(168651),
(253939),
(101167),
(4442214),
(198380),
(20512295),
(90830),
(218042),
(21237158),
(209589),
(4061812),
(1173742),
(2566227),
(148211),
(242815),
(163692),
(203485),
(13723644),
(130049),
(241513),
(242072),
(261823),
(256266),
(88121),
(222491),
(80509),
(84439),
(205753),
(175147),
(5957905),
(131135),
(128777),
(190150),
(23220930),
(383118),
(168470),
(260613),
(220546),
(206198),
(264897),
(171662),
(80345),
(167765),
(75009),
(150197),
(155523),
(164042),
(154180),
(120483),
(142573),
(27224568),
(189598),
(91777),
(152590),
(155984),
(172344),
(89886),
(154226),
(186259),
(45539296),
(194960),
(146486),
(186209),
(383375),
(72285),
(207430),
(135403),
(268018),
(5160340),
(115150),
(103592),
(183391),
(75414),
(177333),
(174680),
(146703),
(3118747),
(140245),
(262617),
(264308),
(114455),
(182335),
(212164),
(269445),
(151676),
(147869),
(41796413),
(74427),
(162295),
(172217),
(31665450),
(8388408),
(228572),
(83429),
(6771981),
(227270),
(220200),
(85437),
(148899),
(96544),
(202896),
(101590),
(74297),
(15050850),
(90791),
(147399),
(267915),
(185795),
(3411816),
(174181),
(267851),
(265930),
(212576),
(145494),
(140325),
(142256),
(94373),
(2470567),
(176897),
(192497),
(125739),
(204161),
(74757),
(266661),
(23945599),
(107594),
(3379718),
(23106697),
(138703),
(114734),
(139042),
(218076),
(205363),
(210612),
(197648),
(18810410),
(138939),
(80083),
(207109),
(202554),
(219645),
(103348),
(87899),
(177240),
(212470),
(180106),
(174035),
(176975),
(240404),
(169612),
(171431),
(383497),
(193518),
(92398),
(180007),
(199831),
(119873),
(192842),
(257803),
(259830),
(186795),
(245886),
(1173121),
(195918),
(146150),
(186236),
(95945),
(80940),
(47158244),
(233730),
(179680),
(228856),
(241670),
(199572),
(162948),
(124237),
(174583),
(127993),
(81094),
(26244429),
(142725),
(103833),
(190061),
(190383),
(174737),
(227046),
(195752),
(28138429),
(139639),
(172317),
(1173693),
(102508),
(157401),
(206854),
(102266),
(9517247),
(173543),
(211866),
(205724),
(39995931),
(196249),
(108105),
(168606),
(80548),
(115353),
(101549),
(108003),
(130026),
(209483),
(266112),
(143038),
(111233),
(49169351),
(159735),
(151636),
(209445),
(192660),
(109827),
(113160),
(255905),
(155492),
(194884),
(133887),
(127120),
(108052),
(208674),
(248735),
(161033),
(203308),
(199099),
(77357),
(113462),
(202800),
(81720),
(218423),
(78974),
(82308),
(124337),
(175690),
(165005),
(171549),
(120959),
(91914),
(108989),
(115753),
(124718),
(47294199),
(209292),
(109234),
(16306657),
(106889),
(21273299),
(180306),
(23455826),
(110435),
(170268),
(170704),
(170765),
(7715980),
(17594470),
(185698),
(26648317),
(82604),
(125952),
(263799),
(78778),
(87340),
(96619),
(249148),
(208516),
(256958),
(191516),
(160203),
(198814),
(1173254),
(267580),
(146397),
(99420),
(166311),
(228314),
(95043),
(383578),
(240971),
(224773),
(39558144),
(268827),
(83792),
(143950),
(114251),
(177255),
(136200),
(120394),
(130267),
(269023),
(122838),
(255407),
(192120),
(227892),
(251064),
(122307),
(4061656),
(109374),
(99678),
(201425),
(182728),
(177439),
(154051),
(185045),
(203131),
(195136),
(171085),
(171353),
(260508),
(169799),
(155681),
(11213840),
(107672),
(14623690),
(171964),
(115545),
(222689),
(15243082),
(242260),
(164711),
(207763),
(131774),
(132768),
(107023),
(241089),
(77676),
(1904411),
(225374),
(195537),
(157109),
(223355),
(211155),
(91582),
(131179),
(205629),
(164309),
(155598),
(150349),
(97583),
(26684056),
(147332),
(175792),
(7678621),
(173880),
(174941),
(139196),
(149216),
(250245),
(245508),
(185208),
(120883),
(4791488),
(116132),
(219501),
(18323640),
(35241603),
(80881),
(5957902),
(95383),
(87467),
(197565),
(145830),
(226215),
(218235),
(14557855),
(265255),
(106445),
(44869050),
(136526),
(39355239),
(96781),
(261973),
(144860),
(174987),
(99228),
(193028),
(199364),
(193693),
(211686),
(1173653),
(14669428),
(207942),
(7016779),
(27128134),
(241333),
(105395),
(224525),
(103526),
(261158),
(106770),
(12253627),
(23106643),
(383027),
(115416),
(265378),
(121533),
(165965),
(118332),
(176111),
(220483),
(1173158),
(12371222),
(103317),
(37366700),
(158547),
(17275737),
(37038521),
(111091),
(90672),
(158481),
(8591193),
(111521),
(188297),
(81527),
(84906),
(22568743),
(139584),
(115902),
(94404),
(176068),
(179886),
(208002),
(187883),
(74091),
(157283),
(243765),
(220403),
(9872791),
(257550),
(245240),
(384186),
(103051),
(106657),
(203617),
(252832),
(175610),
(213063),
(383286),
(98121),
(213358),
(255495),
(135252),
(117916),
(188163),
(118221),
(160845),
(143736),
(144248),
(4791491),
(115604),
(198498),
(141808),
(142376),
(157359),
(75959),
(1173161),
(164573),
(148562),
(84605),
(3029831),
(122139),
(89745),
(164234),
(262061),
(29649833),
(143202),
(38008495),
(102814),
(178677),
(114786),
(4061851),
(90285),
(195386),
(267314),
(135205),
(139824),
(139671),
(161875),
(149155),
(129031),
(111604),
(90363),
(145258),
(197746),
(8566620),
(185888),
(170902),
(170874),
(82805),
(194797),
(114925),
(156053),
(95872),
(194023),
(81316),
(227647),
(187408),
(126485),
(196083),
(10261747),
(245659),
(249871),
(86746),
(205836),
(259743),
(225967),
(192523),
(199975),
(202202),
(1173124),
(168114),
(122580),
(241209),
(260733),
(81984),
(129501),
(81346),
(141037),
(162820),
(221136),
(178433),
(263186),
(261943),
(147152),
(240646),
(223652),
(79030),
(220755),
(162891),
(176200),
(104781),
(219299),
(245836),
(116102),
(108551),
(94222),
(263475),
(118392),
(42105593),
(46236871),
(113392),
(170491),
(138609),
(191210),
(226977),
(203577),
(161142),
(159639),
(73645),
(31215812),
(168744),
(108520),
(243999),
(132704),
(210522),
(118621),
(89565),
(86366),
(221593),
(76033),
(173849),
(172278),
(31514436),
(150701),
(170790),
(140362),
(227558),
(251478),
(30765443),
(73900),
(76562),
(221211),
(81639),
(126658),
(268647),
(78602),
(218521),
(269401),
(229397),
(10039806),
(383826),
(156882),
(196032),
(87124),
(84693),
(154301),
(92184),
(9700382),
(193952),
(223960),
(74030),
(180504),
(222990),
(163153),
(158905),
(212020),
(106040),
(192284),
(190920),
(135125),
(148079),
(197250),
(38621717),
(156556),
(135829),
(35522295),
(208902),
(114041),
(262446),
(13377190),
(87314),
(185065),
(147531),
(268162),
(191815),
(75106),
(119054),
(228944),
(34037741),
(150874),
(212929),
(136417),
(199538),
(79926),
(210718),
(254732),
(157466),
(160801),
(178215),
(146288),
(122101),
(10655859),
(155228),
(73689),
(209351),
(9395965),
(3224898),
(249413),
(418173),
(5957896),
(176007),
(33072197),
(131839),
(101260),
(5315084),
(218829),
(208746),
(90081),
(116231),
(185864),
(90455),
(160247),
(154116),
(5160343),
(80793),
(139146),
(38670305),
(190401),
(111071),
(187911),
(87409),
(88291),
(139974),
(143351),
(126702),
(148975)
create TEMPORARY table `steiermark`.accoIdsTowns(
id int(11) NOT NULL,
PRIMARY KEY (`id`)
)
engine=memory;
insert into `steiermark`.accoIdsTowns (id) values (119718),(166027),(160345),(189874),(8722782),(110338),(90162),(46461361),(86879),(187735),(156724),(151300),(263334),(79212),(256504),(214433),(4580718),(91679),(130799),(107364),(128321),(121323),(383021),(7599407),(141995),(141272),(178916),(84203),(75600),(49539259),(89349),(130324),(229470),(79343),(384050),(159538),(254301),(204204),(194917),(74473),(199295),(210887),(263121),(32979456),(204973),(260291),(27486615),(217510),(168884),(87518),(110374),(218032),(171586),(383256),(33664677),(190819),(212689),(75190),(186921),(171978),(145409),(95652),(37868209),(190210),(226049),(27808352),(200772),(241860),(266360),(166123),(128141),(205800),(107333),(5315068),(110842),(125661),(73764),(107859),(201802),(125055),(203394),(143260),(82419),(41634802),(208932),(209859),(254825),(223613),(173602),(225007),(203882),(226339),(82521),(267530),(191937),(201789),(183531),(46904829),(156617),(4061468),(220238),(178500),(125397),(185439),(131085),(240436),(200283),(157149),(220348),(220914),(267186),(167986),(75680),(134831),(171766),(105154),(194713),(103499),(6771978),(220948),(266888),(177510),(9282725),(106094),(36566491),(133017),(9700388),(192391),(145003),(253709),(128052),(100829),(114609),(148376),(114505),(169525),(200435),(121463),(161406),(189797),(209054),(176296),(227765),(141472),(243209),(178599),(73135),(107555),(176678),(34219679),(135345),(97116),(193372),(147033),(252859),(173273),(228246),(111341),(98483),(73556),(186176),(253165),(219012),(178962),(209921),(149007),(255713),(146572),(195022),(200595),(265965),(212066),(26970115),(265468),(13818591),(99114),(167903),(149700),(250060),(186869),(201732),(145447),(157521),(268989),(383672),(174798),(198307),(21211748),(127946),(171116),(245352),(7186183),(7967625),(142318),(98382),(97682),(194471),(94129),(201319),(266442),(72773),(98180),(18810400),(218149),(268917),(210439),(171164),(9700322),(150752),(244648),(149098),(121638),(178337),(247180),(135953),(156680),(41214843),(269473),(261338),(151225),(115223),(261090),(223333),(252035),(136181),(154821),(189226),(205897),(79424),(243243),(160274),(134094),(198592),(98021),(79763),(204745),(242919),(229314),(7599993),(48897409),(43751656),(4061766),(234239),(32742951),(129814),(102697),(242786),(198534),(186109),(204342),(38622028),(166611),(77223),(95803),(183075),(124606),(250696),(85349),(241752),(29311567),(6614248),(267700),(136555),(104153),(157428),(20708505),(263626),(8722785),(141729),(259918),(163958),(108881),(213047),(254574),(227604),(122780),(247088),(166076),(259576),(154608),(147915),(384128),(13979961),(195113),(219686),(113408),(105477),(119097),(211256),(208283),(141880),(30148041),(384102),(8388337),(192804),(83126),(81753),(91521),(110779),(77403),(191407),(200867),(9517217),(193721),(205493),(160168),(190546),(165025),(84542),(157224),(255823),(88772),(207463),(187757),(47202201),(161664),(168086),(383292),(250829),(189166),(130955),(187810),(18355899),(188477),(249733),(147969),(265305),(156310),(122718),(224446),(260788),(206641),(185961),(172512),(266243),(157541),(190874),(217376),(265826),(106347),(94870),(100207),(175902),(124113),(73343),(6775934),(266814),(266549),(89549),(213843),(146129),(246836),(156918),(159064),(73318),(213283),(251539),(212394),(255957),(202332),(1173251),(214015),(384041),(223733),(268711),(239438),(93789),(194307),(223466),(142897),(120627),(192003),(228081),(97423),(154873),(180136),(243839),(262579),(204528),(85536),(75853),(204827),(197835),(6797421),(121033),(130455),(5315087),(114017),(9129444),(135730),(87071),(31419712),(100682),(183196),(85117),(3379819),(222458),(169035),(136066),(117646),(242085),(176457),(1173892),(187073),(199742),(101813),(187460),(134714),(158731),(162100),(113085),(134133),(268951),(179171),(262167),(197310),(195347),(146259),(259974),(202099),(244552),(269658),(211759),(22840856),(198187),(110677),(111370),(245926),(228789),(129897),(156464),(212715),(265066),(78111),(2977929),(196171),(22452518),(102868),(97625),(122527),(79610),(162327),(138437),(100623),(139070),(120314),(37667633),(1173491),(263240),(246876),(44404593),(256553),(170037),(101798),(164670),(91479),(203901),(206591),(9290160),(91843),(268384),(21161019),(113751),(39225141),(208378),(138273),(134322),(38050667),(209194),(144028),(87380),(176244),(51503593),(77600),(187530),(104513),(27807955),(257470),(119809),(74534),(265878),(34719290),(33072200),(205199),(9887645),(248414),(124829),(91383),(96500),(202690),(37868894),(78233),(241827),(151587),(192033),(244042),(103365),(128649),(73395),(383006),(239049),(80315),(261224),(199700),(207780),(185598),(229095),(251659),(149059),(189670),(213537),(263995),(98441),(182482),(204651),(206894),(197379),(144556),(220877),(131018),(210638),(245060),(140833),(212729),(240156),(191155),(128992),(7941416),(1173603),(164128),(108780),(96112),(44224029),(227572),(181045),(214424),(129533),(266341),(117438),(212320),(91149),(75898),(247473),(202441),(180717),(266691),(43349109),(186088),(229645),(117486),(142528),(219157),(260943),(1845849),(227190),(268304),(4442181),(4061616),(243956),(147221),(9290146),(9700358),(222748),(162361),(176992),(240386),(84306),(175319),(246306),(260577),(101229),(166413),(206964),(142948),(124869),(46237639),(170725),(2367452),(382743),(34636746),(383139),(257732),(35700277),(181736),(250174),(191428),(1173353),(102976),(130741),(252403),(173923),(113626),(145685),(23184951),(252258),(96924),(23185284),(223285),(178072),(191047),(133247),(382826),(260387),(98309),(211891),(131790),(228288),(144374),(250318),(235840),(7217358),(226395),(111003),(182129),(203729),(41024653),(114320),(115132),(165805),(97332),(188242),(198994),(261884),(162146),(169666),(260555),(39599857),(135012),(199275),(162257),(76116),(210702),(91180),(143682),(83176),(180387),(135519),(227481),(117877),(225195),(7599929),(191455),(244970),(202479),(266061),(250387),(182314),(93903),(164627),(226499),(229040),(101745),(105712),(204776),(169959),(43581664),(176637),(246756),(173474),(126983),(225305),(228197),(164198),(186138),(109291),(182441),(228125),(172618),(128526),(209807),(402843),(50388225),(179242),(31789631),(41752708),(124000),(269773),(8870626),(9700325),(4061962),(175232),(189988),(219765),(219804),(181884),(267623),(111742),(112984),(149642),(177391),(153833),(174544),(227134),(246469),(165937),(189271),(223510),(26898515),(123820),(267023),(170518),(244956),(38723937),(139730),(213326),(138331),(147191),(240120),(15659243),(181569),(87970),(189617),(4149175),(41680612),(86586),(13400949),(163032),(200906),(245784),(143785),(101403),(145352),(242964),(262376),(170382),(3224895),(113819),(97550),(242703),(27076239),(251348),(96059),(210751),(207573),(199934),(134210),(143596),(221094),(173082),(77798),(204855),(90325),(110467),(92309),(36278962),(143448),(156225),(176727),(98451),(79701),(115484),(38300874),(220693),(88601),(383494),(183290),(146183),(202588),(268424),(383360),(143537),(101873),(142776),(154459),(195314),(76427),(107057),(88849),(190634),(229144),(224332),(75482),(162969),(181441),(179201),(193204),(223044),(108195),(250658),(166529),(244711),(105369),(91299),(20059276),(181966),(160614),(11367104),(155356),(151031),(132281),(136036),(100061),(102372),(109732),(89456),(109501),(7541413),(132606),(188200),(199850),(195225),(102558),(150639),(104583),(3176489),(179735),(251865),(51216654),(148779),(221512),(86434),(22892603),(203636),(267678),(160120),(262206),(119029),(144062),(125266),(85808),(132556),(3379737),(87856),(49539249),(203147),(168676),(31719532),(15668814),(132156),(180460),(194565),(264448),(162656),(8695139),(238918),(72611),(129096),(242014),(222898),(136496),(77134),(241967),(193149),(129250),(268279),(220655),(191266),(256037),(138736),(140059),(96354),(156762),(262837),(179767),(187180),(7780777),(72244),(144112),(181329),(174091),(144517),(141562),(147609),(105748),(150268),(74347),(256865),(240534),(31077769),(87219),(78857),(245591),(157061),(97982),(134439),(213869),(201863),(4791485),(220170),(163837),(89709),(189123),(144833),(257010),(223395),(177157),(22882595),(265768),(151492),(124694),(214160),(151257),(222266),(261487),(221382),(139252),(224600),(98352),(256818),(118447),(89972),(174338),(220531),(27199439),(122810),(4061779),(17058949),(1173542),(75643),(267501),(218375),(89073),(129206),(42358761),(265584),(221442),(72528),(211808),(89261),(20627345),(263716),(197713),(94738),(77069),(111651),(244217),(77540),(83605),(33267404),(225114),(188894),(163235),(225267),(148602),(149455),(27808188),(164436),(150008),(382988),(88890),(158648),(193068),(98143),(99548),(171224),(2853495),(223447),(177852),(213132),(218293),(88688),(200126),(146983),(48897791),(96266),(181278),(210768),(188963),(179118),(110254),(195558),(132963),(154758),(76091),(128254),(150724),(76900),(106287),(128888),(108664),(139875),(4442187),(209213),(249659),(100524),(261005),(91812),(17877742),(221173),(98639),(141656),(227732),(2655510),(208109),(227403),(156120),(259359),(81217),(21308116),(4442184),(128612),(208831),(190504),(74880),(179813),(8618578),(231694),(22892606),(74121),(150070),(254246),(193837),(84734),(247897),(101969),(27808178),(261585),(79494),(20972969),(18332685),(178544),(261287),(135685),(149400),(151568),(192306),(247967),(117802),(145614),(87012),(260687),(105761),(27808362),(213925),(218867),(168651),(253939),(101167),(4442214),(198380),(20512295),(90830),(218042),(21237158),(209589),(4061812),(1173742),(2566227),(148211),(242815),(163692),(203485),(13723644),(130049),(241513),(242072),(261823),(256266),(88121),(222491),(80509),(84439),(205753),(175147),(5957905),(131135),(128777),(190150),(23220930),(383118),(168470),(260613),(220546),(206198),(264897),(171662),(80345),(167765),(75009),(150197),(155523),(164042),(154180),(120483),(142573),(27224568),(189598),(91777),(152590),(155984),(172344),(89886),(154226),(186259),(45539296),(194960),(146486),(186209),(383375),(72285),(207430),(135403),(268018),(5160340),(115150),(103592),(183391),(75414),(177333),(174680),(146703),(3118747),(140245),(262617),(264308),(114455),(182335),(212164),(269445),(151676),(147869),(41796413),(74427),(162295),(172217),(31665450),(8388408),(228572),(83429),(6771981),(227270),(220200),(85437),(148899),(96544),(202896),(101590),(74297),(15050850),(90791),(147399),(267915),(185795),(3411816),(174181),(267851),(265930),(212576),(145494),(140325),(142256),(94373),(2470567),(176897),(192497),(125739),(204161),(74757),(266661),(23945599),(107594),(3379718),(23106697),(138703),(114734),(139042),(218076),(205363),(210612),(197648),(18810410),(138939),(80083),(207109),(202554),(219645),(103348),(87899),(177240),(212470),(180106),(174035),(176975),(240404),(169612),(171431),(383497),(193518),(92398),(180007),(199831),(119873),(192842),(257803),(259830),(186795),(245886),(1173121),(195918),(146150),(186236),(95945),(80940),(47158244),(233730),(179680),(228856),(241670),(199572),(162948),(124237),(174583),(127993),(81094),(26244429),(142725),(103833),(190061),(190383),(174737),(227046),(195752),(28138429),(139639),(172317),(1173693),(102508),(157401),(206854),(102266),(9517247),(173543),(211866),(205724),(39995931),(196249),(108105),(168606),(80548),(115353),(101549),(108003),(130026),(209483),(266112),(143038),(111233),(49169351),(159735),(151636),(209445),(192660),(109827),(113160),(255905),(155492),(194884),(133887),(127120),(108052),(208674),(248735),(161033),(203308),(199099),(77357),(113462),(202800),(81720),(218423),(78974),(82308),(124337),(175690),(165005),(171549),(120959),(91914),(108989),(115753),(124718),(47294199),(209292),(109234),(16306657),(106889),(21273299),(180306),(23455826),(110435),(170268),(170704),(170765),(7715980),(17594470),(185698),(26648317),(82604),(125952),(263799),(78778),(87340),(96619),(249148),(208516),(256958),(191516),(160203),(198814),(1173254),(267580),(146397),(99420),(166311),(228314),(95043),(383578),(240971),(224773),(39558144),(268827),(83792),(143950),(114251),(177255),(136200),(120394),(130267),(269023),(122838),(255407),(192120),(227892),(251064),(122307),(4061656),(109374),(99678),(201425),(182728),(177439),(154051),(185045),(203131),(195136),(171085),(171353),(260508),(169799),(155681),(11213840),(107672),(14623690),(171964),(115545),(222689),(15243082),(242260),(164711),(207763),(131774),(132768),(107023),(241089),(77676),(1904411),(225374),(195537),(157109),(223355),(211155),(91582),(131179),(205629),(164309),(155598),(150349),(97583),(26684056),(147332),(175792),(7678621),(173880),(174941),(139196),(149216),(250245),(245508),(185208),(120883),(4791488),(116132),(219501),(18323640),(35241603),(80881),(5957902),(95383),(87467),(197565),(145830),(226215),(218235),(14557855),(265255),(106445),(44869050),(136526),(39355239),(96781),(261973),(144860),(174987),(99228),(193028),(199364),(193693),(211686),(1173653),(14669428),(207942),(7016779),(27128134),(241333),(105395),(224525),(103526),(261158),(106770),(12253627),(23106643),(383027),(115416),(265378),(121533),(165965),(118332),(176111),(220483),(1173158),(12371222),(103317),(37366700),(158547),(17275737),(37038521),(111091),(90672),(158481),(8591193),(111521),(188297),(81527),(84906),(22568743),(139584),(115902),(94404),(176068),(179886),(208002),(187883),(74091),(157283),(243765),(220403),(9872791),(257550),(245240),(384186),(103051),(106657),(203617),(252832),(175610),(213063),(383286),(98121),(213358),(255495),(135252),(117916),(188163),(118221),(160845),(143736),(144248),(4791491),(115604),(198498),(141808),(142376),(157359),(75959),(1173161),(164573),(148562),(84605),(3029831),(122139),(89745),(164234),(262061),(29649833),(143202),(38008495),(102814),(178677),(114786),(4061851),(90285),(195386),(267314),(135205),(139824),(139671),(161875),(149155),(129031),(111604),(90363),(145258),(197746),(8566620),(185888),(170902),(170874),(82805),(194797),(114925),(156053),(95872),(194023),(81316),(227647),(187408),(126485),(196083),(10261747),(245659),(249871),(86746),(205836),(259743),(225967),(192523),(199975),(202202),(1173124),(168114),(122580),(241209),(260733),(81984),(129501),(81346),(141037),(162820),(221136),(178433),(263186),(261943),(147152),(240646),(223652),(79030),(220755),(162891),(176200),(104781),(219299),(245836),(116102),(108551),(94222),(263475),(118392),(42105593),(46236871),(113392),(170491),(138609),(191210),(226977),(203577),(161142),(159639),(73645),(31215812),(168744),(108520),(243999),(132704),(210522),(118621),(89565),(86366),(221593),(76033),(173849),(172278),(31514436),(150701),(170790),(140362),(227558),(251478),(30765443),(73900),(76562),(221211),(81639),(126658),(268647),(78602),(218521),(269401),(229397),(10039806),(383826),(156882),(196032),(87124),(84693),(154301),(92184),(9700382),(193952),(223960),(74030),(180504),(222990),(163153),(158905),(212020),(106040),(192284),(190920),(135125),(148079),(197250),(38621717),(156556),(135829),(35522295),(208902),(114041),(262446),(13377190),(87314),(185065),(147531),(268162),(191815),(75106),(119054),(228944),(34037741),(150874),(212929),(136417),(199538),(79926),(210718),(254732),(157466),(160801),(178215),(146288),(122101),(10655859),(155228),(73689),(209351),(9395965),(3224898),(249413),(418173),(5957896),(176007),(33072197),(131839),(101260),(5315084),(218829),(208746),(90081),(116231),(185864),(90455),(160247),(154116),(5160343),(80793),(139146),(38670305),(190401),(111071),(187911),(87409),(88291),(139974),(143351),(126702),(148975);
|
1.02 ms (0.23%)
|
1 |
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (9948)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (9948)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
;
|
0.83 ms (0.18%)
|
14 |
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;;
|
0.81 ms (0.18%)
|
1 |
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (6896)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (6896)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
;
|
0.69 ms (0.15%)
|
1 |
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (6877)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (6877)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
;
|
0.45 ms (0.10%)
|
1 |
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (6859)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (6859)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
;
|
0.43 ms (0.10%)
|
1 |
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (6898)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (6898)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
;
|
0.26 ms (0.06%)
|
1 |
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (9939)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (9939)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
;
|
0.21 ms (0.05%)
|
1 |
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (6925)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (6925)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
;
|
0.21 ms (0.05%)
|
1 |
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (9943)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (9943)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
;
|
0.20 ms (0.04%)
|
1 |
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (9941)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (9941)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
;
|
0.18 ms (0.04%)
|
1 |
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (6868)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
SELECT count(DISTINCT src_id) as accoCount
FROM `steiermark`.object_relations_8 daccorel
WHERE
dest_id IN (6868)
AND
src_id IN
(select id from `steiermark`.accoIdsTowns)
;
|