Hospedar-se .Com

SELECT idc AS id, nome, categoria, subcat1, subcat2,
(SELECT endereco FROM clientes WHERE codigo = id) AS endereco,
(SELECT complemento FROM clientes WHERE codigo = id) AS complemento,
(SELECT cep FROM clientes WHERE codigo = id) AS cep,
(SELECT estado FROM clientes WHERE codigo = id) AS estado,
(SELECT cidade FROM clientes WHERE codigo = id) AS cidade
FROM classificados ORDER BY endereco


Como usaria o DISTINCT pra não selecionar endereços repetidos?

Preciso gerar etiquetas de endereços, só que tem cadastro de PAI, MÃE, FILHO, etc... morando no mesmo endereço, e para não enviar Muitas cartas para o mesmo endereço como modificaria esse SQL pra pegar somente 1 endereço por pessoa? Ele não pode repetir os outros membros da familia

Como faço pra selecionar tudo o que tiver Y e o total dividir por 2?

Tenho isso aqui:

SELECT COUNT(ap) as total FROM venda WHERE idvenda="1" AND ap="DBL"



No caso como clocaria a função de divisao (DIV) nesse código acima?


Ele tem que dividir o total por 2


Valeu

Tenho uma tabela assim:

ID
VALOR
Situação


Queria saber se da pra somar o total em R$ (campo valor) ja no código sql

FILTRO DE PALAVRAS PARA O EXIM (SALVE COMO SPAM.SH):


#!/bin/bash

#### Cria a lista de palavras a serem bloqueadas
cat > /home/.filter << "EOF"
$message_headers contains "agnetismo"+++++++/dev/null
$message_headers contains "Arte da Conquista"+++++++/dev/null
$message_headers contains "Promoção Colorida"+++++++/dev/null
$message_headers contains "1ium"+++++++/dev/null
$message_headers contains "67.19.186"+++++++/dev/null
$message_headers contains "A.exe"+++++++/dev/null
$message_headers contains "a.exe"+++++++/dev/null
$message_headers contains "a.scr"+++++++/dev/null
$message_headers contains "acettoluide"+++++++/dev/null
$message_headers contains "acormack"+++++++/dev/null
$message_headers contains "acridity"+++++++/dev/null
$message_headers contains "adquira ja"+++++++/dev/null
$message_headers contains "adquira já"+++++++/dev/null
$message_headers contains "ala direta"+++++++/dev/null
$message_headers contains "alco-h"+++++++/dev/null
$message_headers contains "ALlS"+++++++/dev/null
$message_headers contains "alternance"+++++++/dev/null
$message_headers contains "ama-zing"+++++++/dev/null
$message_headers contains "amazing"+++++++/dev/null
$message_headers contains "Amor Esta no Ar"+++++++/dev/null
$message_headers contains "amor.scr"+++++++/dev/null
$message_headers contains "ank"+++++++/dev/null
$message_headers contains "archvillainy"+++++++/dev/null
$message_headers contains "arthrophyma"+++++++/dev/null
$message_headers contains "atch"+++++++/dev/null
$message_headers contains "AUMENTE SEU"+++++++/dev/null
$message_headers contains "aumente seu"+++++++/dev/null
$message_headers contains "B.exe"+++++++/dev/null
$message_headers contains "b.exe"+++++++/dev/null
$message_headers contains "b.scr"+++++++/dev/null
$message_headers contains "B@mm"+++++++/dev/null
$message_headers contains "BANK"+++++++/dev/null
$message_headers contains "bank"+++++++/dev/null
$message_headers contains "Berlinize"+++++++/dev/null
$message_headers contains "bluelight"+++++++
$message_headers contains "bluelight"+++++++/dev/null
$message_headers contains "Bugbear"+++++++/dev/null
$message_headers contains "bwbypandal"+++++++/dev/null
$message_headers contains "C-ALLIS"+++++++/dev/null
$message_headers contains "c-ar"+++++++/dev/null
$message_headers contains "C.exe"+++++++/dev/null
$message_headers contains "c.exe"+++++++/dev/null
$message_headers contains "c.scr"+++++++/dev/null
$message_headers contains "c1al"+++++++/dev/null
$message_headers contains "C1ALlS"+++++++/dev/null
$message_headers contains "camera"+++++++/dev/null
$message_headers contains "canet"+++++++/dev/null
$message_headers contains "cartao especial"+++++++/dev/null
$message_headers contains "cartao TERRA"+++++++/dev/null
$message_headers contains "cartão especial"+++++++/dev/null
$message_headers contains "cartão TERRA"+++++++/dev/null
$message_headers contains "cashew"+++++++/dev/null
$message_headers contains "casiino"+++++++/dev/null
$message_headers contains "chur"+++++++/dev/null
$message_headers contains "Ci-alis"+++++++/dev/null
$message_headers contains "Ci-ialis"+++++++/dev/null
$message_headers contains "CiAllis"+++++++/dev/null
$message_headers contains "CiALlS"+++++++/dev/null
$message_headers contains "cJ3Q"+++++++/dev/null
$message_headers contains "ClALiS"+++++++/dev/null
$message_headers contains "colegial.bmp"+++++++/dev/null
$message_headers contains "commodious"+++++++/dev/null
$message_headers contains "constituent"+++++++/dev/null
$message_headers contains "croix"+++++++/dev/null
$message_headers contains "curso completo"+++++++/dev/null
$message_headers contains "d-rive"+++++++/dev/null
$message_headers contains "D.exe"+++++++/dev/null
$message_headers contains "d.exe"+++++++/dev/null
$message_headers contains "d.scr"+++++++/dev/null
$message_headers contains "deepthroat"+++++++/dev/null
$message_headers contains "dizz-y"+++++++/dev/null
$message_headers contains "doit"+++++++/dev/null
$message_headers contains "drug"+++++++/dev/null
$message_headers contains "dvgmail"+++++++/dev/null
$message_headers contains "e-rectiions"+++++++/dev/null
$message_headers contains "E.exe"+++++++/dev/null
$message_headers contains "e.exe"+++++++/dev/null
$message_headers contains "e.scr"+++++++/dev/null
$message_headers contains "earthmoving"+++++++/dev/null
$message_headers contains "emagrecer"+++++++/dev/null
$message_headers contains "emagreça"+++++++/dev/null
$message_headers contains "ertinho de Voce"+++++++/dev/null
$message_headers contains "ertinho de Você"+++++++/dev/null
$message_headers contains "ertinho de você"+++++++/dev/null
$message_headers contains "esta no ap"+++++++/dev/null
$message_headers contains "esta no ape"+++++++/dev/null
$message_headers contains "eu chamo de"+++++++/dev/null
$message_headers contains "eventospatriani"+++++++/dev/null
$message_headers contains "evestimentos com"+++++++/dev/null
$message_headers contains "F.exe"+++++++/dev/null
$message_headers contains "f.exe"+++++++/dev/null
$message_headers contains "f.scr"+++++++/dev/null
$message_headers contains "fas-ter"+++++++/dev/null
$message_headers contains "fe-ct"+++++++/dev/null
$message_headers contains "fellipe.info"+++++++/dev/null
$message_headers contains "Foto do Colégio"+++++++/dev/null
$message_headers contains "free"+++++++/dev/null
$message_headers contains "G.exe"+++++++/dev/null
$message_headers contains "g.exe"+++++++/dev/null
$message_headers contains "g.scr"+++++++/dev/null
$message_headers contains "galeon"+++++++/dev/null
$message_headers contains "girl"+++++++/dev/null
$message_headers contains "grant"+++++++/dev/null
$message_headers contains "green car"+++++++/dev/null
$message_headers contains "greenca"+++++++/dev/null
$message_headers contains "guy"+++++++/dev/null
$message_headers contains "H.exe"+++++++/dev/null
$message_headers contains "h.exe"+++++++/dev/null
$message_headers contains "h.scr"+++++++/dev/null
$message_headers contains "hairpin"+++++++/dev/null
$message_headers contains "halito"+++++++/dev/null
$message_headers contains "alito"+++++++/dev/null
$message_headers contains "álito"+++++++/dev/null
$message_headers contains "hall"+++++++/dev/null
$message_headers contains "elebrity"+++++++/dev/null
$message_headers contains "adalaf"+++++++/dev/null
$message_headers contains "alcohol"+++++++/dev/null
$message_headers contains "harmac"+++++++/dev/null
$message_headers contains "ho-urs"+++++++/dev/null
$message_headers contains "hoebe"+++++++/dev/null
$message_headers contains "hzcjqshowugg"+++++++/dev/null
$message_headers contains "i Meu Amor"+++++++/dev/null
$message_headers contains "i Meu amor"+++++++/dev/null
$message_headers contains "i meu Amor"+++++++/dev/null
$message_headers contains "i meu amor"+++++++/dev/null
$message_headers contains "i-agra"+++++++/dev/null
$message_headers contains "i-ck"+++++++/dev/null
$message_headers contains "I.exe"+++++++/dev/null
$message_headers contains "i.exe"+++++++/dev/null
$message_headers contains "i.scr"+++++++/dev/null
$message_headers contains "iagra"+++++++/dev/null
$message_headers contains "ialis"+++++++/dev/null
$message_headers contains "icatriz-reparacao"+++++++/dev/null
$message_headers contains "icatriz-reparacão"+++++++/dev/null
$message_headers contains "icatriz-reparaçao"+++++++/dev/null
$message_headers contains "icatriz-reparação"+++++++/dev/null
$message_headers contains "internet.e"+++++++/dev/null
$message_headers contains "is sera que"+++++++/dev/null
$message_headers contains "iverjoice"+++++++/dev/null
$message_headers contains "J.exe"+++++++/dev/null
$message_headers contains "j.exe"+++++++/dev/null
$message_headers contains "j.scr"+++++++/dev/null
$message_headers contains "Jared Tovar"+++++++/dev/null
$message_headers contains "Jared tovar"+++++++/dev/null
$message_headers contains "jared Tovar"+++++++/dev/null
$message_headers contains "jared tovar"+++++++/dev/null
$message_headers contains "K.exe"+++++++/dev/null
$message_headers contains "k.exe"+++++++/dev/null
$message_headers contains "k.scr"+++++++/dev/null
$message_headers contains "L.exe"+++++++/dev/null
$message_headers contains "l.exe"+++++++/dev/null
$message_headers contains "l.scr"+++++++/dev/null
$message_headers contains "L1UM"+++++++/dev/null
$message_headers contains "Lençol Termico"+++++++/dev/null
$message_headers contains "lençol Termico"+++++++/dev/null
$message_headers contains "lençol termico"+++++++/dev/null
$message_headers contains "lev-it-ra"+++++++/dev/null
$message_headers contains "lippin"+++++++/dev/null
$message_headers contains "lisst"+++++++/dev/null
$message_headers contains "lium"+++++++/dev/null
$message_headers contains "LlUM"+++++++/dev/null
$message_headers contains "lood"+++++++/dev/null
$message_headers contains "loschuzos"+++++++/dev/null
$message_headers contains "lquem que nao esqueceu"+++++++/dev/null
$message_headers contains "lquem que não esqueceu"+++++++/dev/null
$message_headers contains "M.exe"+++++++/dev/null
$message_headers contains "m.exe"+++++++/dev/null
$message_headers contains "m.scr"+++++++/dev/null
$message_headers contains "magreca dormindo"+++++++/dev/null
$message_headers contains "magreça dormindo"+++++++/dev/null
$message_headers contains "mai-lling"+++++++/dev/null
$message_headers contains "marketweighton"+++++++/dev/null
$message_headers contains "melhores usam"+++++++/dev/null
$message_headers contains "melhores usam"+++++++/dev/null
$message_headers contains "milhoes de emails"+++++++/dev/null
$message_headers contains "milhões de emails"+++++++/dev/null
$message_headers contains "minutes"+++++++/dev/null
$message_headers contains "mojaposta"+++++++/dev/null
$message_headers contains "MOMENTUM"+++++++/dev/null
$message_headers contains "mor Esta no Ar"+++++++/dev/null
$message_headers contains "mor Esta no ar"+++++++/dev/null
$message_headers contains "mor esta no ar"+++++++/dev/null
$message_headers contains "MORTGAGE"+++++++/dev/null
$message_headers contains "N.exe"+++++++/dev/null
$message_headers contains "n.exe"+++++++/dev/null
$message_headers contains "n.scr"+++++++/dev/null
$message_headers contains "nanight"+++++++/dev/null
$message_headers contains "naoresponda"+++++++/dev/null
$message_headers contains "nosso curso"+++++++/dev/null
$message_headers contains "nvitation"+++++++/dev/null
$message_headers contains "o-ut"+++++++/dev/null
$message_headers contains "O.exe"+++++++/dev/null
$message_headers contains "o.exe"+++++++/dev/null
$message_headers contains "o.scr"+++++++/dev/null
$message_headers contains "Oi Meu Amor"+++++++/dev/null
$message_headers contains "olex"+++++++/dev/null
$message_headers contains "ORÇAMENTO PZ"+++++++/dev/null
$message_headers contains "osseously"+++++++/dev/null
$message_headers contains "oth-e"+++++++/dev/null
$message_headers contains "oto do Colegio"+++++++/dev/null
$message_headers contains "oto do colegio"+++++++/dev/null
$message_headers contains "p-op"+++++++/dev/null
$message_headers contains "P.exe"+++++++/dev/null
$message_headers contains "p.exe"+++++++/dev/null
$message_headers contains "p.scr"+++++++/dev/null
$message_headers contains "pare-de fumar-agora"+++++++/dev/null
$message_headers contains "peni"+++++++/dev/null
$message_headers contains "penni"+++++++/dev/null
$message_headers contains "Pertinho de voce"+++++++/dev/null
$message_headers contains "Pfizer"+++++++/dev/null
$message_headers contains "pianos semi"+++++++/dev/null
$message_headers contains "pianoszimmermann"+++++++/dev/null
$message_headers contains "polobras"+++++++/dev/null
$message_headers contains "porn"+++++++/dev/null
$message_headers contains "porpnefgddftnainter"+++++++/dev/null
$message_headers contains "provenance"+++++++/dev/null
$message_headers contains "puss"+++++++/dev/null
$message_headers contains "Q.exe"+++++++/dev/null
$message_headers contains "q.exe"+++++++/dev/null
$message_headers contains "q.scr"+++++++/dev/null
$message_headers contains "questionamento"+++++++/dev/null
$message_headers contains "R.exe"+++++++/dev/null
$message_headers contains "r.exe"+++++++/dev/null
$message_headers contains "r.scr"+++++++/dev/null
$message_headers contains "raffic magnet"+++++++/dev/null
$message_headers contains "re ["+++++++/dev/null
$message_headers contains "Re["+++++++/dev/null
$message_headers contains "re["+++++++/dev/null
$message_headers contains "ready"+++++++/dev/null
$message_headers contains "relax"+++++++/dev/null
$message_headers contains "Relogio"+++++++/dev/null
$message_headers contains "relogio"+++++++/dev/null
$message_headers contains "Relógio"+++++++/dev/null
$message_headers contains "relógio"+++++++/dev/null
$message_headers contains "Rememb"+++++++/dev/null
$message_headers contains "remkttg0"+++++++/dev/null
$message_headers contains "renda adicional"+++++++/dev/null
$message_headers contains "rivertoys"+++++++/dev/null
$message_headers contains "répli"+++++++/dev/null
$message_headers contains "S.exe"+++++++/dev/null
$message_headers contains "s.exe"+++++++/dev/null
$message_headers contains "s.scr"+++++++/dev/null
$message_headers contains "s0ft"+++++++/dev/null
$message_headers contains "Salary"+++++++/dev/null
$message_headers contains "SammyMccarty"+++++++/dev/null
$message_headers contains "se-xual"+++++++/dev/null
$message_headers contains "selecionar.c"+++++++/dev/null
$message_headers contains "selecionar.n"+++++++/dev/null
$message_headers contains "selecionar.o"+++++++/dev/null
$message_headers contains "selecionar.z"+++++++/dev/null
$message_headers contains "sensat-ion"+++++++/dev/null
$message_headers contains "sex"+++++++/dev/null
$message_headers contains "sinuca.net"+++++++/dev/null
$message_headers contains "siteagoraemfoco"+++++++/dev/null
$message_headers contains "Softabs"+++++++/dev/null
$message_headers contains "sorghum"+++++++/dev/null
$message_headers contains "squeca as dificuldades"+++++++/dev/null
$message_headers contains "squeça as dificuldades"+++++++/dev/null
$message_headers contains "ste curso voc"+++++++/dev/null
$message_headers contains "superzille"+++++++/dev/null
$message_headers contains "T.exe"+++++++/dev/null
$message_headers contains "t.exe"+++++++/dev/null
$message_headers contains "t.scr"+++++++/dev/null
$message_headers contains "t0ck"+++++++/dev/null
$message_headers contains "Traffic Magnet"+++++++/dev/null
$message_headers contains "Traffic magnet"+++++++/dev/null
$message_headers contains "traffic Magnet"+++++++/dev/null
$message_headers contains "treinar dirigir"+++++++/dev/null
$message_headers contains "treinar e dirigir"+++++++/dev/null
$message_headers contains "U.exe"+++++++/dev/null
$message_headers contains "u.exe"+++++++/dev/null
$message_headers contains "u.scr"+++++++/dev/null
$message_headers contains "uaaraantees"+++++++/dev/null
$message_headers contains "UAIG"+++++++/dev/null
$message_headers contains "uck"+++++++/dev/null
$message_headers contains "uesc"+++++++/dev/null
$message_headers contains "UPBP"+++++++/dev/null
$message_headers contains "upbp"+++++++/dev/null
$message_headers contains "v-i-a-gra"+++++++/dev/null
$message_headers contains "V.exe"+++++++/dev/null
$message_headers contains "v.exe"+++++++/dev/null
$message_headers contains "v.scr"+++++++/dev/null
$message_headers contains "Vallium"+++++++/dev/null
$message_headers contains "Viiagrra"+++++++/dev/null
$message_headers contains "VlAGRA"+++++++/dev/null
$message_headers contains "vmqgnmomh"+++++++/dev/null
$message_headers contains "voce esta no meio encostado na arvore"+++++++/dev/null
$message_headers contains "voce esta no meio encostado na árvore"+++++++/dev/null
$message_headers contains "voce está no meio encostado na árvore"+++++++/dev/null
$message_headers contains "você esta no meio encostado na árvore"+++++++/dev/null
$message_headers contains "você está no meio encostado na arvore"+++++++/dev/null
$message_headers contains "você está no meio encostado na árvore"+++++++/dev/null
$message_headers contains "voxcar"+++++++/dev/null
$message_headers contains "Voç"+++++++/dev/null
$message_headers contains "voç"+++++++/dev/null
$message_headers contains "W.exe"+++++++/dev/null
$message_headers contains "w.exe"+++++++/dev/null
$message_headers contains "w.scr"+++++++/dev/null
$message_headers contains "W32"+++++++/dev/null
$message_headers contains "wanessa.info"+++++++/dev/null
$message_headers contains "WATCH"+++++++/dev/null
$message_headers contains "weather"+++++++/dev/null
$message_headers contains "X.exe"+++++++/dev/null
$message_headers contains "x.exe"+++++++/dev/null
$message_headers contains "x.scr"+++++++/dev/null
$message_headers contains "xoomer"+++++++/dev/null
$message_headers contains "Y.exe"+++++++/dev/null
$message_headers contains "y.exe"+++++++/dev/null
$message_headers contains "y.scr"+++++++/dev/null
$message_headers contains "yeshiva"+++++++/dev/null
$message_headers contains "Z.exe"+++++++/dev/null
$message_headers contains "z.exe"+++++++/dev/null
$message_headers contains "z.scr"+++++++/dev/null
EOF


cd /var/cpanel/users
for user in $(find *); do

if cp -rf /home/.filter /home/$user/.filter && chown $user.$user /home/$user/.filter; then

echo "Filtro aplicado em: $user"

fi
done

rm -rf /home/.filter

echo "Filtro aplicado com sucesso!"