#1 Place for Craft Supplies, Art Supplies, Artist Materials and Kids Crafts

Distress Stickles Glitter Glue

by Ranger


Problem with item sku 31116. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10546 10546&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10546&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 12276
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 38
barcode 789541024958
barcode_type UPC
col1 antique linen
col1_sortorder 149
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 243
color_swatch 160-135-84.jpg
cost 1.06
deal_of_the_week NO
description antique linen, 1/2 oz., bottle
group_id 10546
group_uname ranger-distress-stickles-glitter-glue
id 31116
list_price 2.49
map NO
mfr_num TDS24958
net_weight 0.05
non_member_discount 28
non_member_price 1.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 31116
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.25
ta_dealer_c_price 1.25
ta_price 1.25
text
array
1 31116
2 TDS24958
3 antique linen, 1/2 oz., bottle
timestamp 2015-03-31T17:53:09.366Z
vip_member_price 1.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 12276
CACHED false
EXECUTIONTIME 11
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '16791' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.155.41

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


Problem with item sku 78524. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10546 10546&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10546&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 12276
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 38
barcode 789541026457
barcode_type UPC
col1 antiqued bronze
col1_sortorder 166
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 243
color_swatch 137-99-74.jpg
cost 1.06
deal_of_the_week NO
description antiqued bronze, 1/2 oz., bottle
group_id 10546
group_uname ranger-distress-stickles-glitter-glue
id 78524
list_price 2.49
map NO
mfr_num TDS26457
net_weight 0.05
non_member_discount 28
non_member_price 1.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 78524
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.25
ta_dealer_c_price 1.25
ta_price 1.25
text
array
1 78524
2 TDS26457
3 antiqued bronze, 1/2 oz., bottle
timestamp 2015-03-31T17:54:31.34Z
vip_member_price 1.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 12276
CACHED false
EXECUTIONTIME 11
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '16791' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.155.41

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


Problem with item sku 31117. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10546 10546&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10546&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 12276
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 38
barcode 789541024965
barcode_type UPC
col1 broken china
col1_sortorder 790
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 243
color_swatch 37-102-136.jpg
cost 1.06
deal_of_the_week NO
description broken china, 1/2 oz., bottle
group_id 10546
group_uname ranger-distress-stickles-glitter-glue
id 31117
list_price 2.49
map NO
mfr_num TDS24965
net_weight 0.05
non_member_discount 28
non_member_price 1.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 31117
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.25
ta_dealer_c_price 1.25
ta_price 1.25
text
array
1 31117
2 TDS24965
3 broken china, 1/2 oz., bottle
timestamp 2015-03-31T17:53:09.369Z
vip_member_price 1.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 12276
CACHED false
EXECUTIONTIME 11
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '16791' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.155.41

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


Problem with item sku 78532. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10546 10546&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10546&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 12276
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 38
barcode 789541026358
barcode_type UPC
col1 brushed corduroy
col1_sortorder 830
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 243
color_swatch 114-92-73.jpg
cost 1.06
deal_of_the_week NO
description brushed corduroy, 1/2 oz., bottle
group_id 10546
group_uname ranger-distress-stickles-glitter-glue
id 78532
list_price 2.49
map NO
mfr_num TDS26358
net_weight 0.05
non_member_discount 28
non_member_price 1.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 78532
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.25
ta_dealer_c_price 1.25
ta_price 1.25
text
array
1 78532
2 TDS26358
3 brushed corduroy, 1/2 oz., bottle
timestamp 2015-03-31T17:54:31.351Z
vip_member_price 1.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 12276
CACHED false
EXECUTIONTIME 11
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '16791' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.155.41

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


Problem with item sku 78527. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10546 10546&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10546&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 12276
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 38
barcode 789541026464
barcode_type UPC
col1 brushed pewter
col1_sortorder 833
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 243
color_swatch 123-126-130.jpg
cost 1.06
deal_of_the_week NO
description brushed pewter, 1/2 oz., bottle
group_id 10546
group_uname ranger-distress-stickles-glitter-glue
id 78527
list_price 2.49
map NO
mfr_num TDS26464
net_weight 0.05
non_member_discount 28
non_member_price 1.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 78527
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.25
ta_dealer_c_price 1.25
ta_price 1.25
text
array
1 78527
2 TDS26464
3 brushed pewter, 1/2 oz., bottle
timestamp 2015-03-31T17:54:31.346Z
vip_member_price 1.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 12276
CACHED false
EXECUTIONTIME 11
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '16791' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.155.41

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


Problem with item sku 04496. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10546 10546&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10546&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 12276
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 38
barcode 789541028895
barcode_type UPC
col1 bundled sage
col1_sortorder 848
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 243
color_swatch 197-211-182.jpg
cost 1.06
deal_of_the_week NO
description bundled sage, 1/2 oz., bottle
group_id 10546
group_uname ranger-distress-stickles-glitter-glue
id 04496
list_price 2.49
map NO
mfr_num TDS28895
net_weight 0.05
non_member_discount 28
non_member_price 1.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 04496
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.25
ta_dealer_c_price 1.25
ta_price 1.25
text
array
1 04496
2 TDS28895
3 bundled sage, 1/2 oz., bottle
timestamp 2015-03-31T17:52:23.235Z
vip_member_price 1.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 12276
CACHED false
EXECUTIONTIME 11
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '16791' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.155.41

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


Problem with item sku 78528. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10546 10546&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10546&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 12276
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 38
barcode 789541026563
barcode_type UPC
col1 clear rock candy
col1_sortorder 1331
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 243
color_swatch 217-218-218.jpg
cost 1.06
deal_of_the_week NO
description clear rock candy, 1/2 oz., bottle
group_id 10546
group_uname ranger-distress-stickles-glitter-glue
id 78528
list_price 2.49
map NO
mfr_num TDS26563
net_weight 0.05
non_member_discount 28
non_member_price 1.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 78528
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.25
ta_dealer_c_price 1.25
ta_price 1.25
text
array
1 78528
2 TDS26563
3 clear rock candy, 1/2 oz., bottle
timestamp 2015-03-31T17:54:31.348Z
vip_member_price 1.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 12276
CACHED false
EXECUTIONTIME 11
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '16791' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.155.41

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


Problem with item sku 04498. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10546 10546&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10546&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 12276
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 38
barcode 789541028918
barcode_type UPC
col1 crushed olive
col1_sortorder 1623
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 243
color_swatch 199-194-95.jpg
cost 1.06
deal_of_the_week NO
description crushed olive, 1/2 oz., bottle
group_id 10546
group_uname ranger-distress-stickles-glitter-glue
id 04498
list_price 2.49
map NO
mfr_num TDS28918
net_weight 0.05
non_member_discount 28
non_member_price 1.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 04498
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.25
ta_dealer_c_price 1.25
ta_price 1.25
text
array
1 04498
2 TDS28918
3 crushed olive, 1/2 oz., bottle
timestamp 2015-03-31T17:52:23.24Z
vip_member_price 1.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 12276
CACHED false
EXECUTIONTIME 11
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '16791' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.155.41

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


Problem with item sku 78529. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10546 10546&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10546&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 12276
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 38
barcode 789541026365
barcode_type UPC
col1 dried marigold
col1_sortorder 1943
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 243
color_swatch 188-132-98.jpg
cost 1.06
deal_of_the_week NO
description dried marigold, 1/2 oz., bottle
group_id 10546
group_uname ranger-distress-stickles-glitter-glue
id 78529
list_price 2.49
map NO
mfr_num TDS26365
net_weight 0.05
non_member_discount 28
non_member_price 1.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 78529
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.25
ta_dealer_c_price 1.25
ta_price 1.25
text
array
1 78529
2 TDS26365
3 dried marigold, 1/2 oz., bottle
timestamp 2015-03-31T17:54:31.35Z
vip_member_price 1.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 12276
CACHED false
EXECUTIONTIME 11
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '16791' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.155.41

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


Problem with item sku 04499. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10546 10546&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10546&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 12276
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 38
barcode 789541026372
barcode_type UPC
col1 dusty concord
col1_sortorder 1978
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 243
color_swatch 136-127-160.jpg
cost 1.06
deal_of_the_week NO
description dusty concord, 1/2 oz., bottle
group_id 10546
group_uname ranger-distress-stickles-glitter-glue
id 04499
list_price 2.49
map NO
mfr_num TDS26372
net_weight 0.05
non_member_discount 28
non_member_price 1.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 04499
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.25
ta_dealer_c_price 1.25
ta_price 1.25
text
array
1 04499
2 TDS26372
3 dusty concord, 1/2 oz., bottle
timestamp 2015-03-31T17:52:23.243Z
vip_member_price 1.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 12276
CACHED false
EXECUTIONTIME 11
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '16791' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.155.41

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


Problem with item sku 31118. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10546 10546&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10546&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 12276
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 38
barcode 789541024972
barcode_type UPC
col1 faded jeans
col1_sortorder 2098
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 243
color_swatch 62-82-113.jpg
cost 1.06
deal_of_the_week NO
description faded jeans, 1/2 oz., bottle
group_id 10546
group_uname ranger-distress-stickles-glitter-glue
id 31118
list_price 2.49
map NO
mfr_num TDS24972
net_weight 0.05
non_member_discount 28
non_member_price 1.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 31118
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.25
ta_dealer_c_price 1.25
ta_price 1.25
text
array
1 31118
2 TDS24972
3 faded jeans, 1/2 oz., bottle
timestamp 2015-03-31T17:53:09.372Z
vip_member_price 1.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 12276
CACHED false
EXECUTIONTIME 11
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '16791' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.155.41

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


Problem with item sku 31131. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10546 10546&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10546&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 12276
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 38
barcode 789541024989
barcode_type UPC
col1 fired brick
col1_sortorder 2153
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 243
color_swatch 100-30-43.jpg
cost 1.06
deal_of_the_week NO
description fired brick, 1/2 oz., bottle
group_id 10546
group_uname ranger-distress-stickles-glitter-glue
id 31131
list_price 2.49
map NO
mfr_num TDS24989
net_weight 0.05
non_member_discount 28
non_member_price 1.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 31131
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.25
ta_dealer_c_price 1.25
ta_price 1.25
text
array
1 31131
2 TDS24989
3 fired brick, 1/2 oz., bottle
timestamp 2015-03-31T17:53:09.386Z
vip_member_price 1.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 12276
CACHED false
EXECUTIONTIME 11
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '16791' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.155.41

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


Problem with item sku 31135. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10546 10546&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10546&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 12276
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 38
barcode 789541024996
barcode_type UPC
col1 frayed burlap
col1_sortorder 2273
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 243
color_swatch 113-89-55.jpg
cost 1.06
deal_of_the_week NO
description frayed burlap, 1/2 oz., bottle
group_id 10546
group_uname ranger-distress-stickles-glitter-glue
id 31135
list_price 2.49
map NO
mfr_num TDS24996
net_weight 0.05
non_member_discount 28
non_member_price 1.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 31135
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.25
ta_dealer_c_price 1.25
ta_price 1.25
text
array
1 31135
2 TDS24996
3 frayed burlap, 1/2 oz., bottle
timestamp 2015-03-31T17:53:09.391Z
vip_member_price 1.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 12276
CACHED false
EXECUTIONTIME 11
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '16791' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.155.41

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


Problem with item sku 31137. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10546 10546&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10546&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 12276
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 38
barcode 789541025009
barcode_type UPC
col1 milled lavender
col1_sortorder 3779
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 243
color_swatch 120-107-125.jpg
cost 1.06
deal_of_the_week NO
description milled lavender, 1/2 oz., bottle
group_id 10546
group_uname ranger-distress-stickles-glitter-glue
id 31137
list_price 2.49
map NO
mfr_num TDS25009
net_weight 0.05
non_member_discount 28
non_member_price 1.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 31137
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.25
ta_dealer_c_price 1.25
ta_price 1.25
text
array
1 31137
2 TDS25009
3 milled lavender, 1/2 oz., bottle
timestamp 2015-03-31T17:53:09.395Z
vip_member_price 1.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 12276
CACHED false
EXECUTIONTIME 11
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '16791' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.155.41

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


Problem with item sku 31140. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10546 10546&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10546&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 12276
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 38
barcode 789541025016
barcode_type UPC
col1 peeled paint
col1_sortorder 4522
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 243
color_swatch 80-71-35.jpg
cost 1.06
deal_of_the_week NO
description peeled paint, 1/2 oz., bottle
group_id 10546
group_uname ranger-distress-stickles-glitter-glue
id 31140
list_price 2.49
map NO
mfr_num TDS25016
net_weight 0.05
non_member_discount 28
non_member_price 1.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 31140
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.25
ta_dealer_c_price 1.25
ta_price 1.25
text
array
1 31140
2 TDS25016
3 peeled paint, 1/2 oz., bottle
timestamp 2015-03-31T17:53:09.404Z
vip_member_price 1.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 12276
CACHED false
EXECUTIONTIME 11
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '16791' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.155.41

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


Problem with item sku 31141. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10546 10546&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10546&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 12276
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 38
barcode 789541025023
barcode_type UPC
col1 scattered straw
col1_sortorder 5398
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 243
color_swatch 201-158-72.jpg
cost 1.06
deal_of_the_week NO
description scattered straw, 1/2 oz., bottle
group_id 10546
group_uname ranger-distress-stickles-glitter-glue
id 31141
list_price 2.49
map NO
mfr_num TDS25023
net_weight 0.05
non_member_discount 28
non_member_price 1.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 31141
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.25
ta_dealer_c_price 1.25
ta_price 1.25
text
array
1 31141
2 TDS25023
3 scattered straw, 1/2 oz., bottle
timestamp 2015-03-31T17:53:09.406Z
vip_member_price 1.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 12276
CACHED false
EXECUTIONTIME 11
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '16791' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.155.41

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


Problem with item sku 31143. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10546 10546&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10546&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 12276
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 38
barcode 789541025030
barcode_type UPC
col1 spiced marmalade
col1_sortorder 5752
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 243
color_swatch 189-91-47.jpg
cost 1.06
deal_of_the_week NO
description spiced marmalade, 1/2 oz., bottle
group_id 10546
group_uname ranger-distress-stickles-glitter-glue
id 31143
list_price 2.49
map NO
mfr_num TDS25030
net_weight 0.05
non_member_discount 28
non_member_price 1.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 31143
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.25
ta_dealer_c_price 1.25
ta_price 1.25
text
array
1 31143
2 TDS25030
3 spiced marmalade, 1/2 oz., bottle
timestamp 2015-03-31T17:53:09.412Z
vip_member_price 1.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 12276
CACHED false
EXECUTIONTIME 11
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '16791' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.155.41

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


Problem with item sku 31149. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10546 10546&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10546&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 12276
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 38
barcode 789541025047
barcode_type UPC
col1 vintage photo
col1_sortorder 6404
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 243
color_swatch 107-63-50.jpg
cost 1.06
deal_of_the_week NO
description vintage photo, 1/2 oz., bottle
group_id 10546
group_uname ranger-distress-stickles-glitter-glue
id 31149
list_price 2.49
map NO
mfr_num TDS25047
net_weight 0.05
non_member_discount 28
non_member_price 1.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 31149
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.25
ta_dealer_c_price 1.25
ta_price 1.25
text
array
1 31149
2 TDS25047
3 vintage photo, 1/2 oz., bottle
timestamp 2015-03-31T17:53:09.417Z
vip_member_price 1.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 12276
CACHED false
EXECUTIONTIME 11
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '16791' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.155.41

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


Problem with item sku 31152. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10546 10546&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10546&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 12276
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 38
barcode 789541025054
barcode_type UPC
col1 walnut stain
col1_sortorder 6459
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 243
color_swatch 91-73-69.jpg
cost 1.06
deal_of_the_week NO
description walnut stain, 1/2 oz., bottle
group_id 10546
group_uname ranger-distress-stickles-glitter-glue
id 31152
list_price 2.49
map NO
mfr_num TDS25054
net_weight 0.05
non_member_discount 28
non_member_price 1.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 31152
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.25
ta_dealer_c_price 1.25
ta_price 1.25
text
array
1 31152
2 TDS25054
3 walnut stain, 1/2 oz., bottle
timestamp 2015-03-31T17:53:09.421Z
vip_member_price 1.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 12276
CACHED false
EXECUTIONTIME 11
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '16791' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.155.41

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


Problem with item sku 31158. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a10546 10546&wt=json&indent=on&fl=*&rows=1000&fq=group_id:10546&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 12276
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 38
barcode 789541025061
barcode_type UPC
col1 worn lipstick
col1_sortorder 6678
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 243
color_swatch 214-105-112.jpg
cost 1.06
deal_of_the_week NO
description worn lipstick, 1/2 oz., bottle
group_id 10546
group_uname ranger-distress-stickles-glitter-glue
id 31158
list_price 2.49
map NO
mfr_num TDS25061
net_weight 0.05
non_member_discount 28
non_member_price 1.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 31158
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.25
ta_dealer_c_price 1.25
ta_price 1.25
text
array
1 31158
2 TDS25061
3 worn lipstick, 1/2 oz., bottle
timestamp 2015-03-31T17:53:09.43Z
vip_member_price 1.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 12276
CACHED false
EXECUTIONTIME 11
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '16791' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.204.155.41

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 14:02:29'}
sessionid e03014fb549f7b07c33a4a2c6536127d274c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~ranger~&gr=ranger-distress-stickles-glitter-glue.html
urltoken CFID=30541109&CFTOKEN=42454992&jsessionid=e03014fb549f7b07c33a4a2c6536127d274c
validationerror [empty string]


Let your art "sparkle" with acid free, non-settling Stickles glitter glue! Easily write, dot, dash, draw and embellish on paper and rubber stamping projects, candles, memory album covers and more!

The Designer Series brings together two popular Ranger signature artists with glitter glue: Tim Holtz Distress Stickles and Suze Weinberg Glitz Stickles.



Share on Facebook Twitter Pinterest

Ask a question about Distress Stickles Glitter Glue Ask a question about this product

Distress Stickles Glitter Glue

by Ranger









  Item# Swatch Image color
Ascending
size unit Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
31116
Distress Stickles Glitter Glue antique linen 1/2 oz. bottle
Zoom Image
antique linen 1/2 oz. bottle TDS24958 $2.49 $1.79 28% Off $1.54 38% Off Email When In Stock
Add to Favorites
78524
Distress Stickles Glitter Glue antiqued bronze 1/2 oz. bottle
Zoom Image
antiqued bronze 1/2 oz. bottle TDS26457 $2.49 $1.79 28% Off $1.54 38% Off Email When In Stock
Add to Favorites
31117
Distress Stickles Glitter Glue broken china 1/2 oz. bottle
Zoom Image
broken china 1/2 oz. bottle TDS24965 $2.49 $1.79 28% Off $1.54 38% Off Email When In Stock
Add to Favorites
78532
Distress Stickles Glitter Glue brushed corduroy 1/2 oz. bottle
Zoom Image
brushed corduroy 1/2 oz. bottle TDS26358 $2.49 $1.79 28% Off $1.54 38% Off Email When In Stock
Add to Favorites
78527
Distress Stickles Glitter Glue brushed pewter 1/2 oz. bottle
Zoom Image
brushed pewter 1/2 oz. bottle TDS26464 $2.49 $1.79 28% Off $1.54 38% Off Email When In Stock
Add to Favorites
04496
Distress Stickles Glitter Glue bundled sage 1/2 oz. bottle
Zoom Image
bundled sage 1/2 oz. bottle TDS28895 $2.49 $1.79 28% Off $1.54 38% Off Email When In Stock
Add to Favorites
78528
Distress Stickles Glitter Glue clear rock candy 1/2 oz. bottle
Zoom Image
clear rock candy 1/2 oz. bottle TDS26563 $2.49 $1.79 28% Off $1.54 38% Off Email When In Stock
Add to Favorites
04498
Distress Stickles Glitter Glue crushed olive 1/2 oz. bottle
Zoom Image
crushed olive 1/2 oz. bottle TDS28918 $2.49 $1.79 28% Off $1.54 38% Off Email When In Stock
Add to Favorites
78529
Distress Stickles Glitter Glue dried marigold 1/2 oz. bottle
Zoom Image
dried marigold 1/2 oz. bottle TDS26365 $2.49 $1.79 28% Off $1.54 38% Off Email When In Stock
Add to Favorites
04499
Distress Stickles Glitter Glue dusty concord 1/2 oz. bottle
Zoom Image
dusty concord 1/2 oz. bottle TDS26372 $2.49 $1.79 28% Off $1.54 38% Off Email When In Stock
Add to Favorites
31118
Distress Stickles Glitter Glue faded jeans 1/2 oz. bottle
Zoom Image
faded jeans 1/2 oz. bottle TDS24972 $2.49 $1.79 28% Off $1.54 38% Off Email When In Stock
Add to Favorites
31131
Distress Stickles Glitter Glue fired brick 1/2 oz. bottle
Zoom Image
fired brick 1/2 oz. bottle TDS24989 $2.49 $1.79 28% Off $1.54 38% Off Email When In Stock
Add to Favorites
31135
Distress Stickles Glitter Glue frayed burlap 1/2 oz. bottle
Zoom Image
frayed burlap 1/2 oz. bottle TDS24996 $2.49 $1.79 28% Off $1.54 38% Off Email When In Stock
Add to Favorites
31137
Distress Stickles Glitter Glue milled lavender 1/2 oz. bottle
Zoom Image
milled lavender 1/2 oz. bottle TDS25009 $2.49 $1.79 28% Off $1.54 38% Off Email When In Stock
Add to Favorites
31140
Distress Stickles Glitter Glue peeled paint 1/2 oz. bottle
Zoom Image
peeled paint 1/2 oz. bottle TDS25016 $2.49 $1.79 28% Off $1.54 38% Off Email When In Stock
Add to Favorites
31141
Distress Stickles Glitter Glue scattered straw 1/2 oz. bottle
Zoom Image
scattered straw 1/2 oz. bottle TDS25023 $2.49 $1.79 28% Off $1.54 38% Off Email When In Stock
Add to Favorites
31143
Distress Stickles Glitter Glue spiced marmalade 1/2 oz. bottle
Zoom Image
spiced marmalade 1/2 oz. bottle TDS25030 $2.49 $1.79 28% Off $1.54 38% Off Email When In Stock
Add to Favorites
31149
Distress Stickles Glitter Glue vintage photo 1/2 oz. bottle
Zoom Image
vintage photo 1/2 oz. bottle TDS25047 $2.49 $1.79 28% Off $1.54 38% Off Email When In Stock
Add to Favorites
31152
Distress Stickles Glitter Glue walnut stain 1/2 oz. bottle
Zoom Image
walnut stain 1/2 oz. bottle TDS25054 $2.49 $1.79 28% Off $1.54 38% Off Email When In Stock
Add to Favorites
31158
Distress Stickles Glitter Glue worn lipstick 1/2 oz. bottle
Zoom Image
worn lipstick 1/2 oz. bottle TDS25061 $2.49 $1.79 28% Off $1.54 38% Off Email When In Stock

Use color swatches as a general guide. Actual colors may vary.

Click the to add item to your Favorites.



Please wait...
You May Also Like...

Clic Eraser

by Pentel

Professional look and performance

From $1.24

From $3.49

Tim Holtz Distress Ink

by Ranger

Perfect for giving an aged look to books, cards, and paper

From $2.70

How to get VIP Club Prices
Anyone can be a VIP Member with:
  • Additional savings on all products
  • Express order handling
  • Exclusive promotions
  • Priority customer service
Only $25/year

Learn More »

Ask a Question About Distress Stickles Glitter Glue

Your email will not be shared. We will only use your email address to respond to your question. When asking your question, please be as descriptive as possible, it will allow us to give you the most accurate answer possible.

Write a Product Review for Distress Stickles Glitter Glue

Add Your Review

Tell us what you think. We appreciate you taking the time to share your opinion with other artists and crafters. Please keep your review detailed and specific.

Product reviews are intended to be a resource for artists interested in product quality and use. MisterArt.com reserves the right not to post any product review or to remove any published product review at any time without notice. Published reviews must conform to MisterArt.com guidelines. Your review may be posted on this page within five to ten business days.

Tips on Writing Reviews
Rating Scale
  • (5-Star) Excellent
  • (4-Star) Good
  • (3-Star) Average
  • (2-Star) Fair
  • (1-Star) Poor
Do:
  • Give your perspective on how you used the product and why you liked or disliked it.
  • Keep your reviews short enough to hold the audience's attention.
  • Be honest and mindful of others when providing editorial commentary.
Don't:
  • Include phone numbers, addresses, URLs, or HTML tags.
  • Write profanity, obscenities, vulgarities, or spiteful comments.
  • Make defamatory comments.
Please wait...
Please wait...