MySQL Query para consulta

[lucas502 2]

Olá galera, então, preciso de uma query para fazer uma consulta no banco de dados, mas também gostaria de agrupa-los, por exemplo, se a consulta me retornar 2 resultados iguais, eles vão ficando "parelhos" um abaixo do outro no resultado final.

 

 

Objetivo: Encontrar itens clonados, é isso mesmo ;p. Coloquei aquele sistema de IDs em cada item vip da loja, até consigo fazer a consulta, mas como tem muitos items, fica dificil procurar no olho quais estão com o mesmo ID.

 

Eu uso esta query para fazer a consulta "desorganizada":

 

SELECT `player_id`,`pid`,`sid`,CONVERT(  `attributes` USING latin1 ) FROM  `player_items` WHERE CONVERT(  `attributes` USING latin1 ) LIKE '%description%'

 

 

Com ela, eu consigo ver todos os resultados, mostrando cada "ID" de cada item, mas como citei anteriormente, são muitos items, e fica realmente dificil de procurar no olho.

A solução seria implementar algo nesta query para que ela organize os resultados exatamente iguais, ou seja, os items duplicados vão ficar um abaixo do outro. Mas não sei como faz

 

 

Aguardo solução, obrigado!

[Moose 45]

qual script vc usou poste o link do post por favor.

[Moose 45]

SELECT * , SUBSTRING( CONVERT( attributes

USING latin1 )

FROM 18 ) AS 'serial'

FROM player_items

WHERE CONVERT( attributes

USING latin1 ) LIKE '%description%'

[lucas502 2]

SELECT * , SUBSTRING( CONVERT( attributes

USING latin1 )

FROM 18 ) AS 'serial'

FROM player_items

WHERE CONVERT( attributes

USING latin1 ) LIKE '%description%'

 

Quase isso, mas ainda assim não está "agrupando" os resultados idênticos um abaixo do outro, entende?

 

Pode ser que tenha um item clonado, mas um está bem em cima, e outro bem abaixo, e pra ver isso no olho é complicado, por isso queria que um ficasse abaixo do outro.

[Moose 45]

para agrupar use este:

 

 

SELECT * , SUBSTRING( CONVERT( attributes

USING latin1 ) 

FROM 18 ) AS 'duplicated serials'

FROM player_items

WHERE SUBSTRING( CONVERT( attributes

USING latin1 ) 

FROM 18 ) 

IN (

 

SELECT SUBSTRING( CONVERT( attributes

USING latin1 ) 

FROM 18 ) 

FROM player_items

WHERE CONVERT( attributes

USING latin1 ) LIKE '%description%'

GROUP BY SUBSTRING( CONVERT( attributes

USING latin1 ) 

FROM 18 ) 

HAVING COUNT( * ) >1

)

[lucas502 2]

para agrupar use este:

 

 

SELECT * , SUBSTRING( CONVERT( attributes

USING latin1 ) 

FROM 18 ) AS 'duplicated serials'

FROM player_items

WHERE SUBSTRING( CONVERT( attributes

USING latin1 ) 

FROM 18 ) 

IN (

 

SELECT SUBSTRING( CONVERT( attributes

USING latin1 ) 

FROM 18 ) 

FROM player_items

WHERE CONVERT( attributes

USING latin1 ) LIKE '%description%'

GROUP BY SUBSTRING( CONVERT( attributes

USING latin1 ) 

FROM 18 ) 

HAVING COUNT( * ) >1

)

 

Essa query trava o phpMyAdmin, fica só carregando e não realiza a consulta. Realmente trava o phpMyAdmin, não consegui fazer mais nada por uns 10 minutos.

[Moose 45]

estranho talves seja a versao do mysql no meu servidor linux uso ela pra consultar items duplicados.

[lucas502 2]

Testei em 2 versões diferentes, as 2 (em VPS diferentes) travaram.

 

 

A proposito, eu uso o sistema de colocar uma "descrição" no item, e não exatamente um "serial". Talvez há algum equivoco na query.

[Moose 45]

tem nada aver nao o description serial e so o nome que vai aparecer da coluna vc usa windows?

[lucas502 2]

Não, uso Linux (Debian 6)

 

Ainda está travando e não retornando o resultado, não entendo...

[lucas502 2]

tem nada aver nao o description serial e so o nome que vai aparecer da coluna vc usa windows?

 

Você executa essa Query no phpMyAdmin ?

 

Qual navegador?

[Lordfire 34]

SELECT `player_id`,`pid`,`sid`,CONVERT( `attributes` USING latin1 ) FROM `player_items` WHERE CONVERT( `attributes` USING latin1 ) LIKE '%description%' ORDER BY `player_id`, `pid`, `sid`;

Não sei qual a coluna do id do item, vê se chega perto. Editado Março 24, 2013 por Lordfire (veja o histórico de edições)

[lucas502 2]

SELECT `player_id`,`pid`,`sid`,CONVERT( `attributes` USING latin1 ) FROM `player_items` WHERE CONVERT( `attributes` USING latin1 ) LIKE '%description%' ORDER BY `player_id`, `pid`, `sid`;

Não sei qual a coluna do id do item, vê se chega perto.

 

Essa query é simples, ele vai mostrar TODOS os items. A query que estamos querendo é uma que agrupe apenas os que foram clonados. Ou seja, o resultado mostrará apenas os items que estão clonados. 

[9k22 205]

Rapaz, eu axo mais facil procurar manualmente. A propria Db já separa de acordo com cada ID de player.

Exemplo: em pesquisar Player_items Item_type: 2160

 

ID      PID    SID   ITEMTYPE  VALUE    ATTIBUTES
2043    103    119    2160    100    [bLOB - 2Bytes]

2043    103    120    2160    100    [bLOB - 2Bytes]
				
2043    103    121    2160    100    [bLOB - 2Bytes]
		
2043    103    122    2160    100    [bLOB - 2Bytes]
		
2043    103    123    2160    100    [bLOB - 2Bytes]
		
2044    10     108    2160    57    [bLOB - 2Bytes]
		
2046    102    111    2160    77    [bLOB - 2Bytes]
		
	

Editado Março 25, 2013 por Subyth (veja o histórico de edições)

[lucas502 2]

Rapaz, eu axo mais facil procurar manualmente. A propria Db já separa de acordo com cada ID de player.

Exemplo: em pesquisar Player_items Item_type: 2160

 

ID      PID    SID   ITEMTYPE  VALUE    ATTIBUTES
2043    103    119    2160    100    [bLOB - 2Bytes]

2043    103    120    2160    100    [bLOB - 2Bytes]
				
2043    103    121    2160    100    [bLOB - 2Bytes]
		
2043    103    122    2160    100    [bLOB - 2Bytes]
		
2043    103    123    2160    100    [bLOB - 2Bytes]
		
2044    10     108    2160    57    [bLOB - 2Bytes]
		
2046    102    111    2160    77    [bLOB - 2Bytes]
		
	

 

Sim, exatamente por isso que dificulta a procura manual, por que, os items clonados não necessariamente estarão no mesmo char, ou seja, pode estar 1 no inicio da lista, e um 1 no final da lista. Entende?

 

O certo seria agrupar pelos clonados,  e não pelos ids de cada player.

Editado Março 26, 2013 por lucas502 (veja o histórico de edições)

[playemaIcem 0]

kasyno internetowe Also some widespread video games are now on the web, as on line video poker, the well-known on line casino roulette, online black jack, casino sic bo, and numerous other game titles that are frequent in the casinos. Several senior citizens obtain casinos a wonderful resource of leisure. There is the thrill of the match and potentially successful fortunes but a lot more realistically casinos cater to the comfort and ease of seniors. Superior movie poker machines normally allow about a hundred p.c return the for a longer time you play the sport. Also, irrespective of being comparable to slot equipment, online video poker is not a match of chance. This suggests that you have an actual edge relying on your capabilities. As a result, you are not able to participate in the sport and hope a higher pay-out without having comprehending the fundamental principles and arming you with useful procedures. Casino gambling is entertaining, but it does entail some do the job. The eighth Floor Lounge is divided into 3 key spots: the bar, a seating spot with fire and buffet spot, and another seating space divided off from the first by a massive wall. The dilemma is that we are individuals and we are pushed by an factor of greed that make us forget that data exist. Inevitably, our greed will usually return to the question, "why do casinos usually earn?" If we can separate the greed from the logic, the dilemma could convert to, "why do casinos typically earn?" continue to keep this in brain every time you step into a on line casino. Try not to give into the greed. Check out to stroll away whenever you have the likelihood. Tunica Roadhouse kasyno &amp Lodge- Formally termed Sheraton, the Roadhouse offers attendees anything that could be observed in a southern juke joint, even a mechanical bull. The program at this web page is rigorously analyzed by an unbiased authority, Technical Systems Testing, on a frequent basis to guarantee fairness and randomness at all instances. A $one hundred fifty minimum amount wager for 4 several hours on Monday via Thursday or a $250 bare minimum wager for 4 several hours Friday as a result of Sunday is necessary to enter the Newport Club lounge. On holiday weekends, a $350 minimal bet is demanded. kasyna kasyna internetowe

kasyno The Tonkawa Tribe operates two casinos in Kay County with a third just one planned. The Tribe operates Indigenous Lights On line casino, north of Newkirk on Highway seventy seven and the Tonkawa On line casino west of Ponca Town and east of Tonkawa on Allen Travel. Native Lights functions around 600 devices, features poker and blackjack, and a snack bar and a beverage bar. The Tonkawa On line casino capabilities 374 equipment, a snack bar and gives black jack and poker. The Santa Fe and Texas Station do offer you bars and lounges, as nicely as film theaters much too. There are arcades attached to the movie theaters as nicely. Of system there is plenty of dining much too, buffets, eating places and cafes.The Santa Fe has been far more lately reworked, so it is significantly a lot more modern seeking and up to day. Gambling specials such as tournaments, give-a-strategies, drawings and contests are scheduled to induce consumers to occur in. Verify the casinos site for regular timetable of situations. Ask if the on line casino mails out monthly function calendars and request to be included to the mailing listing. Observe these commercials as at times they will include specials and coupons. Mornings are excellent periods to pay a visit to casinos since the attendance is small and choice seating and most loved devices are less complicated to obtain. Gambling at caesar is a combine bag. Had a pleasant blackjack dealer. Great and sweet woman but had a impolite paigow supplier. Way also delighted in using my dollars and surely faking it when he felt sorry for taking my funds. A single of the older casinos but aged extremely effectively. It is all the way south of the strip but the glimpse of it is still classy. If you get pleasure from a fewer hectic, additional civilized position to gamble I would recommend participating in in this article. The age team is older than the relaxation of the strip. Again on Highway a hundred and one, heading south, you will occur to South Bend, WA. River Entrance Lanes is positioned in this article. Bodily found at 128 West Robert Bush Travel, this compact kasyno delivers 3 poker tables and pull tab. Several hours range. Call 360-875-6773 for more information and facts. The software package at this internet site is rigorously tested by an independent authority, Technological Units Screening, on a typical foundation to assure fairness and randomness at all occasions. The Paragon cafe is the most costly cafe in Foxwoods and typically calls for reservations and its casual enterprise costume code is strictly enforced so that customer's apparel model will match that of the elegant atmosphere. kasyno kasyna internetowe