Goodr OG Running Sunglasses

Style: OGRS2

Brand: goodr

$25.00

query
RESULTSET
query
  ATTR1 ATTR1_ENTRY_ID FAM HEX NON_INVT ORIGATTR1 QOH SKU_ID SORT_ORDER
1 DOWN_TO_FIESTA 65178 [empty string] [empty string] N DOWN_TO_FIESTA 0 529149 [empty string]
2 PABST_OCLOCK 65179 [empty string] [empty string] N PABST_OCLOCK 9 533010 [empty string]
3 PBR_EYE_CANDY 65180 [empty string] [empty string] N PBR_EYE_CANDY 0 533011 [empty string]
4 PIBBERMOUFLAGE 65181 [empty string] [empty string] N PIBBERMOUFLAGE 20 533012 [empty string]
5 FLAMINGOS_BOOZE 65182 [empty string] [empty string] N FLAMINGOS_BOOZE 11 534032 [empty string]
6 BECKYS_BACHELORETTE 65183 [empty string] [empty string] N BECKYS_BACHELORETTE 0 534033 [empty string]
7 PUMPKIN_SPICE_NIGHT 65184 [empty string] [empty string] N PUMPKIN_SPICE_NIGHT 0 535152 [empty string]
8 CAPED_CRUSADER_SUN 65185 [empty string] [empty string] N CAPED_CRUSADER_SUN 4 535394 [empty string]
9 POW_BAM_THANK_YOU 65186 [empty string] [empty string] N POW_BAM_THANK_YOU 0 535395 [empty string]
10 PHOENIX_BLOODY_MARY 65187 [empty string] [empty string] N PHOENIX_BLOODY_MARY 5 536640 [empty string]
11 PROFESSIONAL_RESPAWN 65188 [empty string] [empty string] N PROFESSIONAL_RESPAWN 0 539774 [empty string]
12 SIDE_SCROLL_EYE_ROLL 65189 [empty string] [empty string] N SIDE_SCROLL_EYE_ROLL 0 539775 [empty string]
13 WE_HAD_LIGHTS_FIRST 65190 [empty string] [empty string] N WE_HAD_LIGHTS_FIRST 0 539776 [empty string]
14 NAKATOMI_TOWER 65191 [empty string] [empty string] N NAKATOMI_TOWER 0 539777 [empty string]
15 UNION_JACK_FLASH 65192 [empty string] [empty string] N UNION_JACK_FLASH 5 540295 [empty string]
16 COLD_ENGLISH_BLOOD 65193 [empty string] [empty string] N COLD_ENGLISH_BLOOD 4 540296 [empty string]
17 TONGUING_YOU_62 65194 [empty string] [empty string] N TONGUING_YOU_62 0 540297 [empty string]
18 WHAT_WOULD_KEITH_DO 65195 [empty string] [empty string] N WHAT_WOULD_KEITH_DO 7 540298 [empty string]
19 INSERT_COIN_CONTINUE 65196 [empty string] [empty string] N INSERT_COIN_CONTINUE 0 540299 [empty string]
20 WAKKA_WAKKA_WAKKA 65197 [empty string] [empty string] N WAKKA_WAKKA_WAKKA 0 542243 [empty string]
21 PABST_ME_A_BEER 65198 [empty string] [empty string] N PABST_ME_A_BEER 0 542806 [empty string]
22 SUNNIES_SPRINKLES 65199 [empty string] [empty string] N SUNNIES_SPRINKLES 0 542807 [empty string]
23 ITS_TUESDAY_SOMEWHER 65200 [empty string] [empty string] N ITS_TUESDAY_SOMEWHER 2 542808 [empty string]
24 PASSION_OF_THE_CRUST 65201 [empty string] [empty string] N PASSION_OF_THE_CRUST 4 542809 [empty string]
25 DARK_KNIGHT_CLUBBIN 65202 [empty string] [empty string] N DARK_KNIGHT_CLUBBIN 9 550453 [empty string]
26 GLAMAZON_GODDESS 65203 [empty string] [empty string] N GLAMAZON_GODDESS 0 550454 [empty string]
27 JOKES_ON_YOU 65204 [empty string] [empty string] N JOKES_ON_YOU 0 550455 [empty string]
28 WELCOME_NEIGHBORHOOD 65205 [empty string] [empty string] N WELCOME_NEIGHBORHOOD 0 550456 [empty string]
29 JUSTICE_AND_GRACE 65206 [empty string] [empty string] N JUSTICE_AND_GRACE 0 550457 [empty string]
30 NEW_DISGUISE_WHO_DIS 65207 [empty string] [empty string] N NEW_DISGUISE_WHO_DIS 0 550458 [empty string]
31 FLAMINGOITE_AURA 65208 [empty string] [empty string] N FLAMINGOITE_AURA 0 554502 [empty string]
32 CITRINE_MIMOSA_DREAM 65209 [empty string] [empty string] N CITRINE_MIMOSA_DREAM -1 554503 [empty string]
33 ZEBRA_JASPER_COACH 65210 [empty string] [empty string] N ZEBRA_JASPER_COACH 0 554504 [empty string]
34 DONT_FLOCK_FLAMINGO 65211 [empty string] [empty string] N DONT_FLOCK_FLAMINGO 14 556115 [empty string]
35 THE_GANGS_ALL_QUEER 65212 [empty string] [empty string] N THE_GANGS_ALL_QUEER 0 556116 [empty string]
36 The Eh Team 65213 [empty string] [empty string] N The Eh Team 3 557386 [empty string]
37 SCREW_METRIC_SYSTEM 65214 [empty string] [empty string] N SCREW_METRIC_SYSTEM 17 557387 [empty string]
38 BAD_AND_BAMBOOZY 65215 [empty string] [empty string] N BAD_AND_BAMBOOZY 4 559850 [empty string]
39 GRPE_APE_MISTAKE 65216 [empty string] [empty string] N GRPE_APE_MISTAKE 0 559851 [empty string]
40 TROPICAL_TUMMY 65217 [empty string] [empty string] N TROPICAL_TUMMY 1 559852 [empty string]
41 SIRENS_BOOTY_CALL 65218 [empty string] [empty string] N SIRENS_BOOTY_CALL 4 559853 [empty string]
42 YOU_HAD_ME_AT_DUNKIN 65219 [empty string] [empty string] N YOU_HAD_ME_AT_DUNKIN 0 560728 [empty string]
43 KING_OF_THE_TROPICS 65220 [empty string] [empty string] N KING_OF_THE_TROPICS 7 563075 [empty string]
44 TOURIST_TRAP_TABLOID 65221 [empty string] [empty string] N TOURIST_TRAP_TABLOID 10 563076 [empty string]
45 ELECTRIC_DINOTOPIA 65222 [empty string] [empty string] N ELECTRIC_DINOTOPIA 3 566302 [empty string]
46 BACK_9_BLACKOUT 65223 [empty string] [empty string] N BACK_9_BLACKOUT 0 566799 [empty string]
CACHED false
EXECUTIONTIME 16
SQL SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh, max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(z.non_invt) as non_invt FROM tb_skus a LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) LEFT JOIN tb_styles z on (z.style_id = a.style_id) WHERE (a.sell_web not in ('N','NO') or (a.sell_web is null)) and a.style_id=? AND e.store_id in(1,2,3) GROUP BY b.attr1 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
SQLPARAMETERS
array
1 38733
Free shipping on all orders $50+