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

Stickles Glitter Glue

by Ranger


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541015123
barcode_type UPC
col1 black diamond
col1_sortorder 428
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 0-0-0.jpg
cost 0.94
deal_of_the_week NO
description black diamond, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 23114
list_price 2.2
map NO
mfr_num SGG15123
net_weight 0.04
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 23114
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 23114
2 SGG15123
3 black diamond, 0.5 oz., bottle
timestamp 2015-03-27T14:46:44.158Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541038436
barcode_type UPC
col1 champagne
col1_sortorder 1175
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 155-142-94.jpg
cost 0.94
deal_of_the_week NO
description champagne, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 04490
list_price 2.2
map NO
mfr_num SGG38436
net_weight 0.05
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 04490
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 04490
2 SGG38436
3 champagne, 0.5 oz., bottle
timestamp 2015-03-27T14:46:12.653Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541001898
barcode_type UPC
col1 Christmas red
col1_sortorder 1235
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 195-47-47.jpg
cost 0.94
deal_of_the_week NO
description Christmas red, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 47576
list_price 2.2
map NO
mfr_num SGG01898
net_weight 0.04
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 47576
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 47576
2 SGG01898
3 Christmas red, 0.5 oz., bottle
timestamp 2015-03-27T14:47:21.774Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541023937
barcode_type UPC
col1 cinnamon
col1_sortorder 1287
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 119-48-0.jpg
cost 0.94
deal_of_the_week NO
description cinnamon, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 45241
list_price 2.2
map NO
mfr_num SGG23937
net_weight 0.05
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 45241
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 45241
2 SGG23937
3 cinnamon, 0.5 oz., bottle
timestamp 2015-03-27T14:47:18.244Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541001775
barcode_type UPC
col1 copper
col1_sortorder 1527
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 210-128-0.jpg
cost 0.94
deal_of_the_week NO
description copper, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 84253
list_price 2.2
map NO
mfr_num SGG01775
net_weight 0.04
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 84253
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 84253
2 SGG01775
3 copper, 0.5 oz., bottle
timestamp 2015-03-27T14:48:14.53Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541038443
barcode_type UPC
col1 cranberry
col1_sortorder 1587
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 125-39-63.jpg
cost 0.94
deal_of_the_week NO
description cranberry, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 04489
list_price 2.2
map NO
mfr_num SGG38443
net_weight 0.05
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 04489
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 04489
2 SGG38443
3 cranberry, 0.5 oz., bottle
timestamp 2015-03-27T14:46:12.65Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541001782
barcode_type UPC
col1 crystal
col1_sortorder 1624
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 255-252-213.jpg
cost 0.94
deal_of_the_week NO
description crystal, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 40692
list_price 2.2
map NO
mfr_num SGG01782
net_weight 0.04
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 40692
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 40692
2 SGG01782
3 crystal, 0.5 oz., bottle
timestamp 2015-03-27T14:47:12.933Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541017028
barcode_type UPC
col1 diamond
col1_sortorder 1891
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 255-232-213.jpg
cost 0.94
deal_of_the_week NO
description diamond, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 27484
list_price 2.2
map NO
mfr_num SGG17028
net_weight 0.04
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 27484
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 27484
2 SGG17028
3 diamond, 0.5 oz., bottle
timestamp 2015-03-27T14:46:50.695Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541020585
barcode_type UPC
col1 eucalyptus
col1_sortorder 2072
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 213-255-226.jpg
cost 0.94
deal_of_the_week NO
description eucalyptus, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 24580
list_price 2.2
map NO
mfr_num SGG20585
net_weight 0.04
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 24580
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 24580
2 SGG20585
3 eucalyptus, 0.5 oz., bottle
timestamp 2015-03-27T14:46:45.9Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541029540
barcode_type UPC
col1 firefly
col1_sortorder 2151
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 77-164-77.jpg
cost 0.94
deal_of_the_week NO
description firefly, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 69370
list_price 2.2
map NO
mfr_num SGG29540
net_weight 0.05
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 69370
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 69370
2 SGG29540
3 firefly, 0.5 oz., bottle
timestamp 2015-03-27T14:47:54.187Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541020592
barcode_type UPC
col1 frost lace
col1_sortorder 2341
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 240-240-240.jpg
cost 0.94
deal_of_the_week NO
description frost lace, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 39387
list_price 2.2
map NO
mfr_num SGG20592
net_weight 0.04
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 39387
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 39387
2 SGG20592
3 frost lace, 0.5 oz., bottle
timestamp 2015-03-27T14:47:11.671Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541029533
barcode_type UPC
col1 glam pink
col1_sortorder 2421
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 255-77-255.jpg
cost 0.94
deal_of_the_week NO
description glam pink, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 69373
list_price 2.2
map NO
mfr_num SGG29533
net_weight 0.05
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 69373
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 69373
2 SGG29533
3 glam pink, 0.5 oz., bottle
timestamp 2015-03-27T14:47:54.192Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541001799
barcode_type UPC
col1 gold
col1_sortorder 2486
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 210-184-0.jpg
cost 0.94
deal_of_the_week NO
description gold, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 17472
list_price 2.2
map NO
mfr_num SGG01799
net_weight 0.04
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 17472
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 17472
2 SGG01799
3 gold, 0.5 oz., bottle
timestamp 2015-03-27T14:46:37.324Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541001904
barcode_type UPC
col1 golden rod
col1_sortorder 2553
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 240-209-92.jpg
cost 0.94
deal_of_the_week NO
description golden rod, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 75592
list_price 2.2
map NO
mfr_num SGG01904
net_weight 0.04
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 75592
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 75592
2 SGG01904
3 golden rod, 0.5 oz., bottle
timestamp 2015-03-27T14:48:05.61Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541039747
barcode_type UPC
col1 grape crush
col1_sortorder 2572
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
cost 0.94
deal_of_the_week NO
description grape crush, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 06367
list_price 2.2
map NO
mfr_num SGG39747
net_weight 0.05
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 06367
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 06367
2 SGG39747
3 grape crush, 0.5 oz., bottle
timestamp 2015-03-27T14:46:16.72Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541001805
barcode_type UPC
col1 green
col1_sortorder 2621
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 47-149-79.jpg
cost 0.94
deal_of_the_week NO
description green, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 61448
list_price 2.2
map NO
mfr_num SGG01805
net_weight 0.04
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 61448
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 61448
2 SGG01805
3 green, 0.5 oz., bottle
timestamp 2015-03-27T14:47:40.828Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541001812
barcode_type UPC
col1 holly
col1_sortorder 2818
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 0-119-77.jpg
cost 0.94
deal_of_the_week NO
description holly, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 14326
list_price 2.2
map NO
mfr_num SGG01812
net_weight 0.04
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 14326
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 14326
2 SGG01812
3 holly, 0.5 oz., bottle
timestamp 2015-03-27T14:46:30.416Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541038450
barcode_type UPC
col1 ice blue
col1_sortorder 2889
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 84-143-163.jpg
cost 0.94
deal_of_the_week NO
description ice blue, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 04491
list_price 2.2
map NO
mfr_num SGG38450
net_weight 0.05
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 04491
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 04491
2 SGG38450
3 ice blue, 0.5 oz., bottle
timestamp 2015-03-27T14:46:12.656Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541029557
barcode_type UPC
col1 lagoon
col1_sortorder 3223
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 92-166-195.jpg
cost 0.94
deal_of_the_week NO
description lagoon, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 69375
list_price 2.2
map NO
mfr_num SGG29557
net_weight 0.05
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 69375
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 69375
2 SGG29557
3 lagoon, 0.5 oz., bottle
timestamp 2015-03-27T14:47:54.194Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541001843
barcode_type UPC
col1 lavender
col1_sortorder 3248
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 177-138-240.jpg
cost 0.94
deal_of_the_week NO
description lavender, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 56440
list_price 2.2
map NO
mfr_num SGG01843
net_weight 0.04
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 56440
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 56440
2 SGG01843
3 lavender, 0.5 oz., bottle
timestamp 2015-03-27T14:47:31.641Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541001829
barcode_type UPC
col1 lime green
col1_sortorder 3464
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 177-210-77.jpg
cost 0.94
deal_of_the_week NO
description lime green, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 32475
list_price 2.2
map NO
mfr_num SGG01829
net_weight 0.04
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 32475
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 32475
2 SGG01829
3 lime green, 0.5 oz., bottle
timestamp 2015-03-27T14:46:58.451Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541001850
barcode_type UPC
col1 magenta
col1_sortorder 3529
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 164-77-152.jpg
cost 0.94
deal_of_the_week NO
description magenta, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 14773
list_price 2.2
map NO
mfr_num SGG01850
net_weight 0.04
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 14773
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 14773
2 SGG01850
3 magenta, 0.5 oz., bottle
timestamp 2015-03-27T14:46:31.851Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541038467
barcode_type UPC
col1 mercury glass
col1_sortorder 3678
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 140-134-117.jpg
cost 0.94
deal_of_the_week NO
description mercury glass, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 04492
list_price 2.2
map NO
mfr_num SGG38467
net_weight 0.05
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 04492
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 04492
2 SGG38467
3 mercury glass, 0.5 oz., bottle
timestamp 2015-03-27T14:46:12.661Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541029571
barcode_type UPC
col1 mystic green
col1_sortorder 3887
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 0-119-106.jpg
cost 0.94
deal_of_the_week NO
description mystic green, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 69377
list_price 2.2
map NO
mfr_num SGG29571
net_weight 0.05
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 69377
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 69377
2 SGG29571
3 mystic green, 0.5 oz., bottle
timestamp 2015-03-27T14:47:54.198Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541039754
barcode_type UPC
col1 neon flamingo
col1_sortorder 3976
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
cost 0.94
deal_of_the_week NO
description neon flamingo, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 06368
list_price 2.2
map NO
mfr_num SGG39754
net_weight 0.05
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 06368
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 06368
2 SGG39754
3 neon flamingo, 0.5 oz., bottle
timestamp 2015-03-27T14:46:16.722Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541015130
barcode_type UPC
col1 orange peel
col1_sortorder 4238
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 240-132-47.jpg
cost 0.94
deal_of_the_week NO
description orange peel, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 26446
list_price 2.2
map NO
mfr_num SGG15130
net_weight 0.04
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 26446
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 26446
2 SGG15130
3 orange peel, 0.5 oz., bottle
timestamp 2015-03-27T14:46:49.144Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541029588
barcode_type UPC
col1 paprika
col1_sortorder 4374
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 210-110-0.jpg
cost 0.94
deal_of_the_week NO
description paprika, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 69378
list_price 2.2
map NO
mfr_num SGG29588
net_weight 0.05
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 69378
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 69378
2 SGG29588
3 paprika, 0.5 oz., bottle
timestamp 2015-03-27T14:47:54.2Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541039761
barcode_type UPC
col1 peacock
col1_sortorder 4438
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
cost 0.94
deal_of_the_week NO
description peacock, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 06369
list_price 2.2
map NO
mfr_num SGG39761
net_weight 0.05
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 06369
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 06369
2 SGG39761
3 peacock, 0.5 oz., bottle
timestamp 2015-03-27T14:46:16.724Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541038474
barcode_type UPC
col1 pine
col1_sortorder 4708
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 50-64-40.jpg
cost 0.94
deal_of_the_week NO
description pine, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 04493
list_price 2.2
map NO
mfr_num SGG38474
net_weight 0.05
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 04493
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 04493
2 SGG38474
3 pine, 0.5 oz., bottle
timestamp 2015-03-27T14:46:12.664Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541001874
barcode_type UPC
col1 pink
col1_sortorder 4716
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 240-183-217.jpg
cost 0.94
deal_of_the_week NO
description pink, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 75006
list_price 2.2
map NO
mfr_num SGG01874
net_weight 0.04
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 75006
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 75006
2 SGG01874
3 pink, 0.5 oz., bottle
timestamp 2015-03-27T14:48:05.096Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541038481
barcode_type UPC
col1 pink taffeta
col1_sortorder 4761
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 137-104-114.jpg
cost 0.94
deal_of_the_week NO
description pink taffeta, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 04494
list_price 2.2
map NO
mfr_num SGG38481
net_weight 0.05
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 04494
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 04494
2 SGG38481
3 pink taffeta, 0.5 oz., bottle
timestamp 2015-03-27T14:46:12.667Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e0303c6b2c1edbfc47001b24342449453019
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html
urltoken CFID=29397606&CFTOKEN=12531877&jsessionid=e0303c6b2c1edbfc47001b24342449453019
validationerror [empty string]


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

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

ItemIDList: 40209
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 39
barcode 789541009696
barcode_type UPC
col1 platinum
col1_sortorder 4776
col2 0.5 oz.
col2_sortorder 125
col3 bottle
col3_sortorder 239
color_swatch 225-225-225.jpg
cost 0.94
deal_of_the_week NO
description platinum, 0.5 oz., bottle
group_id 6015
group_uname ranger-stickles-glitter-glue
id 77352
list_price 2.2
map NO
mfr_num SGG09696
net_weight 0.04
non_member_discount 29
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 77352
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.1
ta_dealer_c_price 1.1
ta_price 1.65
text
array
1 77352
2 SGG09696
3 platinum, 0.5 oz., bottle
timestamp 2015-03-27T14:48:07.134Z
vip_member_price 1.34

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40209
CACHED false
EXECUTIONTIME 4
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] = '6475' 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.89.118.108

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fb~ranger~&gr=ranger-stickles-glitter-glue.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 13:07:20'}
sessionid e030312376a4dbd949593b3565396a6a4429
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fb~tacro~fp~17-23~&gr=tacro-giant-speed-bow-compass-set.html
urltoken CFID=29397607&CFTOKEN=19181568&jsessionid=e030312376a4dbd949593b3565396a6a4429
validationerror [empty string]


EndSessionVariables: