Teleties (Large)

Style: TT-L

Brand: teleties

$9.99

query
RESULTSET
query
  ATTR1 ATTR1_ENTRY_ID FAM HEX NON_INVT ORIGATTR1 QOH SKU_ID SORT_ORDER
1 JET_BLACK 78257 [empty string] [empty string] N JET_BLACK 1 585816 [empty string]
2 CRYSTAL_CLEAR 78258 [empty string] [empty string] N CRYSTAL_CLEAR 1 585817 [empty string]
3 ROSE_WATER_PINK 78259 [empty string] [empty string] N ROSE_WATER_PINK 0 585818 [empty string]
4 WASHED_DENIM 78260 [empty string] [empty string] N WASHED_DENIM 3 585819 [empty string]
5 COCONUT_WHITE 78261 [empty string] [empty string] N COCONUT_WHITE 1 585820 [empty string]
6 TORTOISE 78262 [empty string] [empty string] N TORTOISE 1 585821 [empty string]
7 SNOW_LEOPARD 78263 [empty string] [empty string] N SNOW_LEOPARD 0 585822 [empty string]
8 LEOPARD 78264 [empty string] [empty string] N LEOPARD 2 585823 [empty string]
9 FOR_LOVE_OF_NUDES 78265 [empty string] [empty string] N FOR_LOVE_OF_NUDES 2 585824 [empty string]
10 PSYCHEDELIC 78266 [empty string] [empty string] N PSYCHEDELIC 0 585825 [empty string]
11 EAT_GLITTER_FOR_B 78267 [empty string] [empty string] N EAT_GLITTER_FOR_B 3 585826 [empty string]
12 ELECTRIC_SILVER 78268 [empty string] [empty string] N ELECTRIC_SILVER 0 585827 [empty string]
13 SUNSET_GOLD 78269 [empty string] [empty string] N SUNSET_GOLD 2 585828 [empty string]
14 MILLENNIAL_PINK 78270 [empty string] [empty string] N MILLENNIAL_PINK 2 585829 [empty string]
15 PEPPERMINT 78271 [empty string] [empty string] N PEPPERMINT 1 585830 [empty string]
16 PARTY_PEOPLE 78272 [empty string] [empty string] N PARTY_PEOPLE 0 585831 [empty string]
17 SPRING_SWIRL 78273 [empty string] [empty string] N SPRING_SWIRL 0 585832 [empty string]
18 BLUE_TIFUL 78274 [empty string] [empty string] N BLUE_TIFUL 0 585833 [empty string]
19 OOPSY_DAISY 78275 [empty string] [empty string] N OOPSY_DAISY 0 585834 [empty string]
20 SHERBERT 78276 [empty string] [empty string] N SHERBERT 0 585835 [empty string]
21 NANTUCKET_NAVY 78277 [empty string] [empty string] N NANTUCKET_NAVY 1 585836 [empty string]
22 SCARLET_RED 78278 [empty string] [empty string] N SCARLET_RED 0 585837 [empty string]
23 GIRAFFE 78279 [empty string] [empty string] N GIRAFFE 2 589500 [empty string]
24 COUNTING_KARATS 78280 [empty string] [empty string] N COUNTING_KARATS 1 589501 [empty string]
25 TALK_TO_THE_SAND 78281 [empty string] [empty string] N TALK_TO_THE_SAND 1 589502 [empty string]
26 BLOOMING_MEADOW 78282 [empty string] [empty string] N BLOOMING_MEADOW 1 589503 [empty string]
27 COTTAGE_MIST 78283 [empty string] [empty string] N COTTAGE_MIST 1 589504 [empty string]
28 ZEBRA 78284 [empty string] [empty string] N ZEBRA 3 589505 [empty string]
29 GONE_WILD 78285 [empty string] [empty string] N GONE_WILD 3 590870 [empty string]
30 GROOVY_BABY 78286 [empty string] [empty string] N GROOVY_BABY 1 590871 [empty string]
31 HOLLA_GRAPHIC 78287 [empty string] [empty string] N HOLLA_GRAPHIC 6 590872 [empty string]
32 MAUI 78288 [empty string] [empty string] N MAUI 0 590873 [empty string]
33 BERMUDA 78289 [empty string] [empty string] N BERMUDA 0 590874 [empty string]
34 COZUMEL 78290 [empty string] [empty string] N COZUMEL 2 590875 [empty string]
35 GOOD_AS_GOLD 78291 [empty string] [empty string] N GOOD_AS_GOLD 6 590881 [empty string]
36 BLUE_ORCHID 78292 [empty string] [empty string] N BLUE_ORCHID 0 593948 [empty string]
37 PINK_MAGNOLIA 78293 [empty string] [empty string] N PINK_MAGNOLIA 0 593949 [empty string]
38 VIOLET 78294 [empty string] [empty string] N VIOLET 0 593950 [empty string]
39 SAGE 78295 [empty string] [empty string] N SAGE 0 593951 [empty string]
40 UNDERCOVER 78296 [empty string] [empty string] N UNDERCOVER 2 593952 [empty string]
41 LIMELIGHT 78297 [empty string] [empty string] N LIMELIGHT 3 593953 [empty string]
42 ATOMIC 78298 [empty string] [empty string] N ATOMIC 5 593954 [empty string]
43 FLASH_BULB 78299 [empty string] [empty string] N FLASH_BULB 0 593955 [empty string]
44 PINK_PALMS 78300 [empty string] [empty string] N PINK_PALMS 0 594931 [empty string]
45 GOOD_VIBRATIONS 78301 [empty string] [empty string] N GOOD_VIBRATIONS 1 594932 [empty string]
46 ENJOY_COCA_COLA 78302 [empty string] [empty string] N ENJOY_COCA_COLA 0 594933 [empty string]
47 ICE_COLD_SUNSHINE 78303 [empty string] [empty string] N ICE_COLD_SUNSHINE 0 594934 [empty string]
48 HAVE_A_COKE 78304 [empty string] [empty string] N HAVE_A_COKE 0 594935 [empty string]
49 US_OF_YAY 78305 [empty string] [empty string] N US_OF_YAY 1 597236 [empty string]
50 FIRECRACKER 78306 [empty string] [empty string] N FIRECRACKER 6 597237 [empty string]
51 GYPSY_ROSE 78307 [empty string] [empty string] N GYPSY_ROSE 0 597238 [empty string]
52 PRIDE 78308 [empty string] [empty string] N PRIDE 0 599841 [empty string]
53 VERY_PERRI 78309 [empty string] [empty string] N VERY_PERRI 1 599842 [empty string]
54 LUAU 78310 [empty string] [empty string] N LUAU 5 599843 [empty string]
55 PALM_BREEZE 78311 [empty string] [empty string] N PALM_BREEZE 1 599844 [empty string]
56 PINA_COLADA 78312 [empty string] [empty string] N PINA_COLADA 1 599845 [empty string]
57 PINK_THISTLE 78313 [empty string] [empty string] N PINK_THISTLE 4 604363 [empty string]
58 TERRACOTTA 78314 [empty string] [empty string] N TERRACOTTA 6 604364 [empty string]
59 MAPLE_LEAF 78315 [empty string] [empty string] N MAPLE_LEAF 4 604365 [empty string]
60 EUCALYPTUS 78316 [empty string] [empty string] N EUCALYPTUS 6 604366 [empty string]
61 ULTRAVIOLET 78317 [empty string] [empty string] N ULTRAVIOLET 5 605533 [empty string]
62 WICKED 78318 [empty string] [empty string] N WICKED 5 609911 [empty string]
63 BOO_TO_YOU 78319 [empty string] [empty string] N BOO_TO_YOU 6 609912 [empty string]
CACHED false
EXECUTIONTIME 0
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 42840
Free shipping on all orders $50+