graficki alati za izradu querija su cudo :)

Ma nije samo query u pitanju, obratite pažnju na tabele koje se zovu z_9..z_55.

Database obfuscator?

Ovo je ocigledno generisano kodom i to zato sto su tabele denormalizovane zbog brzine upisa... Imam i ja u nekim projektima (koje takodje spasavam :)) iste ovakve bisere, doduse ne bas ovako komplikovane ali to se desava kada imas tabele ovakvog tipa koje sadrze milione slogova:

`id` int(11) NOT NULL AUTO_INCREMENT,
`wm_id` int(11) NOT NULL DEFAULT '0',
`domain_id` int(11) NOT NULL DEFAULT '0',
`month_date` date NOT NULL DEFAULT '0000-00-00',
`typ_01` int(11) NOT NULL DEFAULT '0',
`hit_01` int(11) NOT NULL DEFAULT '0',
`usa_01` int(11) NOT NULL DEFAULT '0',
`typ_02` int(11) NOT NULL DEFAULT '0',
`hit_02` int(11) NOT NULL DEFAULT '0',
`usa_02` int(11) NOT NULL DEFAULT '0',
`typ_03` int(11) NOT NULL DEFAULT '0',
`hit_03` int(11) NOT NULL DEFAULT '0',
`usa_03` int(11) NOT NULL DEFAULT '0',
`typ_04` int(11) NOT NULL DEFAULT '0',
`hit_04` int(11) NOT NULL DEFAULT '0',
`usa_04` int(11) NOT NULL DEFAULT '0',
`typ_05` int(11) NOT NULL DEFAULT '0',
`hit_05` int(11) NOT NULL DEFAULT '0',
`usa_05` int(11) NOT NULL DEFAULT '0',
`typ_06` int(11) NOT NULL DEFAULT '0',
`hit_06` int(11) NOT NULL DEFAULT '0',
`usa_06` int(11) NOT NULL DEFAULT '0',
`typ_07` int(11) NOT NULL DEFAULT '0',
`hit_07` int(11) NOT NULL DEFAULT '0',
`usa_07` int(11) NOT NULL DEFAULT '0',
`typ_08` int(11) NOT NULL DEFAULT '0',
`hit_08` int(11) NOT NULL DEFAULT '0',
`usa_08` int(11) NOT NULL DEFAULT '0',
`typ_09` int(11) NOT NULL DEFAULT '0',
`hit_09` int(11) NOT NULL DEFAULT '0',
`usa_09` int(11) NOT NULL DEFAULT '0',
`typ_10` int(11) NOT NULL DEFAULT '0',
`hit_10` int(11) NOT NULL DEFAULT '0',
`usa_10` int(11) NOT NULL DEFAULT '0',
`typ_11` int(11) NOT NULL DEFAULT '0',
`hit_11` int(11) NOT NULL DEFAULT '0',
`usa_11` int(11) NOT NULL DEFAULT '0',
`typ_12` int(11) NOT NULL DEFAULT '0',
`hit_12` int(11) NOT NULL DEFAULT '0',
`usa_12` int(11) NOT NULL DEFAULT '0',
`typ_13` int(11) NOT NULL DEFAULT '0',
`hit_13` int(11) NOT NULL DEFAULT '0',
`usa_13` int(11) NOT NULL DEFAULT '0',
`typ_14` int(11) NOT NULL DEFAULT '0',
`hit_14` int(11) NOT NULL DEFAULT '0',
`usa_14` int(11) NOT NULL DEFAULT '0',
`typ_15` int(11) NOT NULL DEFAULT '0',
`hit_15` int(11) NOT NULL DEFAULT '0',
`usa_15` int(11) NOT NULL DEFAULT '0',
`typ_16` int(11) NOT NULL DEFAULT '0',
`hit_16` int(11) NOT NULL DEFAULT '0',
`usa_16` int(11) NOT NULL DEFAULT '0',
`typ_17` int(11) NOT NULL DEFAULT '0',
`hit_17` int(11) NOT NULL DEFAULT '0',
`usa_17` int(11) NOT NULL DEFAULT '0',
`typ_18` int(11) NOT NULL DEFAULT '0',
`hit_18` int(11) NOT NULL DEFAULT '0',
`usa_18` int(11) NOT NULL DEFAULT '0',
`typ_19` int(11) NOT NULL DEFAULT '0',
`hit_19` int(11) NOT NULL DEFAULT '0',
`usa_19` int(11) NOT NULL DEFAULT '0',
`typ_20` int(11) NOT NULL DEFAULT '0',
`hit_20` int(11) NOT NULL DEFAULT '0',
`usa_20` int(11) NOT NULL DEFAULT '0',
`typ_21` int(11) NOT NULL DEFAULT '0',
`hit_21` int(11) NOT NULL DEFAULT '0',
`usa_21` int(11) NOT NULL DEFAULT '0',
`typ_22` int(11) NOT NULL DEFAULT '0',
`hit_22` int(11) NOT NULL DEFAULT '0',
`usa_22` int(11) NOT NULL DEFAULT '0',
`typ_23` int(11) NOT NULL DEFAULT '0',
`hit_23` int(11) NOT NULL DEFAULT '0',
`usa_23` int(11) NOT NULL DEFAULT '0',
`typ_24` int(11) NOT NULL DEFAULT '0',
`hit_24` int(11) NOT NULL DEFAULT '0',
`usa_24` int(11) NOT NULL DEFAULT '0',
`typ_25` int(11) NOT NULL DEFAULT '0',
`hit_25` int(11) NOT NULL DEFAULT '0',
`usa_25` int(11) NOT NULL DEFAULT '0',
`typ_26` int(11) NOT NULL DEFAULT '0',
`hit_26` int(11) NOT NULL DEFAULT '0',
`usa_26` int(11) NOT NULL DEFAULT '0',
`typ_27` int(11) NOT NULL DEFAULT '0',
`hit_27` int(11) NOT NULL DEFAULT '0',
`usa_27` int(11) NOT NULL DEFAULT '0',
`typ_28` int(11) NOT NULL DEFAULT '0',
`hit_28` int(11) NOT NULL DEFAULT '0',
`usa_28` int(11) NOT NULL DEFAULT '0',
`typ_29` int(11) NOT NULL DEFAULT '0',
`hit_29` int(11) NOT NULL DEFAULT '0',
`usa_29` int(11) NOT NULL DEFAULT '0',
`typ_30` int(11) NOT NULL DEFAULT '0',
`hit_30` int(11) NOT NULL DEFAULT '0',
`usa_30` int(11) NOT NULL DEFAULT '0',
`typ_31` int(11) NOT NULL DEFAULT '0',
`hit_31` int(11) NOT NULL DEFAULT '0',
`usa_31` int(11) NOT NULL DEFAULT '0',
`typ_total` bigint(20) NOT NULL DEFAULT '0',
`hit_total` bigint(20) NOT NULL DEFAULT '0',
`usa_total` bigint(20) NOT NULL DEFAULT '0',

jel znate kako se uzima poslednji zapis iz baze?
i onda!
ovo je zateknut kod nekih indijaca na jaaako posecenom sajtu
bio ovo pre jednooo pa, pre 2 godine
jos uvek ga pamtim :D

jbt, ali jbt

Nije to nista - mi smo do skoro koristili jednu aplikaciju, koja je na osnovu proslijedjenih parametara dinamicki generisala SQL upite. Odstampao sam najduzi SQL upit i nalijepio na zid. Sta mislte koliko A4 stranica je bilo potrebno da se odstampa citav upit?

24 stranice!

To je bila jedna 3rd party aplikacija, a baza je bila Oracle 9i sa 16 GB RAM-a i 8 CPUs, koju smo zamijenili novom in-house aplikacijom na Oracle 10g i sad su upiti kraci za oko 80% i munjevito se izvrsavaju...

Kad mi neko spomene neke Buildere, Generatore i sl., odmah pocnem da kolutam ocima...

Ne verujem da ćemo sa našim rešenjem zagrditi baš ovoliko, ali me nervira kako stvari trenutno izgledaju (o ovome sam pričao na meetupu prošli vikend):

Problem je ovaj deo:

Pošto svaki korisnik na svakom projektu može imati različite dozvole (na nekima sme da vidi tickete, na nekima ne pa tako za svaki) tipovi koje sistem traži nisu poznati unapred, već se na osnovu dozvola i projekta određuju. Ovaj deo uslova se množi brojem aktivnih projekata kojima korisnik ima pristup (gore je primer samo za jedan).

Kao što rekoh, nismo zagrdili kao ovi gore, ali mi se rešenje ne sviđa previše.

Ima i onih koji nisu culi za auto increm. polje pa svaki put vrse prebrojavanje pa dodaju 1 na taj iznos i tek tada rade INSERT :)

E par takvih je diplomiralo a ja jos nisam...

Evo novog kandidata, ovo je stvarno za analizu, ne querija nego onoga ko ga je napisao (naki latvijac, šta li je, 'bem ga... uvalili su mi ga u team):

SELECT * FROM complaints WHERE status=1 and ( LEFT(phone, 4) LIKE '01234%' OR LEFT(phone, 4) LIKE '01361%' OR LEFT(phone, 4) LIKE '01525%' OR LEFT(phone, 4) LIKE '01582%' OR LEFT(phone, 4) LIKE '01767%' OR LEFT(phone, 4) LIKE '01462%' OR LEFT(phone, 4) LIKE '01344%' OR LEFT(phone, 4) LIKE '01488%' OR LEFT(phone, 4) LIKE '01628%' OR LEFT(phone, 4) LIKE '01635%' OR LEFT(phone, 4) LIKE '0118%' OR LEFT(phone, 4) LIKE '01753%' OR LEFT(phone, 4) LIKE '0117%' OR LEFT(phone, 4) LIKE '01296%' OR LEFT(phone, 4) LIKE '01280%' OR LEFT(phone, 4) LIKE '01494%' OR LEFT(phone, 4) LIKE '01908%' OR LEFT(phone, 4) LIKE '01633%' OR LEFT(phone, 4) LIKE '01844%' OR LEFT(phone, 4) LIKE '01353%' OR LEFT(phone, 4) LIKE '01480%' OR LEFT(phone, 4) LIKE '01354%' OR LEFT(phone, 4) LIKE '01945%' OR LEFT(phone, 4) LIKE '01223%' OR LEFT(phone, 4) LIKE '01733%' OR LEFT(phone, 4) LIKE '01244%' OR LEFT(phone, 4) LIKE '01260%' OR LEFT(phone, 4) LIKE '01270%' OR LEFT(phone, 4) LIKE '01565%' OR LEFT(phone, 4) LIKE '01625%' OR LEFT(phone, 4) LIKE '01606%' OR LEFT(phone, 4) LIKE '01928%' OR LEFT(phone, 4) LIKE '01925%' OR LEFT(phone, 4) LIKE '0151%' OR LEFT(phone, 4) LIKE '01208%' OR LEFT(phone, 4) LIKE '01288%' OR LEFT(phone, 4) LIKE '01840%' OR LEFT(phone, 4) LIKE '01326%' OR LEFT(phone, 4) LIKE '01566%' OR LEFT(phone, 4) LIKE '01579%' OR LEFT(phone, 4) LIKE '01503%' OR LEFT(phone, 4) LIKE '01637%' OR LEFT(phone, 4) LIKE '01841%' OR LEFT(phone, 4) LIKE '01736%' OR LEFT(phone, 4) LIKE '01209%' OR LEFT(phone, 4) LIKE '01726%' OR LEFT(phone, 4) LIKE '01872%' OR LEFT(phone, 4) LIKE '01720%' OR LEFT(phone, 4) LIKE '01752%' OR LEFT(phone, 4) LIKE '01388%' OR LEFT(phone, 4) LIKE '01207%' OR LEFT(phone, 4) LIKE '01325%' OR LEFT(phone, 4) LIKE '0191%' OR LEFT(phone, 4) LIKE '01429%' OR LEFT(phone, 4) LIKE '01833%' OR LEFT(phone, 4) LIKE '01642%' OR LEFT(phone, 4) LIKE '01740%' OR LEFT(phone, 4) LIKE '017683%' OR LEFT(phone, 4) LIKE '01229%' OR LEFT(phone, 4) LIKE '01228%' OR LEFT(phone, 4) LIKE '015395%' OR LEFT(phone, 4) LIKE '01539%' OR LEFT(phone, 4) LIKE '017687%' OR LEFT(phone, 4) LIKE '01768%' OR LEFT(phone, 4) LIKE '015396%' OR LEFT(phone, 4) LIKE '01946%' OR LEFT(phone, 4) LIKE '016973%' OR LEFT(phone, 4) LIKE '01900%' OR LEFT(phone, 4) LIKE '01697%' OR LEFT(phone, 4) LIKE '01899%' OR LEFT(phone, 4) LIKE '016974%' OR LEFT(phone, 4) LIKE '016977%' OR LEFT(phone, 4) LIKE '017684%' OR LEFT(phone, 4) LIKE '019467%' OR LEFT(phone, 4) LIKE '01434%' OR LEFT(phone, 4) LIKE '015394%' OR LEFT(phone, 4) LIKE '015242%' OR LEFT(phone, 4) LIKE '01335%' OR LEFT(phone, 4) LIKE '01298%' OR LEFT(phone, 4) LIKE '01246%' OR LEFT(phone, 4) LIKE '01457%' OR LEFT(phone, 4) LIKE '01629%' OR LEFT(phone, 4) LIKE '01663%' OR LEFT(phone, 4) LIKE '01773%' OR LEFT(phone, 4) LIKE '01332%' OR LEFT(phone, 4) LIKE '0115%' OR LEFT(phone, 4) LIKE '0114%' OR LEFT(phone, 4) LIKE '01623%' OR LEFT(phone, 4) LIKE '01283%' OR LEFT(phone, 4) LIKE '01364%' OR LEFT(phone, 4) LIKE '01297%' OR LEFT(phone, 4) LIKE '01271%' OR LEFT(phone, 4) LIKE '01237%' OR LEFT(phone, 4) LIKE '01395%' OR LEFT(phone, 4) LIKE '01363%' OR LEFT(phone, 4) LIKE '01392%' OR LEFT(phone, 4) LIKE '01404%' OR LEFT(phone, 4) LIKE '01548%' OR LEFT(phone, 4) LIKE '01647%' OR LEFT(phone, 4) LIKE '01626%' OR LEFT(phone, 4) LIKE '01837%' OR LEFT(phone, 4) LIKE '01822%' OR LEFT(phone, 4) LIKE '01884%' OR LEFT(phone, 4) LIKE '01803%' OR LEFT(phone, 4) LIKE '01580%' OR LEFT(phone, 4) LIKE '01258%' OR LEFT(phone, 4) LIKE '01202%' OR LEFT(phone, 4) LIKE '01308%' OR LEFT(phone, 4) LIKE '01305%' OR LEFT(phone, 4) LIKE '01747%' OR LEFT(phone, 4) LIKE '01929%' OR LEFT(phone, 4) LIKE '01300%' OR LEFT(phone, 4) LIKE '01963%' OR LEFT(phone, 4) LIKE '01262%' OR LEFT(phone, 4) LIKE '01377%' OR LEFT(phone, 4) LIKE '01405%' OR LEFT(phone, 4) LIKE '01430%' OR LEFT(phone, 4) LIKE '01759%' OR LEFT(phone, 4) LIKE '01482%' OR LEFT(phone, 4) LIKE '01964%' OR LEFT(phone, 4) LIKE '01323%' OR LEFT(phone, 4) LIKE '01797%' OR LEFT(phone, 4) LIKE '01825%' OR LEFT(phone, 4) LIKE '01273%' OR LEFT(phone, 4) LIKE '01424%' OR LEFT(phone, 4) LIKE '01892%' OR LEFT(phone, 4) LIKE '01268%' OR LEFT(phone, 4) LIKE '01376%' OR LEFT(phone, 4) LIKE '01277%' OR LEFT(phone, 4) LIKE '01245%' OR LEFT(phone, 4) LIKE '01255%' OR LEFT(phone, 4) LIKE '01206%' OR LEFT(phone, 4) LIKE '01371%' OR LEFT(phone, 4) LIKE '01621%' OR LEFT(phone, 4) LIKE '01799%' OR LEFT(phone, 4) LIKE '01955%' OR LEFT(phone, 4) LIKE '01992%' OR LEFT(phone, 4) LIKE '020%' OR LEFT(phone, 4) LIKE '01375%' OR LEFT(phone, 4) LIKE '01787%' OR LEFT(phone, 4) LIKE '01702%' OR LEFT(phone, 4) LIKE '01454%' OR LEFT(phone, 4) LIKE '01285%' OR LEFT(phone, 4) LIKE '01453%' OR LEFT(phone, 4) LIKE '01452%' OR LEFT(phone, 4) LIKE '01594%' OR LEFT(phone, 4) LIKE '01451%' OR LEFT(phone, 4) LIKE '01242%' OR LEFT(phone, 4) LIKE '01608%' OR LEFT(phone, 4) LIKE '01531%' OR LEFT(phone, 4) LIKE '01666%' OR LEFT(phone, 4) LIKE '01684%' OR LEFT(phone, 4) LIKE '01204%' OR LEFT(phone, 4) LIKE '01706%' OR LEFT(phone, 4) LIKE '01942%' OR LEFT(phone, 4) LIKE '0161%' OR LEFT(phone, 4) LIKE '01252%' OR LEFT(phone, 4) LIKE '01420%' OR LEFT(phone, 4) LIKE '01264%' OR LEFT(phone, 4) LIKE '01256%' OR LEFT(phone, 4) LIKE '01730%' OR LEFT(phone, 4) LIKE '01425%' OR LEFT(phone, 4) LIKE '01962%' OR LEFT(phone, 4) LIKE '023%' OR LEFT(phone, 4) LIKE '01489%' OR LEFT(phone, 4) LIKE '01243%' OR LEFT(phone, 4) LIKE '01886%' OR LEFT(phone, 4) LIKE '01432%' OR LEFT(phone, 4) LIKE '01544%' OR LEFT(phone, 4) LIKE '01568%' OR LEFT(phone, 4) LIKE '01279%' OR LEFT(phone, 4) LIKE '01257%' OR LEFT(phone, 4) LIKE '01442%' OR LEFT(phone, 4) LIKE '01707%' OR LEFT(phone, 4) LIKE '01763%' OR LEFT(phone, 4) LIKE '01727%' OR LEFT(phone, 4) LIKE '01920%' OR LEFT(phone, 4) LIKE '01923%' OR LEFT(phone, 4) LIKE '01983%' OR LEFT(phone, 4) LIKE '01227%' OR LEFT(phone, 4) LIKE '01322%' OR LEFT(phone, 4) LIKE '01304%' OR LEFT(phone, 4) LIKE '01303%' OR LEFT(phone, 4) LIKE '01474%' OR LEFT(phone, 4) LIKE '01622%' OR LEFT(phone, 4) LIKE '01732%' OR LEFT(phone, 4) LIKE '01795%' OR LEFT(phone, 4) LIKE '01959%' OR LEFT(phone, 4) LIKE '01987%' OR LEFT(phone, 4) LIKE '01843%' OR LEFT(phone, 4) LIKE '01634%' OR LEFT(phone, 4) LIKE '01254%' OR LEFT(phone, 4) LIKE '01253%' OR LEFT(phone, 4) LIKE '01282%' OR LEFT(phone, 4) LIKE '01200%' OR LEFT(phone, 4) LIKE '01995%' OR LEFT(phone, 4) LIKE '01524%' OR LEFT(phone, 4) LIKE '01695%' OR LEFT(phone, 4) LIKE '01772%' OR LEFT(phone, 4) LIKE '01455%' OR LEFT(phone, 4) LIKE '0116%' OR LEFT(phone, 4) LIKE '01509%' OR LEFT(phone, 4) LIKE '01858%' OR LEFT(phone, 4) LIKE '01664%' OR LEFT(phone, 4) LIKE '01530%' OR LEFT(phone, 4) LIKE '01975%' OR LEFT(phone, 4) LIKE '01205%' OR LEFT(phone, 4) LIKE '01652%' OR LEFT(phone, 4) LIKE '01427%' OR LEFT(phone, 4) LIKE '01476%' OR LEFT(phone, 4) LIKE '01472%' OR LEFT(phone, 4) LIKE '01406%' OR LEFT(phone, 4) LIKE '01522%' OR LEFT(phone, 4) LIKE '01507%' OR LEFT(phone, 4) LIKE '01673%' OR LEFT(phone, 4) LIKE '01724%' OR LEFT(phone, 4) LIKE '01754%' OR LEFT(phone, 4) LIKE '01529%' OR LEFT(phone, 4) LIKE '01775%' OR LEFT(phone, 4) LIKE '01790%' OR LEFT(phone, 4) LIKE '01780%' OR LEFT(phone, 4) LIKE '01778%' OR LEFT(phone, 4) LIKE '01469%' OR LEFT(phone, 4) LIKE '01704%' OR LEFT(phone, 4) LIKE '01744%' OR LEFT(phone, 4) LIKE '01263%' OR LEFT(phone, 4) LIKE '01362%' OR LEFT(phone, 4) LIKE '01379%' OR LEFT(phone, 4) LIKE '01366%' OR LEFT(phone, 4) LIKE '01328%' OR LEFT(phone, 4) LIKE '01493%' OR LEFT(phone, 4) LIKE '01485%' OR LEFT(phone, 4) LIKE '01553%' OR LEFT(phone, 4) LIKE '01692%' OR LEFT(phone, 4) LIKE '01760%' OR LEFT(phone, 4) LIKE '01842%' OR LEFT(phone, 4) LIKE '01953%' OR LEFT(phone, 4) LIKE '01508%' OR LEFT(phone, 4) LIKE '01603%' OR LEFT(phone, 4) LIKE '01677%' OR LEFT(phone, 4) LIKE '01423%' OR LEFT(phone, 4) LIKE '01347%' OR LEFT(phone, 4) LIKE '01287%' OR LEFT(phone, 4) LIKE '01439%' OR LEFT(phone, 4) LIKE '01969%' OR LEFT(phone, 4) LIKE '01653%' OR LEFT(phone, 4) LIKE '01609%' OR LEFT(phone, 4) LIKE '01751%' OR LEFT(phone, 4) LIKE '01748%' OR LEFT(phone, 4) LIKE '01765%' OR LEFT(phone, 4) LIKE '01723%' OR LEFT(phone, 4) LIKE '01757%' OR LEFT(phone, 4) LIKE '01729%' OR LEFT(phone, 4) LIKE '01756%' OR LEFT(phone, 4) LIKE '01845%' OR LEFT(phone, 4) LIKE '01947%' OR LEFT(phone, 4) LIKE '01904%' OR LEFT(phone, 4) LIKE '01937%' OR LEFT(phone, 4) LIKE '01327%' OR LEFT(phone, 4) LIKE '01536%' OR LEFT(phone, 4) LIKE '01604%' OR LEFT(phone, 4) LIKE '01933%' OR LEFT(phone, 4) LIKE '01832%' OR LEFT(phone, 4) LIKE '01665%' OR LEFT(phone, 4) LIKE '01670%' OR LEFT(phone, 4) LIKE '01661%' OR LEFT(phone, 4) LIKE '01669%' OR LEFT(phone, 4) LIKE '01289%' OR LEFT(phone, 4) LIKE '01668%' OR LEFT(phone, 4) LIKE '01636%' OR LEFT(phone, 4) LIKE '01777%' OR LEFT(phone, 4) LIKE '01909%' OR LEFT(phone, 4) LIKE '01949%' OR LEFT(phone, 4) LIKE '01295%' OR LEFT(phone, 4) LIKE '01869%' OR LEFT(phone, 4) LIKE '01367%' OR LEFT(phone, 4) LIKE '01491%' OR LEFT(phone, 4) LIKE '01993%' OR LEFT(phone, 4) LIKE '01235%' OR LEFT(phone, 4) LIKE '01572%' OR LEFT(phone, 4) LIKE '01746%' OR LEFT(phone, 4) LIKE '01694%' OR LEFT(phone, 4) LIKE '01584%' OR LEFT(phone, 4) LIKE '01630%' OR LEFT(phone, 4) LIKE '01691%' OR LEFT(phone, 4) LIKE '01743%' OR LEFT(phone, 4) LIKE '01952%' OR LEFT(phone, 4) LIKE '01939%' OR LEFT(phone, 4) LIKE '01948%' OR LEFT(phone, 4) LIKE '01588%' OR LEFT(phone, 4) LIKE '01299%' OR LEFT(phone, 4) LIKE '01225%' OR LEFT(phone, 4) LIKE '01278%' OR LEFT(phone, 4) LIKE '01460%' OR LEFT(phone, 4) LIKE '01275%' OR LEFT(phone, 4) LIKE '01398%' OR LEFT(phone, 4) LIKE '01373%' OR LEFT(phone, 4) LIKE '01458%' OR LEFT(phone, 4) LIKE '01643%' OR LEFT(phone, 4) LIKE '01749%' OR LEFT(phone, 4) LIKE '01823%' OR LEFT(phone, 4) LIKE '01984%' OR LEFT(phone, 4) LIKE '01934%' OR LEFT(phone, 4) LIKE '01935%' OR LEFT(phone, 4) LIKE '01226%' OR LEFT(phone, 4) LIKE '01302%' OR LEFT(phone, 4) LIKE '01709%' OR LEFT(phone, 4) LIKE '01543%' OR LEFT(phone, 4) LIKE '01785%' OR LEFT(phone, 4) LIKE '01827%' OR LEFT(phone, 4) LIKE '01889%' OR LEFT(phone, 4) LIKE '01782%' OR LEFT(phone, 4) LIKE '01538%' OR LEFT(phone, 4) LIKE '01986%' OR LEFT(phone, 4) LIKE '01394%' OR LEFT(phone, 4) LIKE '01440%' OR LEFT(phone, 4) LIKE '01502%' OR LEFT(phone, 4) LIKE '01638%' OR LEFT(phone, 4) LIKE '01728%' OR LEFT(phone, 4) LIKE '01449%' OR LEFT(phone, 4) LIKE '01284%' OR LEFT(phone, 4) LIKE '01473%' OR LEFT(phone, 4) LIKE '01233%' OR LEFT(phone, 4) LIKE '01276%' OR LEFT(phone, 4) LIKE '01883%' OR LEFT(phone, 4) LIKE '01306%' OR LEFT(phone, 4) LIKE '01372%' OR LEFT(phone, 4) LIKE '01483%' OR LEFT(phone, 4) LIKE '01428%' OR LEFT(phone, 4) LIKE '01737%' OR LEFT(phone, 4) LIKE '01784%' OR LEFT(phone, 4) LIKE '01932%' OR LEFT(phone, 4) LIKE '01293%' OR LEFT(phone, 4) LIKE '01567%' OR LEFT(phone, 4) LIKE '01675%' OR LEFT(phone, 4) LIKE '01788%' OR LEFT(phone, 4) LIKE '01926%' OR LEFT(phone, 4) LIKE '01789%' OR LEFT(phone, 4) LIKE '024%' OR LEFT(phone, 4) LIKE '01564%' OR LEFT(phone, 4) LIKE '0121%' OR LEFT(phone, 4) LIKE '01384%' OR LEFT(phone, 4) LIKE '01922%' OR LEFT(phone, 4) LIKE '01902%' OR LEFT(phone, 4) LIKE '01342%' OR LEFT(phone, 4) LIKE '01444%' OR LEFT(phone, 4) LIKE '01403%' OR LEFT(phone, 4) LIKE '01903%' OR LEFT(phone, 4) LIKE '01798%' OR LEFT(phone, 4) LIKE '01274%' OR LEFT(phone, 4) LIKE '01422%' OR LEFT(phone, 4) LIKE '01484%' OR LEFT(phone, 4) LIKE '01535%' OR LEFT(phone, 4) LIKE '0113%' OR LEFT(phone, 4) LIKE '01977%' OR LEFT(phone, 4) LIKE '01924%' OR LEFT(phone, 4) LIKE '01943%' OR LEFT(phone, 4) LIKE '01980%' OR LEFT(phone, 4) LIKE '01249%' OR LEFT(phone, 4) LIKE '01380%' OR LEFT(phone, 4) LIKE '01672%' OR LEFT(phone, 4) LIKE '01722%' OR LEFT(phone, 4) LIKE '01793%' OR LEFT(phone, 4) LIKE '01985%' OR LEFT(phone, 4) LIKE '01386%' OR LEFT(phone, 4) LIKE '01562%' OR LEFT(phone, 4) LIKE '01905%' OR LEFT(phone, 4) LIKE '01527%') ORDER BY id DESC LIMIT 0, 6


Čisto za informaciju da objasnim o čemu se radi: treba da izvuče iz jedne tabele zadnih 6 record-a vezanih za određeni country. Pa "brainiac" umesto da kaže " where country = 'xxxx' " on iz druge tabele pokupi sve area codeove za tu country pa onda generise ovakav query. WTF?

Sva sreća pa sam video u kodu pre nego što je pušten sajt. I posle mi kažu "nemoj da im gledaš kod"? Gde da ne gledam, treba da se blamiram sa ovakvim budalaštinama.

Nema pretjerane veze ali ja sam vidio desetine ljudi koji da bi posjetili neki sajt, prvo otvore Google a onda u polje za pretragu ukucaju URL na koji žele ići. Google im kao prvi rezultat obično vrati isti taj link i tek onda kliknu na njega i posjete sajt.

Jednostavno misle da je Google upravo za to namjenjen. Strahota..