[bluesman]

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.