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 73658 [empty string] [empty string] N JET_BLACK 1 585816 [empty string]
2 CRYSTAL_CLEAR 73659 [empty string] [empty string] N CRYSTAL_CLEAR 2 585817 [empty string]
3 ROSE_WATER_PINK 73660 [empty string] [empty string] N ROSE_WATER_PINK 0 585818 [empty string]
4 WASHED_DENIM 73661 [empty string] [empty string] N WASHED_DENIM 0 585819 [empty string]
5 COCONUT_WHITE 73662 [empty string] [empty string] N COCONUT_WHITE 2 585820 [empty string]
6 TORTOISE 73663 [empty string] [empty string] N TORTOISE 1 585821 [empty string]
7 SNOW_LEOPARD 73664 [empty string] [empty string] N SNOW_LEOPARD 0 585822 [empty string]
8 LEOPARD 73665 [empty string] [empty string] N LEOPARD 0 585823 [empty string]
9 FOR_LOVE_OF_NUDES 73666 [empty string] [empty string] N FOR_LOVE_OF_NUDES 0 585824 [empty string]
10 PSYCHEDELIC 73667 [empty string] [empty string] N PSYCHEDELIC 0 585825 [empty string]
11 EAT_GLITTER_FOR_B 73668 [empty string] [empty string] N EAT_GLITTER_FOR_B 3 585826 [empty string]
12 ELECTRIC_SILVER 73669 [empty string] [empty string] N ELECTRIC_SILVER 2 585827 [empty string]
13 SUNSET_GOLD 73670 [empty string] [empty string] N SUNSET_GOLD 1 585828 [empty string]
14 MILLENNIAL_PINK 73671 [empty string] [empty string] N MILLENNIAL_PINK 0 585829 [empty string]
15 PEPPERMINT 73672 [empty string] [empty string] N PEPPERMINT 0 585830 [empty string]
16 PARTY_PEOPLE 73673 [empty string] [empty string] N PARTY_PEOPLE 1 585831 [empty string]
17 SPRING_SWIRL 73674 [empty string] [empty string] N SPRING_SWIRL 2 585832 [empty string]
18 BLUE_TIFUL 73675 [empty string] [empty string] N BLUE_TIFUL 0 585833 [empty string]
19 OOPSY_DAISY 73676 [empty string] [empty string] N OOPSY_DAISY 0 585834 [empty string]
20 SHERBERT 73677 [empty string] [empty string] N SHERBERT 0 585835 [empty string]
21 NANTUCKET_NAVY 73678 [empty string] [empty string] N NANTUCKET_NAVY 1 585836 [empty string]
22 SCARLET_RED 73679 [empty string] [empty string] N SCARLET_RED 2 585837 [empty string]
23 GIRAFFE 73680 [empty string] [empty string] N GIRAFFE 1 589500 [empty string]
24 COUNTING_KARATS 73681 [empty string] [empty string] N COUNTING_KARATS 1 589501 [empty string]
25 TALK_TO_THE_SAND 73682 [empty string] [empty string] N TALK_TO_THE_SAND 0 589502 [empty string]
26 BLOOMING_MEADOW 73683 [empty string] [empty string] N BLOOMING_MEADOW 1 589503 [empty string]
27 COTTAGE_MIST 73684 [empty string] [empty string] N COTTAGE_MIST 1 589504 [empty string]
28 ZEBRA 73685 [empty string] [empty string] N ZEBRA 1 589505 [empty string]
29 GONE_WILD 73686 [empty string] [empty string] N GONE_WILD 1 590870 [empty string]
30 GROOVY_BABY 73687 [empty string] [empty string] N GROOVY_BABY 0 590871 [empty string]
31 HOLLA_GRAPHIC 73688 [empty string] [empty string] N HOLLA_GRAPHIC 1 590872 [empty string]
32 MAUI 73689 [empty string] [empty string] N MAUI 1 590873 [empty string]
33 BERMUDA 73690 [empty string] [empty string] N BERMUDA 1 590874 [empty string]
34 COZUMEL 73691 [empty string] [empty string] N COZUMEL 2 590875 [empty string]
35 GOOD_AS_GOLD 73692 [empty string] [empty string] N GOOD_AS_GOLD 0 590881 [empty string]
36 BLUE_ORCHID 73693 [empty string] [empty string] N BLUE_ORCHID 0 593948 [empty string]
37 PINK_MAGNOLIA 73694 [empty string] [empty string] N PINK_MAGNOLIA 1 593949 [empty string]
38 VIOLET 73695 [empty string] [empty string] N VIOLET 2 593950 [empty string]
39 SAGE 73696 [empty string] [empty string] N SAGE 1 593951 [empty string]
40 UNDERCOVER 73697 [empty string] [empty string] N UNDERCOVER 2 593952 [empty string]
41 LIMELIGHT 73698 [empty string] [empty string] N LIMELIGHT 1 593953 [empty string]
42 ATOMIC 73699 [empty string] [empty string] N ATOMIC 2 593954 [empty string]
43 FLASH_BULB 73700 [empty string] [empty string] N FLASH_BULB 1 593955 [empty string]
44 PINK_PALMS 73701 [empty string] [empty string] N PINK_PALMS 1 594931 [empty string]
45 GOOD_VIBRATIONS 73702 [empty string] [empty string] N GOOD_VIBRATIONS 1 594932 [empty string]
46 ENJOY_COCA_COLA 73703 [empty string] [empty string] N ENJOY_COCA_COLA 0 594933 [empty string]
47 ICE_COLD_SUNSHINE 73704 [empty string] [empty string] N ICE_COLD_SUNSHINE 2 594934 [empty string]
48 HAVE_A_COKE 73705 [empty string] [empty string] N HAVE_A_COKE 2 594935 [empty string]
49 US_OF_YAY 73706 [empty string] [empty string] N US_OF_YAY 6 597236 [empty string]
50 FIRECRACKER 73707 [empty string] [empty string] N FIRECRACKER 6 597237 [empty string]
51 GYPSY_ROSE 73708 [empty string] [empty string] N GYPSY_ROSE 0 597238 [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 42840
Free shipping on all orders $50+