Najgori SQL query na svetu - Strana 7

Aleksandar.Ilic · 18. 06. 2009.

btw, sada sam skontao da je ovaj prvi explain koji sam ja radio da bih shvatio sta fali upitu :S

dukacar · 19. 06. 2009.

Citat:

Originalno napisao bluesman

Jos uvek ne mogu da poverujem u ovo sto sam video veceras. Mislim da covek koji napise ovakav query ne samo da treba da dobije otkaz nego jos i batine:

SELECT DISTINCT users.id, users.membership, (((acos(sin((35.7589*pi()/180)) * sin((users.latitude*pi()/180))+cos((35.7589*pi()/180)) * cos((users.latitude*pi()/180)) * cos(((-78.7798- users.longitude)*pi()/180))))*180/pi())*60*1.1515) as distance
FROM users
INNER JOIN laston ON users.id = laston.user_id INNER JOIN z_9 AS s9 ON users.id = s9.user_id INNER JOIN z_12 AS s12 ON users.id = s12.user_id INNER JOIN z_13 AS s13 ON users.id = s13.user_id INNER JOIN z_14 AS s14 ON users.id = s14.user_id INNER JOIN z_15 AS s15 ON users.id = s15.user_id INNER JOIN z_16 AS s16 ON users.id = s16.user_id INNER JOIN z_17 AS s17 ON users.id = s17.user_id INNER JOIN z_18 AS s18 ON users.id = s18.user_id INNER JOIN z_19 AS s19 ON users.id = s19.user_id INNER JOIN z_21 AS s21 ON users.id = s21.user_id INNER JOIN z_22 AS s22 ON users.id = s22.user_id INNER JOIN z_23 AS s23 ON users.id = s23.user_id INNER JOIN z_24 AS s24 ON users.id = s24.user_id INNER JOIN z_25 AS s25 ON users.id = s25.user_id INNER JOIN z_27 AS s27 ON users.id = s27.user_id INNER JOIN z_29 AS s29 ON users.id = s29.user_id INNER JOIN z_31 AS s31 ON users.id = s31.user_id INNER JOIN z_32 AS s32 ON users.id = s32.user_id INNER JOIN z_33 AS s33 ON users.id = s33.user_id INNER JOIN z_35 AS s35 ON users.id = s35.user_id INNER JOIN z_38 AS s38 ON users.id = s38.user_id INNER JOIN z_39 AS s39 ON users.id = s39.user_id INNER JOIN z_40 AS s40 ON users.id = s40.user_id INNER JOIN z_41 AS s41 ON users.id = s41.user_id INNER JOIN z_42 AS s42 ON users.id = s42.user_id INNER JOIN z_50 AS s50 ON users.id = s50.user_id INNER JOIN z_51 AS s51 ON users.id = s51.user_id INNER JOIN z_53 AS s53 ON users.id = s53.user_id INNER JOIN z_55 AS s55 ON users.id = s55.user_id INNER JOIN z_58 AS s58 ON users.id = s58.user_id INNER JOIN z_60 AS s60 ON users.id = s60.user_id
WHERE 1 AND users.gender = '4112' AND users.seeking = '4092' AND (s9.option_id = '137' OR s9.option_id = '138' OR s9.option_id = '139' OR s9.option_id = '140' OR s9.option_id = '141' OR s9.option_id = '142' OR s9.option_id = '433' OR s9.option_id = '434' OR s9.option_id = '481' OR s9.option_id = '482') AND (s12.option_id = '214' OR s12.option_id = '215' OR s12.option_id = '216' OR s12.option_id = '217' OR s12.option_id = '218' OR s12.option_id = '220') AND (s13.option_id = '221' OR s13.option_id = '222' OR s13.option_id = '223' OR s13.option_id = '224' OR s13.option_id = '225' OR s13.option_id = '226' OR s13.option_id = '227' OR s13.option_id = '429' OR s13.option_id = '435' OR s13.option_id = '495') AND (s14.option_id = '228' OR s14.option_id = '229' OR s14.option_id = '230' OR s14.option_id = '231' OR s14.option_id = '488' OR s14.option_id = '489' OR s14.option_id = '646') AND (s15.option_id = '232' OR s15.option_id = '233' OR s15.option_id = '234' OR s15.option_id = '645') AND (s16.option_id = '238' OR s16.option_id = '239' OR s16.option_id = '240') AND (s17.option_id = '242' OR s17.option_id = '243' OR s17.option_id = '244' OR s17.option_id = '245' OR s17.option_id = '246' OR s17.option_id = '436') AND (s18.option_id = '248' OR s18.option_id = '249' OR s18.option_id = '250' OR s18.option_id = '251' OR s18.option_id = '252' OR s18.option_id = '253' OR s18.option_id = '254' OR s18.option_id = '437') AND (s19.option_id = '256' OR s19.option_id = '257' OR s19.option_id = '258' OR s19.option_id = '259' OR s19.option_id = '260' OR s19.option_id = '261' OR s19.option_id = '262' OR s19.option_id = '263' OR s19.option_id = '264' OR s19.option_id = '265') AND (s21.option_id = '276' OR s21.option_id = '277' OR s21.option_id = '278' OR s21.option_id = '279' OR s21.option_id = '280' OR s21.option_id = '281' OR s21.option_id = '282' OR s21.option_id = '283') AND (s22.option_id = '285' OR s22.option_id = '286' OR s22.option_id = '287' OR s22.option_id = '288' OR s22.option_id = '492' OR s22.option_id = '493' OR s22.option_id = '494') AND (s23.option_id = '290' OR s23.option_id = '291' OR s23.option_id = '292' OR s23.option_id = '491' OR s23.option_id = '663') AND (s24.option_id = '294' OR s24.option_id = '295' OR s24.option_id = '296' OR s24.option_id = '297' OR s24.option_id = '298') AND (s25.option_id = '299' OR s25.option_id = '300' OR s25.option_id = '301' OR s25.option_id = '302' OR s25.option_id = '454' OR s25.option_id = '455') AND (s27.option_id = '312' OR s27.option_id = '313' OR s27.option_id = '314' OR s27.option_id = '315' OR s27.option_id = '316' OR s27.option_id = '317' OR s27.option_id = '318' OR s27.option_id = '319' OR s27.option_id = '320' OR s27.option_id = '344') AND (s29.option_id = '321' OR s29.option_id = '322' OR s29.option_id = '323' OR s29.option_id = '324' OR s29.option_id = '325' OR s29.option_id = '326' OR s29.option_id = '327' OR s29.option_id = '328' OR s29.option_id = '329' OR s29.option_id = '330') AND (s31.option_id = '333' OR s31.option_id = '334' OR s31.option_id = '335' OR s31.option_id = '336' OR s31.option_id = '337' OR s31.option_id = '338' OR s31.option_id = '339' OR s31.option_id = '341' OR s31.option_id = '342') AND (s32.option_id = '348' OR s32.option_id = '350' OR s32.option_id = '351' OR s32.option_id = '352' OR s32.option_id = '353' OR s32.option_id = '354' OR s32.option_id = '355' OR s32.option_id = '356' OR s32.option_id = '357' OR s32.option_id = '358') AND (s33.option_id = '362' OR s33.option_id = '363' OR s33.option_id = '364' OR s33.option_id = '365' OR s33.option_id = '366' OR s33.option_id = '367' OR s33.option_id = '368' OR s33.option_id = '369' OR s33.option_id = '370' OR s33.option_id = '371') AND (s35.option_id = '372' OR s35.option_id = '373' OR s35.option_id = '374' OR s35.option_id = '375' OR s35.option_id = '449' OR s35.option_id = '450' OR s35.option_id = '567' OR s35.option_id = '568' OR s35.option_id = '569' OR s35.option_id = '571') AND (s38.option_id = '376' OR s38.option_id = '377' OR s38.option_id = '378' OR s38.option_id = '379' OR s38.option_id = '380' OR s38.option_id = '381' OR s38.option_id = '382' OR s38.option_id = '383' OR s38.option_id = '384' OR s38.option_id = '385') AND (s39.option_id = '386' OR s39.option_id = '387' OR s39.option_id = '388' OR s39.option_id = '389' OR s39.option_id = '390' OR s39.option_id = '391' OR s39.option_id = '392' OR s39.option_id = '393' OR s39.option_id = '394' OR s39.option_id = '395') AND (s40.option_id = '402' OR s40.option_id = '403' OR s40.option_id = '404' OR s40.option_id = '405' OR s40.option_id = '406' OR s40.option_id = '407' OR s40.option_id = '408' OR s40.option_id = '409' OR s40.option_id = '410' OR s40.option_id = '411') AND (s41.option_id = '413' OR s41.option_id = '414' OR s41.option_id = '415' OR s41.option_id = '416' OR s41.option_id = '417' OR s41.option_id = '418' OR s41.option_id = '419') AND (s42.option_id = '421' OR s42.option_id = '422' OR s42.option_id = '423' OR s42.option_id = '424' OR s42.option_id = '425' OR s42.option_id = '426' OR s42.option_id = '427' OR s42.option_id = '453' OR s42.option_id = '641' OR s42.option_id = '643') AND (s50.option_id = '496' OR s50.option_id = '497' OR s50.option_id = '498' OR s50.option_id = '499' OR s50.option_id = '500' OR s50.option_id = '501' OR s50.option_id = '502' OR s50.option_id = '503' OR s50.option_id = '504' OR s50.option_id = '505') AND (s51.option_id = '509' OR s51.option_id = '510' OR s51.option_id = '511' OR s51.option_id = '512' OR s51.option_id = '513' OR s51.option_id = '514' OR s51.option_id = '515' OR s51.option_id = '516' OR s51.option_id = '517' OR s51.option_id = '518') AND (s53.option_id = '538' OR s53.option_id = '539' OR s53.option_id = '540' OR s53.option_id = '541' OR s53.option_id = '542' OR s53.option_id = '543' OR s53.option_id = '544' OR s53.option_id = '545' OR s53.option_id = '546' OR s53.option_id = '547') AND (s55.option_id = '4152' OR s55.option_id = '4162' OR s55.option_id = '4172' OR s55.option_id = '4182' OR s55.option_id = '4192' OR s55.option_id = '4202' OR s55.option_id = '4212' OR s55.option_id = '4222' OR s55.option_id = '4232' OR s55.option_id = '4242') AND (s58.option_id = '605' OR s58.option_id = '606' OR s58.option_id = '607' OR s58.option_id = '608' OR s58.option_id = '609' OR s58.option_id = '610' OR s58.option_id = '611' OR s58.option_id = '612' OR s58.option_id = '613' OR s58.option_id = '614') AND (s60.option_id = '682' OR s60.option_id = '683') AND users.approved = '1' AND users.deleted = '0' and users.main_photo_id !=0 AND (users.latitude > 35.3239421622 AND users.latitude < 36.1938578378) AND (users.longitude > -79.3142578966 AND users.longitude < -78.2453421034) AND users.dob > '1957-03-19' AND users.dob < '1988-03-19' AND users.id != '1' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '1') AND users.id NOT IN (SELECT user_id FROM personal_definitions_attention) ORDER BY distance ASC LIMIT 500

Ovo sam dobio od coveka koji odrzava jedan server i koji kao i ja ne moze da se nacudi koji ludak moze ovo da napise. Hajde neko ako sme neka pusti ovaj query

Uh, nisam dobro pogledao query, taj query izgleda sada ovako:

SELECT u.id, u.membership, FLOOR((6371.0 * acos(sin(40.7519*0.01745329252) * sin(u.latitude*0.01745329252) + cos(40.7519*0.01745329252) * cos(u.latitude*0.01745329252) * cos((-73.9954*0.01745329252)-(u.longitude*0.01745329252)))) / 1.609344) as distance FROM users u INNER JOIN users_search us ON u.id = us.user_id WHERE u.id != 1 AND u.gender = 2 AND u.seeking = 3 AND u.approved = 1 AND u.deleted = 0 AND (u.latitude > -2.7438837837838 AND u.latitude < 84.247683783784) AND (u.longitude > -131.24672706316 AND u.longitude < -16.744072936839) AND u.dob > '1909-06-19' AND u.dob < '1991-06-19' AND u.id NOT IN (SELECT user_id FROM tier_2_users where u.id= tier_2_users.user_id) AND u.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '1') AND u.id NOT IN (SELECT user_id FROM personal_definitions_rejected) AND (us.z_39 LIKE '%|386|%' OR us.z_39 LIKE '%|387|%' OR us.z_39 LIKE '%|388|%' OR us.z_39 LIKE '%|389|%' OR us.z_39 LIKE '%|390|%' OR us.z_39 LIKE '%|391|%' OR us.z_39 LIKE '%|392|%' OR us.z_39 LIKE '%|393|%' OR us.z_39 LIKE '%|394|%' OR us.z_39 LIKE '%|395|%' OR us.z_39 LIKE '%|396|%' OR us.z_39 LIKE '%|397|%' OR us.z_39 LIKE '%|398|%' OR us.z_39 LIKE '%|399|%' OR us.z_39 LIKE '%|400|%' OR us.z_39 LIKE '%|401|%' OR us.z_39 LIKE '%|486|%' OR us.z_39 LIKE '%|487|%' OR us.z_39 LIKE '%|664|%') AND (us.z_9 = 137 OR us.z_9 = 138 OR us.z_9 = 139 OR us.z_9 = 140 OR us.z_9 = 141 OR us.z_9 = 142 OR us.z_9 = 433 OR us.z_9 = 434 OR us.z_9 = 481 OR us.z_9 = 482 OR us.z_9 = 483 OR us.z_9 = 490) AND (us.z_12 = 214 OR us.z_12 = 215 OR us.z_12 = 216 OR us.z_12 = 217 OR us.z_12 = 218 OR us.z_12 = 220) AND (us.z_13 LIKE '%|221|%' OR us.z_13 LIKE '%|222|%' OR us.z_13 LIKE '%|223|%' OR us.z_13 LIKE '%|224|%' OR us.z_13 LIKE '%|225|%' OR us.z_13 LIKE '%|226|%' OR us.z_13 LIKE '%|227|%' OR us.z_13 LIKE '%|429|%' OR us.z_13 LIKE '%|435|%' OR us.z_13 LIKE '%|495|%') AND (us.z_14 = 228 OR us.z_14 = 229 OR us.z_14 = 230 OR us.z_14 = 231 OR us.z_14 = 488 OR us.z_14 = 489 OR us.z_14 = 646) AND (us.z_15 = 232 OR us.z_15 = 233 OR us.z_15 = 234 OR us.z_15 = 645) AND (us.z_16 = 238 OR us.z_16 = 239 OR us.z_16 = 240) AND (us.z_50 = 496 OR us.z_50 = 497 OR us.z_50 = 498 OR us.z_50 = 499 OR us.z_50 = 500 OR us.z_50 = 501 OR us.z_50 = 502 OR us.z_50 = 503 OR us.z_50 = 504 OR us.z_50 = 505 OR us.z_50 = 506 OR us.z_50 = 507 OR us.z_50 = 508) AND (us.z_51 LIKE '%|509|%' OR us.z_51 LIKE '%|510|%' OR us.z_51 LIKE '%|511|%' OR us.z_51 LIKE '%|512|%' OR us.z_51 LIKE '%|513|%' OR us.z_51 LIKE '%|514|%' OR us.z_51 LIKE '%|515|%' OR us.z_51 LIKE '%|516|%' OR us.z_51 LIKE '%|517|%' OR us.z_51 LIKE '%|518|%' OR us.z_51 LIKE '%|519|%' OR us.z_51 LIKE '%|647|%') AND (us.z_60 = 682 OR us.z_60 = 683) AND (us.z_17 = 242 OR us.z_17 = 243 OR us.z_17 = 244 OR us.z_17 = 245 OR us.z_17 = 246 OR us.z_17 = 436) AND (us.z_18 = 248 OR us.z_18 = 249 OR us.z_18 = 250 OR us.z_18 = 251 OR us.z_18 = 252 OR us.z_18 = 253 OR us.z_18 = 254 OR us.z_18 = 437) AND (us.z_19 = 256 OR us.z_19 = 257 OR us.z_19 = 258 OR us.z_19 = 259 OR us.z_19 = 260 OR us.z_19 = 261 OR us.z_19 = 262 OR us.z_19 = 263 OR us.z_19 = 264 OR us.z_19 = 265 OR us.z_19 = 266 OR us.z_19 = 267 OR us.z_19 = 268 OR us.z_19 = 269 OR us.z_19 = 270 OR us.z_19 = 271 OR us.z_19 = 272 OR us.z_19 = 273 OR us.z_19 = 274 OR us.z_19 = 553 OR us.z_19 = 554 OR us.z_19 = 555) AND (us.z_21 = 276 OR us.z_21 = 277 OR us.z_21 = 278 OR us.z_21 = 279 OR us.z_21 = 280 OR us.z_21 = 281) AND (us.z_22 = 285 OR us.z_22 = 286 OR us.z_22 = 287 OR us.z_22 = 288 OR us.z_22 = 492 OR us.z_22 = 493 OR us.z_22 = 494) AND (us.z_23 = 290 OR us.z_23 = 291 OR us.z_23 = 292 OR us.z_23 = 491 OR us.z_23 = 663) AND (us.z_24 LIKE '%|294|%' OR us.z_24 LIKE '%|295|%' OR us.z_24 LIKE '%|296|%' OR us.z_24 LIKE '%|297|%' OR us.z_24 LIKE '%|298|%') AND (us.z_25 = 299 OR us.z_25 = 300 OR us.z_25 = 301 OR us.z_25 = 302 OR us.z_25 = 454 OR us.z_25 = 455) AND (us.z_27 LIKE '%|312|%' OR us.z_27 LIKE '%|313|%' OR us.z_27 LIKE '%|314|%' OR us.z_27 LIKE '%|315|%' OR us.z_27 LIKE '%|316|%' OR us.z_27 LIKE '%|317|%' OR us.z_27 LIKE '%|318|%' OR us.z_27 LIKE '%|319|%' OR us.z_27 LIKE '%|320|%' OR us.z_27 LIKE '%|344|%' OR us.z_27 LIKE '%|345|%' OR us.z_27 LIKE '%|346|%' OR us.z_27 LIKE '%|347|%') AND (us.z_29 LIKE '%|321|%' OR us.z_29 LIKE '%|322|%' OR us.z_29 LIKE '%|323|%' OR us.z_29 LIKE '%|324|%' OR us.z_29 LIKE '%|325|%' OR us.z_29 LIKE '%|326|%' OR us.z_29 LIKE '%|327|%' OR us.z_29 LIKE '%|328|%' OR us.z_29 LIKE '%|329|%' OR us.z_29 LIKE '%|330|%' OR us.z_29 LIKE '%|331|%' OR us.z_29 LIKE '%|332|%' OR us.z_29 LIKE '%|456|%') AND (us.z_33 LIKE '%|362|%' OR us.z_33 LIKE '%|363|%' OR us.z_33 LIKE '%|364|%' OR us.z_33 LIKE '%|365|%' OR us.z_33 LIKE '%|366|%' OR us.z_33 LIKE '%|367|%' OR us.z_33 LIKE '%|368|%' OR us.z_33 LIKE '%|369|%' OR us.z_33 LIKE '%|370|%' OR us.z_33 LIKE '%|371|%' OR us.z_33 LIKE '%|648|%' OR us.z_33 LIKE '%|649|%' OR us.z_33 LIKE '%|650|%' OR us.z_33 LIKE '%|651|%' OR us.z_33 LIKE '%|652|%' OR us.z_33 LIKE '%|653|%' OR us.z_33 LIKE '%|654|%' OR us.z_33 LIKE '%|655|%' OR us.z_33 LIKE '%|656|%' OR us.z_33 LIKE '%|657|%' OR us.z_33 LIKE '%|658|%' OR us.z_33 LIKE '%|661|%') AND (us.z_58 LIKE '%|605|%' OR us.z_58 LIKE '%|606|%' OR us.z_58 LIKE '%|607|%' OR us.z_58 LIKE '%|608|%' OR us.z_58 LIKE '%|609|%' OR us.z_58 LIKE '%|610|%' OR us.z_58 LIKE '%|611|%' OR us.z_58 LIKE '%|612|%' OR us.z_58 LIKE '%|613|%' OR us.z_58 LIKE '%|614|%' OR us.z_58 LIKE '%|615|%' OR us.z_58 LIKE '%|616|%' OR us.z_58 LIKE '%|617|%' OR us.z_58 LIKE '%|618|%' OR us.z_58 LIKE '%|619|%' OR us.z_58 LIKE '%|620|%' OR us.z_58 LIKE '%|621|%' OR us.z_58 LIKE '%|622|%' OR us.z_58 LIKE '%|623|%' OR us.z_58 LIKE '%|624|%' OR us.z_58 LIKE '%|625|%' OR us.z_58 LIKE '%|627|%' OR us.z_58 LIKE '%|628|%' OR us.z_58 LIKE '%|630|%' OR us.z_58 LIKE '%|631|%' OR us.z_58 LIKE '%|632|%' OR us.z_58 LIKE '%|633|%' OR us.z_58 LIKE '%|634|%' OR us.z_58 LIKE '%|635|%' OR us.z_58 LIKE '%|636|%' OR us.z_58 LIKE '%|637|%' OR us.z_58 LIKE '%|639|%' OR us.z_58 LIKE '%|640|%') AND (us.z_31 LIKE '%|333|%' OR us.z_31 LIKE '%|334|%' OR us.z_31 LIKE '%|335|%' OR us.z_31 LIKE '%|336|%' OR us.z_31 LIKE '%|337|%' OR us.z_31 LIKE '%|338|%' OR us.z_31 LIKE '%|339|%' OR us.z_31 LIKE '%|341|%' OR us.z_31 LIKE '%|342|%' OR us.z_31 LIKE '%|343|%' OR us.z_31 LIKE '%|447|%' OR us.z_31 LIKE '%|448|%' OR us.z_31 LIKE '%|659|%' OR us.z_31 LIKE '%|660|%') AND (us.z_32 LIKE '%|348|%' OR us.z_32 LIKE '%|350|%' OR us.z_32 LIKE '%|351|%' OR us.z_32 LIKE '%|352|%' OR us.z_32 LIKE '%|353|%' OR us.z_32 LIKE '%|354|%' OR us.z_32 LIKE '%|355|%' OR us.z_32 LIKE '%|356|%' OR us.z_32 LIKE '%|357|%' OR us.z_32 LIKE '%|358|%' OR us.z_32 LIKE '%|360|%' OR us.z_32 LIKE '%|361|%' OR us.z_32 LIKE '%|438|%' OR us.z_32 LIKE '%|439|%' OR us.z_32 LIKE '%|440|%' OR us.z_32 LIKE '%|441|%' OR us.z_32 LIKE '%|442|%' OR us.z_32 LIKE '%|443|%' OR us.z_32 LIKE '%|444|%' OR us.z_32 LIKE '%|445|%' OR us.z_32 LIKE '%|446|%' OR us.z_32 LIKE '%|595|%' OR us.z_32 LIKE '%|596|%' OR us.z_32 LIKE '%|597|%' OR us.z_32 LIKE '%|598|%' OR us.z_32 LIKE '%|599|%' OR us.z_32 LIKE '%|600|%' OR us.z_32 LIKE '%|702|%') AND (us.z_35 LIKE '%|372|%' OR us.z_35 LIKE '%|373|%' OR us.z_35 LIKE '%|374|%' OR us.z_35 LIKE '%|375|%' OR us.z_35 LIKE '%|449|%' OR us.z_35 LIKE '%|450|%' OR us.z_35 LIKE '%|567|%' OR us.z_35 LIKE '%|568|%' OR us.z_35 LIKE '%|569|%' OR us.z_35 LIKE '%|571|%' OR us.z_35 LIKE '%|572|%' OR us.z_35 LIKE '%|573|%' OR us.z_35 LIKE '%|584|%' OR us.z_35 LIKE '%|585|%' OR us.z_35 LIKE '%|586|%' OR us.z_35 LIKE '%|588|%' OR us.z_35 LIKE '%|589|%' OR us.z_35 LIKE '%|590|%') AND (us.z_38 LIKE '%|376|%' OR us.z_38 LIKE '%|377|%' OR us.z_38 LIKE '%|378|%' OR us.z_38 LIKE '%|379|%' OR us.z_38 LIKE '%|380|%' OR us.z_38 LIKE '%|381|%' OR us.z_38 LIKE '%|382|%' OR us.z_38 LIKE '%|383|%' OR us.z_38 LIKE '%|384|%' OR us.z_38 LIKE '%|385|%' OR us.z_38 LIKE '%|452|%') AND (us.z_40 = 402 OR us.z_40 = 403 OR us.z_40 = 404 OR us.z_40 = 405 OR us.z_40 = 406 OR us.z_40 = 407 OR us.z_40 = 408 OR us.z_40 = 409 OR us.z_40 = 410 OR us.z_40 = 411 OR us.z_40 = 556 OR us.z_40 = 559 OR us.z_40 = 692) AND (us.z_41 = 413 OR us.z_41 = 414 OR us.z_41 = 415 OR us.z_41 = 416 OR us.z_41 = 417 OR us.z_41 = 418 OR us.z_41 = 419) AND (us.z_42 = 421 OR us.z_42 = 422 OR us.z_42 = 423 OR us.z_42 = 424 OR us.z_42 = 425 OR us.z_42 = 426 OR us.z_42 = 427 OR us.z_42 = 453 OR us.z_42 = 641 OR us.z_42 = 643 OR us.z_42 = 644 OR us.z_42 = 662 OR us.z_42 = 665) AND (us.z_53 LIKE '%|538|%' OR us.z_53 LIKE '%|539|%' OR us.z_53 LIKE '%|540|%' OR us.z_53 LIKE '%|541|%' OR us.z_53 LIKE '%|542|%' OR us.z_53 LIKE '%|543|%' OR us.z_53 LIKE '%|544|%' OR us.z_53 LIKE '%|545|%' OR us.z_53 LIKE '%|546|%' OR us.z_53 LIKE '%|547|%' OR us.z_53 LIKE '%|548|%' OR us.z_53 LIKE '%|549|%' OR us.z_53 LIKE '%|550|%' OR us.z_53 LIKE '%|551|%' OR us.z_53 LIKE '%|560|%') AND (us.z_55 LIKE '%|561|%' OR us.z_55 LIKE '%|562|%' OR us.z_55 LIKE '%|563|%' OR us.z_55 LIKE '%|564|%' OR us.z_55 LIKE '%|565|%') ORDER BY distance ASC, u.membership DESC LIMIT 500

Ne znam ko ga je pravio sa onih 30-ak joina.
Ne znam ko ga je pravio, mozda i boss himself, ne znam da li je dobio otkaz

.
Posle su dali meni da napravim to da radi sa 100+ opcija i to tako sljaka odavno.
z_xx tabele sam denormalizovao, mozete zamisliti koliko je trebalo vremena za 50+ baza i 4+ miliona korisnika.

Ako kazete opet da nisam normalan, bacicu se sa terase (doduse nisam visoko).
Hajde sada, opalite (ali mooolim konstruktivno).

bluesman · 19. 06. 2009.

Pa kako, bre, konstruktivno kada ne može živ čovek da provali šta je šta

Ovde očigledno treba drugačija struktura baze ako ovo baš mora da se izvršava.

dukacar · 19. 06. 2009.

Citat:

Originalno napisao bluesman

Pa kako, bre, konstruktivno kada ne može živ čovek da provali šta je šta

Ovde očigledno treba drugačija struktura baze ako ovo baš mora da se izvršava.

Znam, znam...ali verujem da sam i samim postovanjem prekrsio nekoliko stavki u ugovoru, jos kada bi opsao sve ovako javno, stvarno bih dobio otkaz (a mozda i batine

).
Nisam siguran da smem cak i preko private.

jablan · 19. 06. 2009.

Citat:

Originalno napisao dukacar

Znam, znam...ali verujem da sam i samim postovanjem prekrsio nekoliko stavki u ugovoru,

Zipa da ti neko ne mazne query...

bluesman · 08. 07. 2009.

Evo još jedan query za analizu

Citat:

| 77990524 | jsingles | 192.168.0.79:54998 | dateacougar | Query | 2 | Sending data | (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3060982' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3060982') ORDER BY photos.id
LIMIT 1
) |
| 77990536 | jsingles | 192.168.0.77:49511 | dateacougar | Query | 0 | Sending data | (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user_id = '3339312') ORDER BY photos.id
LIMIT 1
) UNION ALL (SELECT photos.id
FROM photos
INNER JOIN users ON photos.user_id = users.id
JOIN
(SELECT (RAND() *
(SELECT MAX(id)
FROM photos)) AS id) AS tmp
WHERE
photos.id >= tmp.id
AND photos.gallery = '0' AND photos.porn = '0' AND photos.approved = '1'
AND photos.public = '1' AND photos.deleted = '0' AND users.deleted = '0' AND users.gender = '1201' AND users.id != '3339312' AND users.id NOT IN (SELECT blocked_user_id FROM blocked WHERE user

kao što vidite, query se prekida kod ... "WHERE user" jer gtalk buffer ne može da primi ceo tekst

robi-bobi · 08. 07. 2009.

vi to ozbiljno???

misk0 · 08. 07. 2009.

Cekaj jbte.. hoces reci da je neko napisao ovaj query? Mislim rucno?? Ne vjerujemmmmm ja sam nakon 10 redova izgubio pojam sta on hoce...

jablan · 08. 07. 2009.

Nema šanse da je ručno, nego mu treba N random slika iz baze i on je nalepio N upita za dovlačenje jedne random slike.

bluesman · 08. 07. 2009.

Mislim da je situacija slična kao do sada - ovo može biti samo neki auto generisani query, ovo živ čovek ne može da napiše u ovom obliku a da se prethodno nije nagutao magic mushrooms

18. 06. 2009.	#61
Aleksandar.Ilic old school Expert Datum učlanjenja: 29.04.2006 Poruke: 464 Hvala: 39 48 "Hvala" u 28 poruka	btw, sada sam skontao da je ovaj prvi explain koji sam ja radio da bih shvatio sta fali upitu :S __________________ Vesti sa juga --- BizBuzz --- Vas mali oglas

19. 06. 2009.	#63
bluesman Goran Pilipović Sir Write-a-Lot Datum učlanjenja: 18.05.2005 Lokacija: Beograd Poruke: 5.450 Hvala: 288 1.247 "Hvala" u 446 poruka	Pa kako, bre, konstruktivno kada ne može živ čovek da provali šta je šta Ovde očigledno treba drugačija struktura baze ako ovo baš mora da se izvršava. __________________ Goran Pilipović a.k.a. Ugly Fingers Bradley f.k.a. bluesman I don't always know what I'm talking about but I know I'm right!

08. 07. 2009.	#70
bluesman Goran Pilipović Sir Write-a-Lot Datum učlanjenja: 18.05.2005 Lokacija: Beograd Poruke: 5.450 Hvala: 288 1.247 "Hvala" u 446 poruka	Mislim da je situacija slična kao do sada - ovo može biti samo neki auto generisani query, ovo živ čovek ne može da napiše u ovom obliku a da se prethodno nije nagutao magic mushrooms __________________ Goran Pilipović a.k.a. Ugly Fingers Bradley f.k.a. bluesman I don't always know what I'm talking about but I know I'm right!

Alati teme
Pogledajte verziju za štampanje Pošaljite email-om ovu stranu
Način prikaza
Linearni prikaz Prebacite u hibridni prikaz Prebacite u prikaz po temama

Slične teme
Tema	Početna poruka teme	Forum	Odgovori	Poslednja poruka
Najgori hosting provajderi	ljtruba	Web Hosting, web serveri i operativni sistemi	144	01. 10. 2011. 21:56
spor query	ivanhoe	SQL baze podataka - Sponzor: Baze-Podataka.net	1	31. 07. 2007. 19:47
sql query	bluesman	SQL baze podataka - Sponzor: Baze-Podataka.net	19	18. 04. 2007. 07:47

08. 07. 2009.	#67
robi-bobi expert Grand Master Datum učlanjenja: 05.10.2005 Lokacija: Sofia, Bulgaria Poruke: 805 Hvala: 222 958 "Hvala" u 68 poruka	vi to ozbiljno???

08. 07. 2009.	#68
misk0 majstor Wrote a book Datum učlanjenja: 30.01.2006 Lokacija: Lugano - Switzerland Poruke: 1.251 Hvala: 219 106 "Hvala" u 67 poruka	Cekaj jbte.. hoces reci da je neko napisao ovaj query? Mislim rucno?? Ne vjerujemmmmm ja sam nakon 10 redova izgubio pojam sta on hoce...

08. 07. 2009.	#69
jablan VD IT Direktora Invented the damn thing Datum učlanjenja: 08.06.2005 Lokacija: Beograd Poruke: 2.118 Hvala: 503 1.307 "Hvala" u 282 poruka	Nema šanse da je ručno, nego mu treba N random slika iz baze i on je nalepio N upita za dovlačenje jedne random slike.