Kurs Oracle SQL online. Sortowanie rekordów

W tej lekcji kursu Oracle SQL zaczniemy sortować rekordy w wyniku działania zapytania.

Jeśli chcesz posortować rekordy należy użyć klauzuli ORDER BY. Zatem do dzieła 🙂

Przykład1. Wyświetl pracowników sortując wynik po nazwiskach i imionach rosnąco.

SELECT *
FROM employees
ORDER BY last_name, first_name;

Dla rekordów z takimi samymi wartościami w kolumnie last_name, sortowanie nastąpi w oparciu o zawartość kolumny first_name. W naszym przypadku jest tak dla pracowników o nazwisku Grant – ponieważ były te same wartości w kolumnie nazwiska sortowanie tych rekordów nastąpiło z wykorzystaniem kolumny imię.

Sortowanie może być:

  • Rosnące: ORDER BY kolumna =  ORDER BY kolumna ASC
  • Malejące: ORDER BY kolumna DESC

Przykład 2. Wyświetl pracowników sortując wynik po nazwiskach malejąco, a dla tych samych nazwisk po imionach rosnąco.

SELECT *
FROM employees
ORDER BY last_name DESC, first_name;

Kolumny do sortowania można wskazywać używając:

  • Nazwy kolumny
  • Aliasu kolumny
  • Numeru kolumny w zapytaniu

SELECT first_name imie,
last_name nazwisko,
salary pensja
FROM employees;

Przykład 3. Zmodyfikuj powyższe zapytanie tak, aby wynik posortować po nazwiskach rosnąco, a dla tych samych nazwisk po imionach malejąco – korzystając z nazw kolumn

SELECT first_name imie,
       last_name nazwisko,
       salary pensja
FROM employees
ORDER BY last_name, first_name DESC;

Przykład 4. Zmodyfikuj powyższe zapytanie tak, aby wynik posortować po nazwiskach rosnąco, a dla tych samych nazwisk po imionach malejąco – korzystając z aliasów kolumn

SELECT first_name imie,
       last_name nazwisko,
       salary pensja
FROM employees
ORDER BY nazwisko, imie DESC;

Przykład 5. Zmodyfikuj powyższe zapytanie tak, aby wynik posortować po nazwiskach rosnąco, a dla tych samych nazwisk po imionach malejąco – korzystając z numerów kolumn w zapytaniu

SELECT first_name imie,
       last_name nazwisko,
       salary pensja
FROM employees
ORDER BY 2, 1 DESC;

W kolejnej lekcji poznasz najważniejsze wbudowane funkcje. Czyli m.in. jak wybierać inicjały z imion i nazwisk, jak zaokrąglać kwoty. Zapraszam!

 

 

 

This entry was posted in Oracle SQL, Oracle SQL Podstawy, SQL and tagged , , , , . Bookmark the permalink.

3 Responses to Kurs Oracle SQL online. Sortowanie rekordów

  1. adderek says:

    Ja bym jeszcze dodał, że operacja sortowania nie zwróci nam żadnych wyników dopóki Oracle nie posortuje wszystkich wierszy.
    Jest to ważne np. w serwisach WWW które mają zaprezentować wynik zapytania jak najszybciej (np. listę produktów).

    Przykład:
    Wyobraźmy sobie wielki magazyn z tysiącami paczek.
    Mogę komuś zlecić podanie mi pierwszej z brzegu paczki – dostanę ją szybko ale nie wiem z jaką zawartością.
    Mogę zlecić wyszukanie konkretnej paczki – co potrwa zapewne dłużej.
    A co gdybym polecił posortowanie paczke względem rozmiarów i podanie 10 najmniejszych? Tak właśnie działa ORDER BY.

    I jeszcze słówko wstępu do zaawansowanych tematów Oracle:
    (1) Pół biedy jeśli ktoś już paczki zmierzył i przegląda segregator. (2) Jeśli ktoś na dolnych półkach ułoży duże paczki a na górnych małe to też troszkę zyskamy (nie trzeba przeglądać wszystkich paczek). (3) Gorzej gdy każdą paczkę trzeba z osobna dopiero zmierzyć.
    Opcja (1) to indexy. Opcja (2) to partycjonowanie. Opcja (3) to full table scan.

  2. darek says:

    Przydałoby się jeszcze pokazać sortowanie według wyniku działania funkcji, np.;
    SELECT last_name, phone_number
    FROM employees
    ORDER BY SUBSTR(phone_number, 5, 3);

    a może nawet sortowanie według wartości kolumny z innej tabeli 🙂

    • Rafał Stryjek says:

      Sortowanie po wyniku funkcji to ważne tematy.. Zostawiam je na kurs dla zaawansowanych.. tak jak i NULLS FIRST .. 🙂

  3. SARAkit says:
    Your comment is awaiting moderation.

    my campus
    Map usa new jersey & Video
    United States Map Map usa new jersey United States Of America United States Of America’s Information US HISTORY America’s initial Stone Age inhabitants arrived here by traversing the Bering Strait. During the following centuries, a wide variety of Indian cultures developed and prospered across the land. After Columbus made his initial voyage to this New World, word of its potential riches spread across Europe, and explorers and settlers by the thousands soon stepped ashore along the Atlantic Ocean coastline. In 1620, the Pilgrims arrived on the Mayflower, landing in what is modern-day Massachusetts; their settlement named Plymouth survived, and the …
    The post Map usa new jersey & Video appeared first on Credit.

    Hawai Business
    Site
    webopedia
    thank you for inviting me to interview
    voytas
    rentar

    TOP 250 FREE DOFOLLOW SITE LINK LIST

    http://loadinfo.ru/forum/topic_2/13519#post-890030
    http://t1.xianlaiju.com/space-uid-1617651.html
    http://www.tylorprudhomme.com/forums/topic/ecological-census-techniques-a-handbook-pdf-epub-mobi/page/3/#post-724869/
    http://poznanie.com.ua/forum/forum4/topic182839/message779846/?sessid=030c9a0ae4f2b50502aff99d58ed94fe&TOPIC_SUBSCRIBE=Y&result=new
    http://poznanie.com.ua/forum/forum4/topic15174/message783341/?result=reply#message783341
    http://www.tinder.space/showthread.php?tid=15&pid=111#pid111
    http://poznanie.com.ua/forum/forum4/topic12467/message744602/
    health.remmont.com
    http://forum.remmont.com/who-is-better-for-the-world-china-russia-or-the-usa/#comment/
    http://poznanie.com.ua/forum/forum4/topic178408/message755182/?sessid=1742c651f707b12ae6e4d9e31c652879&TOPIC_SUBSCRIBE=Y&result=new
    http://dailyuganda.com/comment/reply/12724/3247/
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message799131/
    http://sinsport.ru/2018/08/22/vashington-ovechkina-vnov-pobedil-tampu-bej-v-finale-vostochnoj-konferentsii-nhl/?unapproved=957&moderation-hash=84470a0e8d37a2f1097ee6362a772b23#comment-957
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message798691/
    http://forum.allinallonlinejobs.com/memberlist.php?mode=searchuser&sd=a&sk=m#
    http://poznanie.com.ua/forum/forum4/topic15174/message771930/?result=reply#message771930
    http://thetelecomtimes.com/mef-certifies-pccw-global-worlds-first-mef-100g-ce-2-0-service-provider.html?unapproved=7785&moderation-hash=e34d0ce900ec42f1cc616d999cdbbca7#comment-7785
    http://xymym.com/forum.php?mod=viewthread&tid=347755
    http://www.greekhealthylife.org/food-matters/?unapproved=3451&moderation-hash=47d2d31d0fa3948ef429de92785dd273#comment-3451
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message797925/
    http://poznanie.com.ua/forum/forum4/topic181915/message775766/?sessid=b052699f00abd337b9e6ff1cda900302&TOPIC_SUBSCRIBE=Y&result=new
    http://xn--cba7b0gh41v004e.lohasmassage.com/viewthread.php?tid=92283&extra=
    http://poznanie.com.ua/forum/forum4/topic9764/message771885/?result=reply#message771885
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message798591/
    http://qyisi.com/home.php?mod=space&uid=33186
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message798855/
    http://zakon.zsperm.ru/forum/messages/forum1/topic3/message8/
    http://my.websjy.com/space-uid-348723.html
    http://poznanie.com.ua/forum/forum4/topic15174/message744652/
    http://dailyuganda.com/node/12787#comment-5730/
    http://kvadratremont.ru/forum/messages/forum/8/message13561/49-pochemu-otkleivayutsya-oboi?result=reply#message13561
    http://bbs23.hcwang.cn/home.php?mod=space&uid=14830792&do=profile&from=space
    http://manmanqi.com/home.php?mod=space&uid=11527
    http://kubanregion.com/boards/topic/1132/news-energy-news-current-news-remmontcom
    http://trnavaobfz.sk/predstavujeme-ucastnikov-viii-ligy-select/?unapproved=4476&moderation-hash=6a3e20cf0d2c9ccc8a08007608dd8ac1#comment-4476
    http://poznanie.com.ua/forum/forum4/topic12467/message780516/?result=reply#message780516
    http://dailyuganda.com/comment/reply/12724/5303/
    http://yxptdz.com/forum.php?mod=viewthread&tid=4850327
    http://5118.in/space-uid-23923.html
    alabama.remmont.com/wp-admin/index.php
    http://www.defineyolu.net/index.php?topic=821.0
    http://poznanie.com.ua/forum/forum4/topic181889/message775530/?sessid=e744adee932f5452dbe0d23cd154cf2a&TOPIC_SUBSCRIBE=Y&result=new
    http://invex.cn/home.php?mod=space&uid=918811
    http://www.vintageclassicmovies.com/2015/06/10/another-post/?unapproved=1571&moderation-hash=f79a4b93afd0899a5798fbbbba85f90c#comment-1571
    http://fablero.ucoz.ru/index/8-145351
    http://dailyuganda.com/node/12722#comment-5778/
    http://lucindacross.com/visionboardkit/past-vision-board-events/?unapproved=405932&moderation-hash=86c2eef2672483140a4c75c7d6336069#comment-405932
    http://zakon.zsperm.ru/forum/messages/forum1/topic3/message12/
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message799330/
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message799381/
    http://wirednewyork.com/forum/member.php?u=1067898
    http://forums.spry.com/member.php?475441-SHALOMNami
    http://poznanie.com.ua/forum/forum4/topic15174/message737828/
    http://poznanie.com.ua/forum/forum4/topic183334/message781143/?sessid=c6a5f35b3833d4d578f6ea984f9ec78c&TOPIC_SUBSCRIBE=Y&result=new
    http://dburn.ru/users/REMONTPoef
    http://edww.hz-nano.com/viewthread.php?tid=81695&extra=
    http://bio.mdu.edu.ua/index.php?subaction=userinfo&user=REMONTHaup
    http://poznanie.com.ua/forum/forum4/topic15174/message755795/?result=reply#message755795
    http://xn--jekv69lfrab734k859c.tailien.com/post.php?action=reply&fid=2&tid=1377012
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message798770/
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message798650/
    http://blog.iccadubai.ae/flame-up-love-valentine/?unapproved=44061&moderation-hash=6953f2e3924a84c0a6c1d1065b22d848#comment-44061
    http://poznanie.com.ua/forum/forum4/topic9764/message755868/?result=reply#message755868
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message799315/
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message798996/
    http://poznanie.com.ua/forum/forum4/topic15174/message781533/?result=reply#message781533
    http://poznanie.com.ua/forum/forum4/topic12467/message776204/
    http://gursharansinghtrust.org/discussion/topic/news-oklahoma-city-finance-daily-news-remmont-com/#postid-210601
    http://www.simplypets.com/portuguese-water-dogs-breeders/?unapproved=3828&moderation-hash=0f1160c0d716803b9df5b3b5fa848d30#comment-3828
    http://poznanie.com.ua/forum/forum4/topic9764/message781779/?result=reply#message781779
    http://poznanie.com.ua/forum/forum4/topic12467/message772066/?result=reply#message772066
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message772263/
    http://creatura.co/post-title-1/?unapproved=66276&moderation-hash=410cc4da96ea8e6a56dedf4262bab2cf#comment-66276
    http://poznanie.com.ua/forum/forum4/topic9764/message776092/?result=reply#message776092
    http://poznanie.com.ua/forum/forum4/topic15174/message756170/?result=reply#message756170
    http://poznanie.com.ua/forum/forum4/topic9764/message775762/?result=reply#message775762
    http://poznanie.com.ua/forum/forum4/topic12467/message743783/
    http://ranetki-eburg.ucoz.ru/forum/9-75-15#1670
    http://poznanie.com.ua/forum/forum4/topic12467/message781276/?result=reply#message781276
    http://forum.remmont.com/prominent-fsa-commander-return-from-jordan-and-join-reconciliation-process-in-southern-syria/#comment/
    http://www.bizweb.ru/topic/3807-chto-prodavat-na-rynke/page-3#entry171035/
    http://www.myforumserver.de/turk-amator-resimler-turkish-amateur-pictures/142-analytics-illinois-finance-current-news-remmont-com.html#post1451
    http://poznanie.com.ua/forum/forum4/topic12467/message755155/?result=reply#message755155
    http://youdoenglish.ru/posts/7594-analytics-usa-business-fresh-news-nef6-com.html
    http://poznanie.com.ua/forum/forum4/topic181537/message773036/?sessid=7fef10e3bbd3fd47508395b51f78e06a&TOPIC_SUBSCRIBE=Y&result=new
    http://igo.gain.tw/viewthread.php?tid=435495&extra=
    http://poznanie.com.ua/forum/forum4/topic12467/message748208/?result=reply#message748208
    http://dailyuganda.com/comment/reply/11834/3671/
    http://poznanie.com.ua/forum/forum4/topic9764/message795475/?result=reply#message795475
    http://poznanie.com.ua/forum/forum4/topic15174/message795859/?result=reply#message795859
    http://forum.cowboylyrics.com/member.php?1443046-SHALOMTide
    http://poznanie.com.ua/forum/forum4/topic12467/message762082/?result=reply#message762082
    http://poznanie.com.ua/forum/forum4/topic15174/message780000/?result=reply#message780000
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message799151/
    el-paso.remmont.com
    http://poznanie.com.ua/forum/forum4/topic12467/message740005/?result=reply#message740005
    http://dailyuganda.com/comment/reply/12578/2720
    http://kids-charas.forumprofi.de/
    http://forum.polska.ru/index.php
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message798840/
    http://poznanie.com.ua/forum/forum4/topic9764/message742708/
    http://poznanie.com.ua/forum/forum4/topic12467/message760332/
    http://xn--iba5a17rhaao8rkr795r0baus40c.chin-shan.com/viewthread.php?tid=68346&extra=
    http://www.combatserver.com/forums/index.php?topic=108071.new#new
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message799242/
    http://dailyuganda.com/comment/reply/12840/6032/
    charlotte.remmont.com/wp-admin/index.php
    http://bbs.mcrst.com/home.php?mod=space&uid=34261
    http://poznanie.com.ua/forum/forum4/topic9764/message742801/
    http://www.mest100.ru/users/userprofile/REMONTCag.html?task_tmp
    http://dailyuganda.com/node/12787#comment-5647/
    http://www.egeteka.ru/auth/index.php
    http://www.floridasports.club/wp-admin/edit.php?post_title=Details%3A+China+Business+Fresh+News.+http%3A%2F%2Freal-estate.nef2.com&post_name=NEF2mafe&mm=10&jj=24&aa=2018&hh=03&mn=NEF2mafe&ss=49&post_category=0&tax_inputtag%5D=%5BIMG%5Dhttp%3A%2F%2Fremmont.com%2Fdemotivator%2F2326.jpg+border%3D10+height%3D240+width%3D240%5B%2FIMG%5D+%5Bb%5DPolitics+of+Russia+We+n+we+publish+all+of+them+fresh+and+advanced+facts+World%2C+analytics+experts.+All+evil+in+the+world+is+created+with+the+quiet+tacit+consent+of+the+indifferent.+No+one+provides+us+with+incentives.+We+are+People.+We+are+building+a+civil+society.+The+people+are+the+bearer+of+sovereignty+and+the+only+source+of+power.+No+one+can+usurp+power.+Useful+topics+-+NATO+%5Burl%3Dhttp%3A%2F%2Fwww.real-estate.nef2.com%5DUganda+Business%5B%2Furl%5D+%5Burl%3Dhttp%3A%2F%2Fgame.remmont.com%2Fgamez-eoin-gamez-games-free-free%2F%5D+eoin+gamez+%5B%2Furl%5D%5Burl%3Dhttp%3A%2F%2Freply.remmont.com%2Furban-dictionary-cheers-big-ears-dictionary-free%2F%5D+cheers+big+ears+same+goes+big+nose+%5B%2Furl%5D+%5Burl%3Dhttp%3A%2F%2Fbusiness.nef2.com%2Fva-once-student-login-page-u-reservist-army-reserve-naval-reserve-air-force-reserve-marine-corps-reserve-coast-guard-reserve-army-national-reserve-air-national-reserve-va%2F%5D+va+once+school+login+%5B%2Furl%5D%5Burl%3Dhttp%3A%2F%2Fnef2.com%2Fnorth-carolina-real-estate-school-nc-real-estate-courses-tampa-bay-real-estate%2F%5D+jy+monk+real+estate+training+center+%5B%2Furl%5D+%5Burl%3Dhttp%3A%2F%2Fpharma.nef6.com%2F2018%2F07%2F14%2Faurobindo-pharma-share-price-pharma-tech-pharma-tech-2%2F%5D+aurobindo+share+price+%5B%2Furl%5D&_status=pending&_inline_edit=0de2b9c4ae&post_view=list&screen=edit-post&comment_status=closed&ping_status=closed&_status=draft&post_format=image&bulk_edit=Update&post_view=list&screen=edit-post
    http://blog.gaydar.net/new-year-weve-given-gaydar-fresh-new-look/?unapproved=1425&moderation-hash=743c2b9172f5e360061b0ced98f3ed49#comment-1425
    http://forum.remmont.com/are-the-us-ready-to-lose-its-fleet-in-the-arctic/#comment/
    http://poznanie.com.ua/forum/forum4/topic15174/message760333/?result=reply#message760333
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message799421/
    http://wtb28.com/index.php
    http://uuo-mk.ru/index/8-39159
    http://i1d1.com/forum.php?mod=viewthread&tid=414
    http://dailyuganda.com/node/12723#comment-4498/
    http://dailyuganda.com/comment/reply/12721/3857
    http://poznanie.com.ua/forum/forum4/topic9764/message743564/?result=reply#message743564
    http://www.thepluglosangeles.com/c-los-n-s-ye-tape-journey-deeper-understanding/?unapproved=5129&moderation-hash=56f2745b5f1d58b21155b4c009e245a9#comment-5129
    http://poznanie.com.ua/forum/forum4/topic183316/message781066/?sessid=4c483f1b93ef688ede0e2d7935c39aac&TOPIC_SUBSCRIBE=Y&result=new
    http://dailyuganda.com/node/12724#comment-5882/
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message798958/
    http://analytixforum.000webhostapp.com/index.php
    http://bbs.4h.cn/home.php?mod=space&uid=90023
    http://bong88agent.com/forum/profile.php?id=235946
    http://soch3.ucoz.ru/forum/4-10-129#15504
    http://hdkaraokesong.com/space-uid-129417.html
    http://russkiy-hacker.com/topic/69-kakaia-tcena-za-vzlom-instagram/
    http://poznanie.com.ua/forum/forum4/topic15174/message778703/?result=reply#message778703
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message798799/
    http://poznanie.com.ua/forum/forum4/topic12467/message755899/?result=reply#message755899
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message798503/
    http://dalnoboy.by/forum/messages/forum1/topic3658/message6659/?result=reply#message6659
    http://ns1.apostilleservice.org.uk/boards/topic/1482/details-south-africa-finance-daily-news-remmontcom
    nashville.remmont.com
    http://mustangclubperformance.org.mx/foros/viewtopic.php?f=23&t=36
    http://millionerteam.ucoz.ru/forum/51-355-1
    http://forum.yas-theme.com/index.php
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message799345/
    http://forum.remmont.com/tag/macron-france-to-keep-its-forces-in-syria-this-year/#comment/
    http://poznanie.com.ua/forum/forum4/topic15174/message775533/?result=reply#message775533
    http://www.vnationtv.com/3194-2/?unapproved=19331&moderation-hash=3684e5cea87f387d90974389fc7e2c10#comment-19331
    http://poznanie.com.ua/forum/forum4/topic15174/message772411/?result=reply#message772411
    http://dailyuganda.com/comment/reply/12724/4080/
    http://poznanie.com.ua/forum/forum4/topic9764/message795680/?result=reply#message795680
    http://richardtorres00.com/forums/users/monicaporip/
    http://poznanie.com.ua/forum/forum4/topic15174/message774882/?result=reply#message774882
    http://apartment.remmont.com
    http://poznanie.com.ua/forum/forum4/topic15174/message781172/?result=reply#message781172
    http://radioviene.com/2017/12/01/que-te-gusta-que-te-regalen/?unapproved=3008&moderation-hash=cec26f9aedbb0dacae6f173fa5eaa37a#comment-3008
    http://poznanie.com.ua/forum/forum4/topic9764/message741660/
    http://forum.guanyo.com/viewthread.php?tid=316880&extra=
    http://concursocorreios.org/concurso-correios-inscricoes/?unapproved=151845&moderation-hash=fff4f9a518ddabe296076e66bab146de#comment-151845
    http://forum.remmont.com/the-network-got-video-from-the-test-of-the-largest-in-the-history-of-american-aircraft/#comment/
    http://poznanie.com.ua/forum/forum4/topic179249/message762103/?sessid=3217e1bbf781ca0e3d750c817478bbbd&TOPIC_SUBSCRIBE=Y&result=new
    http://poznanie.com.ua/forum/forum4/topic12467/message773017/?result=reply#message773017
    http://forum.remmont.com/the-end-of-the-free-syrian-police/#comment/
    http://www.doingtherightthing.nl/forums/topic/ride-on-sept-the-29httpmiami-remmont-com/
    http://ceritasemi.com/2017/11/threesome-sama-2-janda/?unapproved=41202&moderation-hash=53f6d941efcb4c5a232c7b107e02a52f#comment-41202
    http://uniclass.co/demo/blog/hachi-lorem-ipsum-dolor-sit-amet-2-consectetur/?unapproved=30406&moderation-hash=f8deae7a197f8df6ac3de63ad8502355#comment-30406
    http://gozizmir.com/index.php?option=com_k2&view=itemlist&task=user&id=32074
    http://poznanie.com.ua/forum/forum4/topic9764/message738978/
    http://poznanie.com.ua/forum/forum4/topic12467/message775364/?result=reply#message775364
    http://poznanie.com.ua/forum/forum4/topic15174/message762085/?result=reply#message762085
    http://api.javagametome.com/comments.html
    http://kvadratremont.ru/forum/messages/forum/8/message13515/49-pochemu-otkleivayutsya-oboi?result=reply#message13515
    http://masteringlync.com/2015/05/05/call-quality-dashboard-configuse/?unapproved=2109&moderation-hash=7fd93293cd94421897926f134ce1ecfd#comment-2109
    http://poznanie.com.ua/forum/forum4/topic181559/message773159/?sessid=5fc25c5e73a5ff49e7accde2202c01b3&TOPIC_SUBSCRIBE=Y&result=new
    http://poznanie.com.ua/forum/forum4/topic12467/message772036/?result=reply#message772036
    http://indomoneytalk.com/member.php?549615-Tetragmix
    http://drawings.wpblog.jp/forums/topic/details-hong-kong-finance-fresh-news-remmont-com/page/3/#post-741651/
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message798500/
    http://www.vespa-classic-club-geneve.ch/forum/viewtopic.php?f=4&t=447096
    http://anapa-cro.ucoz.net/index/8-1403
    http://www.kxwh.cn/bbs/home.php?mod=space&uid=299130
    http://spychina.cn/index.php?option=com_k2&view=itemlist&task=user&id=145791
    http://www.cedmagazineng.com/annual-ced-forumaward/?unapproved=45506&moderation-hash=76d6eaaa3507eab72e50765870884c67#comment-45506
    http://lifedagestan.ru/forum/12-95-8#17108/
    http://www.bangladeshi.com/%e0%a6%b8%e0%a7%8b%e0%a6%ab%e0%a6%bf%e0%a7%9f%e0%a6%be-%e0%a6%a4%e0%a7%81%e0%a6%ae%e0%a6%bf%e0%a6%93-%e0%a6%b8%e0%a6%be%e0%a6%ac%e0%a6%a7%e0%a6%be%e0%a6%a8/?unapproved=74&moderation-hash=0e6c525908e998a60d0c53715c6ddafc#comment-74
    http://poznanie.com.ua/forum/forum4/topic12467/message739413/
    http://shariat-pharmacy.com/forums/topic/arguments-flight-news-current-news-remmont-com/
    http://revdemon.xclub.tw/viewthread.php?tid=58553&pid=103721&page=1&extra=#pid103721
    http://forum.dayz-ast.com/memberlist.php?mode=viewprofile&u=14628
    http://campus.badmintonmenorca.com/?unapproved=30485&moderation-hash=bb77db201906fe37f2ad254bcff3ac56#comment-30485
    http://search.mysearch.com/web?q=long-beach.nef2.com
    http://beijing.shumo.com/forum/home.php?mod=space&uid=420765
    http://wenzheng.aynews.net.cn/home.php?mod=space&uid=174588
    http://poznanie.com.ua/forum/forum4/topic15174/message775914/?result=reply#message775914
    http://tdunlimited.com/index/8-136023
    http://poznanie.com.ua/forum/forum4/topic9764/message774221/?result=reply#message774221
    http://poznanie.com.ua/forum/forum4/topic15174/message771854/?result=reply#message771854
    http://forum.remmont.com/global-forecast-for-the-period-2019-2024-for-western-europe/#comment/
    http://richardtorres00.com/forums/users/travelet/
    http://poznanie.com.ua/forum/forum4/topic12467/message784145/?result=reply#message784145
    http://ukrproducts.eu/blog/preimuschestva-ukrproducts/
    http://thefieldreport.us/about-test/?unapproved=34274&moderation-hash=1dd8e6c25644e6ecf5a9c08ac3d9bc1c#comment-34274
    http://poznanie.com.ua/forum/forum4/topic15174/message780701/?result=reply#message780701
    http://poznanie.com.ua/forum/forum4/topic9764/message778325/?result=reply#message778325
    http://css-techmafia.3dn.ru/forum/36-13042-1#14529
    http://forum.remmont.com/accident-in-the-us-to-death-will-bring-salvation/#comment/
    http://poznanie.com.ua/forum/forum4/topic12467/message781667/?result=reply#message781667
    http://www.doingtherightthing.nl/forums/topic/creating-your-own-ipfshttpdesign-nef6-com/
    http://poznanie.com.ua/forum/forum4/topic12467/message755126/?result=reply#message755126
    http://poznanie.com.ua/forum/forum4/topic12467/message795540/?result=reply#message795540
    http://poznanie.com.ua/forum/forum4/topic183329/message781126/?sessid=043b34502e6b02b0c317590dac9cb4b4&TOPIC_SUBSCRIBE=Y&result=new
    http://dailyuganda.com/node/12787#comment-5721/
    http://poznanie.com.ua/forum/forum4/topic9764/message781306/?result=reply#message781306
    http://www.bizweb.ru/topic/15977-suvenirnaia-produktciia-optom-i-pod-zakaz/page-3/
    http://poznanie.com.ua/forum/forum4/topic12467/message795532/?result=reply#message795532
    http://russkiy-hacker.com/topic/69-kakaia-tcena-za-vzlom-instagram/page-5#entry11091/
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message798704/
    http://kvadratremont.ru/forum/messages/forum/8/message12265/49-pochemu-otkleivayutsya-oboi?result=reply#message12265
    http://poznanie.com.ua/forum/forum4/topic12467/message756149/?result=reply#message756149
    http://dailyuganda.com/comment/reply/11834/4013/
    http://ngoinhachung.net/diendan/space-uid-568718.html
    http://poznanie.com.ua/forum/forum4/topic15174/message737997/
    http://poznanie.com.ua/forum/forum4/topic181287/message771769/?sessid=8a9914764f2373ab836b1726964a2a2a&TOPIC_SUBSCRIBE=Y&result=new
    http://poznanie.com.ua/forum/forum4/topic15174/message774696/?result=reply#message774696
    http://www.geviews.co.uk/what-are-self-watering-planters
    http://nzk.funbbs.me/viewthread.php?tid=8394&extra=
    http://poznanie.com.ua/forum/forum4/topic9764/message776187/?result=reply#message776187
    http://zq16838.com/space-uid-1691.html
    http://poznanie.com.ua/forum/forum4/topic9764/message781107/?result=reply#message781107
    http://meacmtl.com/blog/index.php/2017/08/16/spotair-a-repondu-present/?unapproved=276273&moderation-hash=41996a11bed14f27b27e638d57ce2385#comment-276273
    http://ukrainakomi.ru/forum/messages/forum3/topic110/message798263/
    http://poznanie.com.ua/forum/forum4/topic12467/message781173/?result=reply#message781173
    http://xn--onq308b3xlp8y.lohasmassage.com/post.php?action=reply&fid=2&tid=1759211
    http://poznanie.com.ua/forum/forum4/topic15174/message775453/?result=reply#message775453
    http://xnonqu75bcvap11j.lohasmassage.com/viewthread.php?tid=1128&extra=
    http://poznanie.com.ua/forum/forum4/topic12467/message775437/?result=reply#message775437
    http://poznanie.com.ua/forum/forum4/topic15174/message781848/?result=reply#message781848
    http://citytur.ucoz.ru/index/8-27062
    http://poznanie.com.ua/forum/forum4/topic182757/message779654/?sessid=4458733d2c0a2e0e87a55fe24d9ba77c&TOPIC_SUBSCRIBE=Y&result=new
    http://tchdvip.com/home.php?mod=space&uid=108363
    http://www.gsmdevi.com/member.php/260991-REMONTLaf
    http://poznanie.com.ua/forum/forum4/topic15174/message783866/?result=reply#message783866
    http://kbm.pl/sedziwy-wiek-tylko-dzieki-treningowi-i-diecie/?unapproved=3370&moderation-hash=d0b2e9d46cc5bf79eb3befefdc8892bf#comment-3370
    http://poznanie.com.ua/forum/forum4/topic12467/message781465/?result=reply#message781465
    http://dailyuganda.com/comment/reply/12721/3550/
    http://dog-32.ru/index/8-39145
    http://www.pjckts.cn/?72586
    http://poznanie.com.ua/forum/forum4/topic15174/message763593/?result=reply#message763593
    http://poznanie.com.ua/forum/forum4/topic15174/message723512/
    http://poznanie.com.ua/forum/forum4/topic15174/message783203/?result=reply#message783203
    http://iw-wi.ru/forum/showthread.php?28677-Analytics-Eritrea-Finance-Current-News-remmont-com&p=104705#post104705

Leave a Reply

Your email address will not be published.