Blog
Soporte técnico
Formas de pago
Mayoristas
Trabaja con nosotros
Garantía en todas tus compras
Impresoras 3D 
1 año de garantía
Impresoras 3D
6 meses de garantía
Soporte Técnico Extendido de Lunes a Sábado de 9 a 21h
Soporte telefónico y virtual a cargo de nuestros expertos
Comprá de forma segura con Mercado Pago y Mobbex
Siempre vamos a estar disponibles para vos, contactanos por chat, teléfono o e-mail si tenés cualquier problema durante tu compra.
Tenemos promociones para vos
¡Pagá en 3 y 6 cuotas fijas.!
Tarjetas Visa y Mastercard bancarizadas
Mercado Pago
Ver promociones vigentes
CON STOCK
Consola RETRO 620 juegos con 2 Joysticks multijugador
¡ Nueva Consola de Juegos Arcade Retro Gadnic !
Ver los medios de pago
Envíos gratis a todo el país desde $50.000 
Retirá en nuestro localDESCRIPCIÓN DEL PRODUCTO
¡GADNIC llegó a TP3D!
Con la "Consola RETRO 620 juegos con 2 Joysticks multijugador”, vas a podér disfrutar de 620 juegos clásicos en modo multijugador, con imágenes claras y una experiencia de funcionamiento más fluida.
CARACTERÍSTICAS PRINCIPALES
La consola te lleva de nuevo a tu infancia con 620 juegos clásicos. Su interfaz sencilla facilita la conexión, y además, incluye dos controles para que puedas disfrutar del modo multijugador. ¡Y eso no es todo! Es compatible con salida AV, lo que la hace apta para televisores, brindándote una amplia compatibilidad.
ACCESORIOS INCLUIDOS
1 x Consola de juegos Arcade
1 x Fuente de Alimentación
1 x Cable De Carga
1 x Cable RCA
2 x Controles
ESPECIFICACIONES TÉCNICAS
Dimensiones: 12.7 x 10.2 x 4.3 Cm
Conexiones: RCA, DC IN, AV OUT
Juegos incluidos: 620 juegos
Cantidad de jugadores: 2
Dispositivos compatibles: MONITORES / TV.
Salida AV
Voltaje: 110 / 220 V
<iframe width="560" height="315" src="https://www.youtube.com/embed/WgEUzghii50?si=3EDmcpH1ddft0lYR" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen></iframe>
LISTADO DE JUEGOS
1 CONTRA 1
2 CONTRA 2
3 CONTRA 3
4 CONTRA 6
5 CONTRA 7
6 CONTRA 8
7 ROBOCOP 1
8 ROBOCOP 2
9 ROBOCOP 3
10 ROBOCOP 4
11 NINJA TURTLES 1
12 NINJA TURTLES 2
13 NINJA TURTLES 3
14 NINJA TURTLES 4
15 DOUBLE DRAGON 1
16 DOUBLE DRAGON 2
17 DOUBLE DRAGON 3
18 DOUBLE DRAGON 4
19 ADVENTURE ISLAND
20 ADVENTURE ISLAND 2
21 ADVENTURE ISLAND 3
22 ADVENTURE ISLAND 4
23 KICK MASTER
24 MORTAL COMBAT 4
25 90 TANK
26 MARIO 10
27 MARIO 12
28 MARIO 14
29 SNOW BROS
30 HOT BLOOD BASKETBALL
31 HOT BLOOD ICE HOCKY
32 HOT BLOOD NEW RECORD
33 HOT BLOOD SOCCER 2
34 HOT BLOOD VOLLEYBALL
35 ICE CLIMBER
36 KAGE
37 FINAL MISSION
38 TINY TOON 1
39 TINY TOON 2
40 TINY TOON 3
41 NINJA GAIDEM 1
42 NINJA GAIDEM 2
43 NINJA GAIDEM 3
44 CHIP&DALE 1
45 CHIP&DALE 2
46 CHIP&DALE 3
47 HOT BLOOD WRESTLE
48 HOT BLOOD STORY
49 HOT BLOOD SOCCER 1
50 HOT BLOOD MARCH
51 STREET FIGHTER 2010
52 KICK MASTER
53 MIGHTY FINAL FIGHT
54 STREET FIGHTER
55 MORTAL COMABAT 4
56 ASTYANAX
57 THREE EYES BOY
58 SNOW BROS
59 SPIDERMAN
60 BATMAN
61 KYUUKYOKU TIGER
62 POWER BANGER
63 GULF WAR
64 GUBBLE BOBBLE2
65 GUERILLA WAR
66 DEAD FOX
67 POWER BLADE 1
68 P.O.W
69 JUNGLE BOOK
70 AIR WOLF
71 BRUCE LEE 2
72 BANANA PRINCE
73 SAINT
74 ROCKIN KATS
75 JUUOUKI
76 GUNNAC
77 IKARI 3
78 WHOMP'EM
79 WAR WOLF
80 CAPTAIN TSUBASA VO
81 10 YARD FIGHT
82 ANTARCTIC RDVENTUR
83 ARABIAN
84 BALLOON FIGHT
85 BASE BALL
86 BINARY LAND
87 BIRD WEEK
88 BOMBER MAN
89 BOMB SWEEPER
90 BRUSH ROLLER
91 BURGER TIME
92 CHACK AND POP
93 CHESS
94 CIRCUS CHARLIE
95 CLU CLU LAND
96 COMBAT
97 DEFENDER
98 DEVIL WORLD
99 DIG DUG 1
100 DONKEY KONG 1
101 DONKEY KONG 2
102 DONKEY KONG 3
103 DONKEY KONG JR MATH
104 DOOR DOOR
105 EXCITE BIKE
106 EXERION
107 F1 RACE
108 FORMATION Z
109 FRONT LINE
110 GALAGA
111 GALAXIAN
112 GOLF
113 RAID ON BUNGELING
114 HYPER OLYMPIC
115 HYPER SPORTS
116 JOUST
117 KARATERA
118 LODE RUNNER
119 LUNAR BALL
120 MACROSS
121 MAGIC JEWELRY
122 MAHJONG 4P
123 MAHJONG 2P
124 MAPPY
125 MARIO BROS
126 MILK&NUTS
127 MILLIPEDE
128 MUSCLE
129 NAITOU
130 NIBBLES
131 NINJA 1
132 NINJA 3
133 ROAD FIGHTER
134 OTHELLO
135 PACMAN
136 PIN BALL
137 POOYAN
138 POPEYE
139 SKY DESTROYER
140 SPACE ET
141 STAR FORCE
142 TENNIS
143 URBAN CHAMPION
144 WARPMAN
145 YIE AR KUNG FU
146 ZIPPY RACE
147 1942
148 ARKANOID
149 ASTRO ROBO SASA
150 B WINGS
151 BADMINTON
152 BALTRON
153 BOKOSUKA WARS
154 BOMB JACK
155 PORTER
156 CHUBBY CHERUB
157 DESTROY
158 DIG DUG 2
159 DOUGH BOY
160 DRAGON
161 DRUAGA
162 DUCK
163 ELEVATOR ACTION
164 EXED EXES
165 FLAPPY
166 FRUIT PIG
167 GALG
168 GEIMOS
169 GYRODINE
170 HEXA
171 ICE HOCKEY
172 LOT LOT
173 MAGMAX
174 PIKA CHU
175 NINJA 2
176 OBAKE
177 ONYANKO TOWN
178 PAC LAND
179 PACHI COM
180 PRO WRESTLING
181 PYRAMID
182 ROUTE-16
183 SEICROSS
184 SLALOM
185 SOCCER
186 SONSON
187 SPARTAN X
188 SPELUNKER
189 SPY VS SPY
190 SQOON
191 STAR LUSTER
192 SUPER MARIO
193 TETRIS 2
194 THEXDER
195 VOLGUARD II
196 VOLLEY BALL
197 WARS
198 XEVIOUS
199 CHINESE CHESS
200 CHALLENGER
201 MACH RIODER
202 SUDOKU
203 AQUARIUM
204 AREAN
205 AIR ALERT
206 AWFUL RUSHING
207 AIMLESS
208 BURBLES
209 BURROW EXPLORER
210 BUG'S WAR
211 BOMB KING
212 BASEBALL NEW
213 BUBBLE
214 CANNONADE
215 COAST GUARD
216 CUB ADVENTURE
217 DEPTH BOMB
218 DEVILDOM DOOM
219 DIAMOND
220 DUNE WAR
221 FIREBASE
222 FIRST DEFENDER
223 FIVE DAYS
224 FIVE MOUSE
225 FRUIT DISH
226 GALLAGANT
227 GARDEN WAR
228 GATE
229 HALLIHOO
230 HEXAPOD NEW
231 HEXAPOD WAR
232 LABYRINTH
233 LUNARIAN
234 MAD XMAS
235 MOTOBOAT
236 PANZER ATTZCK
237 PENTA BASE
238 POBBLE
239 POLAR BAT
240 RURALGOBLIN
241 ROBOT
242 SEASON GARDEN
243 SHREW MOUSE
244 SNOWBALL
245 STAR FIGHTER
246 STRAFE
247 SMALL DINOSAUR
248 SILENT HUNTER
249 THE ARCHER
250 TWIN CARDS
251 UNDERSEA ARENA
252 WARRIOR
253 ABSCONDEE
254 AETHER CRUISER
255 AIM CRUISE
256 ANIMALCONTEST
257 BLOCKSWORLD
258 BUGCATCHER
259 BUSY BAR
260 CANDY WORKSHOP
261 CONTEST
262 COOKIES LABYRINTH
263 CRYSTAL BLAST
264 DEFORMABLE
265 DEJECTILE
266 EGG CONTEST
267 ESCAPEWAY
268 FAIR'S TREASURE
269 FALLING BLOCKS
270 FATED PIRATE
271 FINAL BLOOD
272 FISH STORY
273 FLING BALL
274 FORESTADVENTURE
275 FRUIT GIFT
276 GHOST CASTLE
277 GOLDEN BIRD
278 GREEDS
279 HAMMER&NAIL
280 HAPPYMATCH
281 ICE OCEAN
282 IQ CHAMPION
283 ISLAND
284 JUMP JUMP
285 JUMPING KID
286 LIGHTING
287 LITTLE WITCH
288 MAGIC EGG
289 MAN IN RED
290 MECCANO
291 MIRROR DEVIL WORD
292 MOUSE SNARE
293 MOUSE HERO
294 MOWING
295 NUT CRACKY
296 CRYSTAL BALL
297 POLICE DOG LASY
298 POLICE VS THIEF
299 PONGPONG
300 POWER ROBOT
301 PULVERATION
302 RABBITVILLAGE
303 RIVER JUMP
304 SEAPORT GUART
305 SEAWOLF
306 SPACE BASE
307 SPIDERMAN 2
308 SPIDERMAN 1
309 SPRING WORLD
310 STAR
311 SUBMARINE
312 THROUGHMAN
313 TOY FACTORY
314 UTMOST WARFARE
315 VIGILANT
316 WARZONE
317 WATER PIPE
318 WILDWORM
319 WONDER BALL
320 MOVE B0X
321 COLOR FULL DRAGON
322 BACK FUTURE
323 ARKISTA RING
324 BANDAI GOLF
325 CASTLE EXCELLENT
326 TIGER HEIL
327 THE UNIVERSE SOLD
328 DASH GALAXY
329 Q-BERT
330 EGYPT
331 ALPHA MISSION
332 FIREHOUSE RESCUE
333 I CAN REMEMBER
334 HOKUTO NO KEN
335 CHITEI TANKEN
336 BATTLE SHIP
337 SECRET CASTLE
338 DEST EARTHSTAR
339 TRUCK RALLY
340 BINGO 75
341 BUMP N JUMP
342 DINO RIKI
343 GHOST BUSTERS
344 SPY HUNTER
345 PAPER BOY
346 TENAGEHU TANT
347 BATTLE TANK
348 ALADDIN 3
349 TECKO BOWL
350 MICKEY MOUSE
351 QUARTH
352 MO YA JIN
353 GRADIUS
354 MYSTERY
355 FRIDAY THE 13
356 634 KEN
357 BOOT CAT
358 HELLO KIDY
359 SOLOMONS KEY
360 FLIPULL
361 DEBLOCK
362 BOWLING
363 SPACE HUNTER
364 TRANSFORMES
365 KARAKI
366 CADIL
367 WOTER PIP
368 QUARTERBACK
369 KARATE CHAMP
370 KING KNIGHT
371 DAISAKUSEN
372 VENICE BEACH VOLL
373 SANRIO CARNIVAL
374 SKY KID
375 PON PON VOLLEY
376 SANSUU 1
377 SANSUU 2
378 SANSUU 3
379 SANSUU 4
380 SANSUU 5
381 SHOCKWAVE
382 TILES OF FATE
383 TSUPPARI OOZUMOU
384 DENSETSU
385 COSMOS COP
386 BAR GAMES
387 BUGGY POPPER
388 LI MA SHIN DIAN
389 METAL FIGHTER
390 PIPE DREAM
391 ATLANTIS
392 CYBRNOID
393 CITY CONNECTION
394 CHOP LIFTER
395 TWIM BEE
396 LEGEND OF KAGE
397 DR MARIO
398 GOONIES
399 GYRUSS
400 WISDOM
401 POWER ROBOT
402 PULVERATION
403 RABBITVILLAGE
404 RIVER JUMP
405 SEAPORT GUARL
406 SEAWOLF
407 SPACE BASE
408 SPIDERMAN 2
409 SPIDERMAN 1
410 SPRING WORLD
411 STAR
412 SUBMARINE
413 THROUGHMAN
414 TOY FACTORY
415 UTMOST WARFARE
416 VIGILANT
417 WARZONE
418 WATER PIPE
419 WILDWORM
420 WONDER BALL
421 MOVE B0X
422 COLOR FULL DRAGON
423 BACK FUTURE
424 ARKISTA RING
425 BANDAI GOLF
426 CASTLE EXCELLENT
427 TIGER HELI
428 THE UNIVERSE SOLD
429 DASH GALAXY
430 Q-BERT
431 EGYPT
432 ALPHA MISSION
433 FIREHOUSE RESCUE
434 I CAN REMEMBER
435 HOKUTO NO KEN
436 CHITEI TANKEN
437 BATTLE SHIP
438 SECRET CASTLE
439 DEST EARTHSTAR
440 TRUCK RALLY
441 BINGO 75
442 BUMP N JUMP
443 DINO RIKI
444 GHOST BUSTERS
445 SPY HUNTER
446 PAPER BOY
447 TENAGEHU TANT
448 BATTLE TANK
449 ALADDIN 3
450 TECKO BOWL
451 MICKEY MOUSE
452 QUARTH
453 MO YA JIN
454 GRADIUS
455 MYSTERY
456 FRIDAY THE 13
457 634 KEN
458 BOOT CAT
459 HELLO KIDY
460 SOLOMONS KEY
461 FLIPULL
462 DEBLOCK
463 BOWLING
464 SPACE HUNTER
465 TRANSFORMES
466 KARAKI
467 CADIL
468 WOTER PIP
469 QUARTERBACK
470 KARATE CHAMP
471 KING KNIGHT
472 DAISAKUSEN
473 VENICE BEACH VOLL
474 SANRIO CARNIVAL
475 SKY KID
476 PON PON VOLLEY
477 SANSUU 1
478 SANSUU 2
479 SANSUU 3
480 SANSUU 4
481 SANSUU 5
482 SHOCKWAVE
483 TILES OF FATE
484 TSUPPARI OOZUMOU
485 DENSETSU
486 COSMOS COP
487 BAR GAMES
488 BUGGY POPPER
489 LI MA SHIN DIAN
490 METAL FIGHTER
491 PIPE DREAM
492 ATLANTIS
493 CYBRNOID
494 CITY CONNECTION
495 CHOP LIFTER
496 TWIM BEE
497 LEGEND OF KAGE
498 GOONIES
499 GYRUSS
500 WISDOM
501 CHESS
502 CIRCUS CHARLIE
503 CLU CLU LAND
504 COMBAT
505 DEFENDER
506 DEVIL WORLD
507 DIG DUG 1
508 DONKEY KONG 1
509 DONKEY KONG 2
510 DONKEY KONG 3
511 DONKEY KONG JR MA
512 DOOR DOOR
513 EXCITE BIKE
514 EXERION
515 F1 RACE
516 FORMATION Z
517 FRONT LINE
518 GALAGA
519 GALAXIAN
520 GOLF
521 RAID ON BUNGELING
522 HYPER OLYMPIC
523 HYPER SPORTS
524 JOUST
525 KARATERA
526 LODE RUNNER
527 LUNAR BALL
528 MACROSS
529 MAGIC JEWELRY
530 MAHJONG 4P
531 MAHJONG 2P
532 MAPPY
533 MARIO BROS
534 MILK&NUTS
535 MILLIPEDE
536 MUSCLE
537 NAITOU
538 NIBBLES
539 NINJA 1
540 NINJA 3
541 ROAD FIGHTER
542 OTHELLO
543 PACMAN
544 PIN BALL
545 POOYAN
546 POPEYE
547 SKY DESTROYER
548 SPACE ET
549 STAR FORCE
550 TENNIS
551 URBAN CHAMPION
552 WARPMAN
553 YIE AR KUNG FU
554 ZIPPY RACE
555 1942
556 ARKANOID
557 ASTRO ROBO SASA
558 B WINGS
559 BADMINTON
560 BALTRON
561 BOKOSUKA WARS
562 BOMB JACK
563 PORTER
564 CHUBBY CHERUB
565 DESTROY
566 DIG DUG 2
567 DOUGH BOY
568 DRAGON
569 DRUAGA
570 DUCK
571 ELEVATOR ACTION
572 EXED EXES
573 FLAPPY
574 FRUIT PIG
575 GALG
576 GEIMOS
577 GYRODINE
578 HEXA
579 ICE HOCKEY
580 LOT LOT
581 MAGMAX
582 PIKA CHU
583 NINJA 2
584 OBAKE
585 ONYANKO TOWN
586 PAC LAND
587 PACHI COM
588 PRO WRESTLING
589 PYRAMID
590 ROUTE-16
591 SEICROSS
592 SLALOM
593 SOCCER
594 SONSON
595 SPARTAN X
596 SPELUNKER
597 SPY VS SPY
598 SQOON
599 STAR LUSTER
600 SUPER MARIO
601 TETRIS 2
602 THEXDER
603 VOLGUARD II
604 VOLLEY BALL
605 WARS
606 XEVIOUS
607 CHINESE CHESS
608 CHALLENGER
609 MACH RIODER
610 SUDOKU
611 AQUARIUM
612 AREAN
613 AIR ALERT
614 AWFUL RUSHING
615 AIMLESS
616 BURBLES
617 BURROW EXPLORER
618 BUG'S WAR
619 BOMB KING
620 BASEBALL NEW
Documentación
12 meses de garantía
Servicio TécnicoBrindamos soporte post venta directo gracias a nuestro equipo especializado. ¿Tenes alguna duda o inconveniente? Estamos para ayudarte!
Si comprás Consola RETRO 620 juegos con 2 Joysticks multijugador tal vez te pueda interesar
Productos similares
|
Modo de Diseño: Parámetros Internos del Sitio Web |
| Ws_ID: 436f3695-87e5-4eec-b829-3ebef1fdcb88 |
| Page_Id: d7bdca12-2b67-4aea-a267-dc8b93edfe00 |
| WSU_Id: -1 |
| Parámetros de la Página: ;Consola-RETRO-620-juegos-con-2-Joysticks-multijugador;ITEM_ID=2587;GBPWSTID=436f3695-87e5-4eec-b829-3ebef1fdcb88; |
| Cart Guid: c846360d-2316-498b-9039-36df7585efd8 |
|
Estados Internos * cust_id:-1 * st_id:1 * dl_id:1 * cc_id:-1 * ccp_id:-1 * Cuotas:-1 * disc_id:1 * bra_id:1 * prli_id:1 * prof_id:1 * stor_id:21 * item_id:-1 * camp_id:-1 * |
| Comp_Id: 1 |
| Lang_Id: 2 |
| 3.139.97.157 |
| * WebSite Designer * |
|
|
|
Tiempo Total de Proceso: 5 Segundos. Ultimos SQL Ejecutados: GBP_LIST: ITEM SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tc.Size_desc, tc.Size_desc, '', '' FROM tbWebSiteII_SizeColorPlusMercadoLibreVariations tc INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = tc.comp_id AND tpli.item_id = tc.item_id_child AND tpli.prli_id = 1 AND tpli.ws_id = '436f3695-87e5-4eec-b829-3ebef1fdcb88' WHERE tc.item_id = 2587 and tc.comp_id=1 GROUP BY tc.Size_desc ORDER BY tc.Size_desc Tiempo Consumido: 00:00:00.0312463 GBP_LIST: ITEM SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tc.item_id_child, REPLACE(tc.color_desc, '&', 'y'), tc.size_desc, '' FROM tbWebSiteII_SizeColorPlusMercadoLibreVariations tc INNER JOIN tbWebSiteII_itemsData tid on tc.item_id_child = tid.item_id WHERE tc.item_id = 2587 and tc.comp_id=1 and tid.semaphoreValue » 1 GROUP BY tc.item_id_child, tc.color_desc, tc.Size_desc ORDER BY tc.color_desc Tiempo Consumido: 00:00:00.0312497 GBP_LIST: ITEM SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tc.item_id_child, CASE WHEN -1 = -1 AND '' <> '' THEN (SELECT '') else REPLACE(format(convert(decimal(16,0), tpli.prli_price), 'N', 'de-de'),',00','') END [price], dbo.fnStrAllTrim(tpli.currency_symbol), tc.Item_id, tc.bestSemaphoreValueInVariations FROM tbWebSiteII_SizeColorPlusMercadoLibreVariations tc INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = tc.comp_id AND tpli.item_id = tc.item_id_child AND tpli.prli_id = 1 AND tpli.ws_id = '436f3695-87e5-4eec-b829-3ebef1fdcb88' WHERE tc.item_id = 2587 AND tc.comp_id=1 AND tpli.ws_id = '436f3695-87e5-4eec-b829-3ebef1fdcb88' GROUP BY tc.item_id_child, tpli.prli_price,tpli.currency_symbol,tc.Item_id, tc.bestSemaphoreValueInVariations Tiempo Consumido: 00:00:00.0468714 GBP_REPLACE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ti.item_id, CASE WHEN ti.item_website_desc<>'' THEN ti.item_website_desc ELSE ti.item_desc END [item_desc], dbo.fnStrAllTrim(ti.item_code) [item_code], ti.item_annotation1 FROM tbitem ti WHERE ti.item_id = 2587 Tiempo Consumido: 00:00:00 GBP_REPLACE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ISNULL(tis_id,0) FROM [vwWebSiteII_tempItemStock] WHERE tis_guid = 'c846360d-2316-498b-9039-36df7585efd8' and (item_id =2211 OR item_id=1286) Tiempo Consumido: 00:00:00.0156294 GBP_REPLACE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT CASE WHEN COUNT(tc.item_id) » 0 THEN 'block' ELSE 'none' END [mostrar], CASE WHEN COUNT(tc.item_id) » 0 THEN 'none' ELSE 'block' END [no_mostrar] FROM tbitem ti LEFT JOIN vwWebSiteII_itemSizeColorPlusMeLi tc ON tc.comp_id = ti.comp_id AND tc.item_id = ti.item_id WHERE ti.item_id = 2587 and ti.comp_id=1 GROUP BY tc.item_id Tiempo Consumido: 00:00:00.0468748 GBP_REPLACE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT cust_name FROM tbCustomer WHERE cust_id = -1 Tiempo Consumido: 00:00:00 GBP_REPLACE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT convert (decimal(16,2), dbo.fnGetExchange2('1', 1, 2,1, 0, 0, 0, 'False')) Tiempo Consumido: 00:00:00 GBP_REPLACE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ws_newCustomerAllowed, ws_manage_showStockSemaphore , ws_manage_hidePricesIfNotLogged FROM tbWebSiteII_Names WHERE comp_id=1 AND ws_id = '436f3695-87e5-4eec-b829-3ebef1fdcb88' Tiempo Consumido: 00:00:00 GBP_REPLACE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ti.item_made, ti.item_newness, tpli.semaphoreValue, ti.Item_id, CASE WHEN ti.item_website_desc<>'' THEN SUBSTRING (ti.item_website_desc, 1, 75) ELSE SUBSTRING (ti.item_desc, 1, 75) END [item_desc], SUBSTRING (ti.item_annotation1, 1, 18), dbo.fnStrAllTrim(ti.item_code) [item_code], ti.item_vendorCode, ti.brand_id, ti.item_annotation1, REPLACE(ti.item_annotation2, Char(10), '«br/»'), SUBSTRING (ti.item_annotation2, 1, 100), ti.item_descHTML, tbn.wssn_isNovelty, tbn.wssn_is4Sale, item_WebSite_vendorPage, -- PRECIO ESTANDAR REPLACE(format(convert(decimal(16,0), tpli.prli_price), 'N', 'de-de'),',00',''), convert(decimal(16,0), tpli.prli_price), -- MERCADOPAGO format(1.0760 * tpli.prli_price, 'N', 'de-de') AS 'Numeric Format', -- TARJETA 1 CUOTA format(1.10 * tpli.prli_price, 'N', 'de-de') AS 'Numeric Format', -- TARJETA 12 CUOTAS format(1.56 * tpli.prli_price, 'N', 'de-de') AS 'Numeric Format', -- TARJETA 18 CUOTAS format(1.94 * tpli.prli_price, 'N', 'de-de') AS 'Numeric Format', convert(decimal(16,2), 1.56 * tpli.prli_price/12), convert(decimal(16,2), 1.94 * tpli.prli_price/18), tc.curr_symbol, tbr.brand_desc, tcat.cat_desc, tsub.subcat_desc, tcat.cat_id, tsub.subcat_id, convert (decimal(16,2), ttn.tax_percentage) [IVA], REPLACE(ti.item_code,'/','--'), CASE WHEN ti.item_NoStockCheck='true' AND ti.item_web = 'true' AND (ti.item_isForAssociation='false' OR ti.item_annotation1 like '%@@GRISAR%' ) THEN 'True' ELSE 'False' END [grisar_boton], CASE WHEN (tpli.itst_cant «= 0) THEN 0 ELSE CAST(tpli.itst_cant AS INT) END, tpli.itst_LastAvailableInRelalculation FROM tbitem ti INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = ti.comp_id AND tpli.item_id = ti.item_id AND tpli.prli_id = 1 AND tpli.ws_id = '436f3695-87e5-4eec-b829-3ebef1fdcb88' INNER JOIN tbsysCurrency tc ON tc.curr_id = tpli.curr_id INNER JOIN tbBrand tbr ON ti.brand_id = tbr.brand_id INNER JOIN tbCategory tcat ON tcat.cat_id = ti.cat_id INNER JOIN tbSubCategory tsub ON tsub.subcat_id = ti.subcat_id LEFT JOIN tbWebSiteII_Items_NoveltyAnd4Sale tbn ON tbn.comp_id = ti.comp_id AND ti.item_id = tbn.item_id AND tbn.ws_id = '436f3695-87e5-4eec-b829-3ebef1fdcb88' LEFT JOIN tbItemTaxes tit ON tit.item_id=ti.item_id AND tit.comp_id=ti.comp_id LEFT JOIN tbTaxName ttn ON ttn.tax_id=tit.tax_id AND ttn.comp_id=tit.comp_id and ttn.tax_class=1 WHERE ti.item_id = 2587 Tiempo Consumido: 00:00:00.1093670 GBP_LIST: GALERIADETALLE SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tii.itimg_id ,ti.item_desc FROM tbItemImages tii INNER JOIN tbItem ti ON ti.item_id = tii.item_id WHERE tii.item_id = 2587 ORDER BY tii.itimg_order ASC Tiempo Consumido: 00:00:00.0156246 GBP_LIST: LISTADODOCUMENTOS SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tpdf.itpdf_id , ISNULL(tpdf.itpdf_desc,'') FROM tbItemPDF tpdf WHERE tpdf.item_id = 2587 AND tpdf.comp_id = 1 ORDER BY tpdf.itpdf_order Tiempo Consumido: 00:00:00.0156246 GBP_REPLACE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ti.item_id, ti.subcat_id FROM tbitem ti WHERE ti.item_id = 2587 Tiempo Consumido: 00:00:00 GBP_LIST: BODY_LIQ SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tpli.item__made, tpli.semaphoreValue, tpli.Item_id, SUBSTRING (tpli.item__WebSite_desc, 1, 50), SUBSTRING (tpli.item__annotation1, 1, 20), dbo.fnStrAllTrim(tpli.item__code) [item_code], tpli.item__vendorCode, tpli._brand_id, tpli.item__annotation2, SUBSTRING (tpli.item__annotation2, 1, 90), tbn.wssn_isNovelty, tbn.wssn_is4Sale, CASE WHEN -1 = -1 AND '' <> '' THEN (SELECT '') else REPLACE(format(convert(decimal(16,0), tpli.prli_price), 'N', 'de-de'),',00','') END [price], tpli.currency_symbol, tpli._brand_desc, CASE WHEN i4c.item_id = tpli.item_id THEN '«a href=http://gbp67.globalbluepoint.com/tp3d/COMPARA/X/GBPWSTID=436f3695-87e5-4eec-b829-3ebef1fdcb88/gbpwst.aspx»Ver Comparacion«/a»' else 'Comparar' END [checked], convert (decimal(16,2), ttn.tax_percentage) [IVA], SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(tpli.item__WebSite_desc), 1, 100), REPLACE(dbo.fnStrAllTrim(tpli.item__code),'/','--') FROM tbItemAdditional tia INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = tia.comp_id AND tpli.item_id = tia.item_id_1 AND tpli.prli_id = 1 AND tpli.ws_id = '436f3695-87e5-4eec-b829-3ebef1fdcb88' INNER JOIN tbSubCategory tsub ON tsub.subcat_id = tpli.subcat_id INNER JOIN tbCategory tcat ON tcat.cat_id = tpli.cat_id LEFT JOIN tbWebSiteII_Items_NoveltyAnd4Sale tbn ON tbn.comp_id = tpli.comp_id AND tpli.item_id = tbn.item_id AND tbn.ws_id = '436f3695-87e5-4eec-b829-3ebef1fdcb88' LEFT JOIN tbWebSiteII_TMPItem4Compare i4c On i4c.item_id = tpli.item_id and i4c.ws_guid = 'c846360d-2316-498b-9039-36df7585efd8' LEFT JOIN tbItemTaxes tit ON tit.item_id=tpli.item_id AND tit.comp_id=tpli.comp_id LEFT JOIN tbTaxName ttn ON ttn.tax_id=tit.tax_id AND ttn.comp_id=tit.comp_id and ttn.tax_class=1 WHERE tia.item_id = 2587 Tiempo Consumido: 00:00:00.0624917 GBP_REPLACE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ti.item_id, ti.subcat_id FROM tbitem ti WHERE ti.item_id = 2587 Tiempo Consumido: 00:00:00 GBP_LIST: BODY_LIQ SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ti.item_made, tpli.semaphoreValue, ti.Item_id, CASE WHEN ti.item_website_desc<>'' THEN SUBSTRING (ti.item_website_desc, 1, 50) ELSE SUBSTRING (ti.item_desc, 1, 50) END [item_desc], SUBSTRING (ti.item_annotation1, 1, 20), dbo.fnStrAllTrim(ti.item_code) [item_code], ti.item_vendorCode, ti.brand_id, ti.item_annotation2, SUBSTRING (ti.item_annotation2, 1, 90), tbn.wssn_isNovelty, tbn.wssn_is4Sale, item_WebSite_vendorPage, CASE WHEN -1 = -1 AND '' <> '' THEN (SELECT '') else REPLACE(format(convert(decimal(16,0), tpli.prli_price), 'N', 'de-de'),',00','') END [price], tc.curr_symbol, tbr.brand_desc, CASE WHEN i4c.item_id = ti.item_id THEN '«a href=http://gbp67.globalbluepoint.com/tp3d/COMPARA/X/GBPWSTID=436f3695-87e5-4eec-b829-3ebef1fdcb88/gbpwst.aspx»Ver Comparacion«/a»' else 'Comparar' END [checked], convert (decimal(16,2), ttn.tax_percentage) [IVA], CASE WHEN ti.item_website_desc<>'' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(ti.item_website_desc), 1, 100) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(ti.item_desc), 1, 100) END [item_desc] , REPLACE(ti.item_code,'/','--') FROM tbitem ti INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = ti.comp_id AND tpli.item_id = ti.item_id AND tpli.prli_id = 1 AND tpli.ws_id = '436f3695-87e5-4eec-b829-3ebef1fdcb88' INNER JOIN tbsysCurrency tc ON tc.curr_id = tpli.curr_id INNER JOIN tbBrand tbr ON ti.brand_id = tbr.brand_id INNER JOIN tbSubCategory tsub ON tsub.subcat_id = ti.subcat_id INNER JOIN tbCategory tcat ON tcat.cat_id = ti.cat_id LEFT JOIN tbWebSiteII_Items_NoveltyAnd4Sale tbn ON tbn.comp_id = ti.comp_id AND ti.item_id = tbn.item_id AND tbn.ws_id = '436f3695-87e5-4eec-b829-3ebef1fdcb88' LEFT JOIN tbWebSiteII_TMPItem4Compare i4c On i4c.item_id = ti.item_id and i4c.ws_guid = 'c846360d-2316-498b-9039-36df7585efd8' LEFT JOIN vwItemTaxesOnlyOneIvaTax tit ON tit.item_id=ti.item_id AND tit.comp_id=ti.comp_id LEFT JOIN tbTaxName ttn ON ttn.tax_id=tit.tax_id AND ttn.comp_id=tit.comp_id and ttn.tax_class=1 WHERE ti.item_web = 'true' AND ti.item_id <> '2587' and ti.subcat_id = '3875' AND ti.item_WebSite_leading <> 'true' Tiempo Consumido: 00:00:00.1250010 GBP_LIST: SPOTS1 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT imageName, CASE WHEN URL <> '' THEN URL ELSE '' END [URL], openMode FROM vwWebSiteII_Spots WHERE ws_id = '436f3695-87e5-4eec-b829-3ebef1fdcb88' and Type = 3 ORDER BY [Order] Tiempo Consumido: 00:00:00 |
|
|