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

Crackle & Crystal Glazes

by Duncan


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754271440
barcode_type UPC
col1 African savanna
col1_sortorder 63
col2 CR859
col2_sortorder 1417
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description African savanna, CR859, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 59876
list_price 5.9
map NO
mfr_num CR859-4 27144
net_weight 0.45
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 59876
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 59876
2 CR859-4 27144
3 African savanna, CR859, 4 oz.
timestamp 2015-03-30T16:20:53.97Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754271426
barcode_type UPC
col1 Alpine meadow
col1_sortorder 104
col2 CR857
col2_sortorder 1415
col3 4 oz.
col3_sortorder 1804
cost 2.59
deal_of_the_week NO
description Alpine meadow, CR857, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 59887
list_price 5.65
map NO
mfr_num CR857-4 27142
net_weight 0.45
non_member_discount 20
non_member_price 4.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 59887
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.39
ta_dealer_c_price 2.83
ta_price 5.65
text
array
1 59887
2 CR857-4 27142
3 Alpine meadow, CR857, 4 oz.
timestamp 2015-03-30T16:20:54.108Z
vip_member_price 3.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754271419
barcode_type UPC
col1 ancient woodland
col1_sortorder 124
col2 CR856
col2_sortorder 1414
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description ancient woodland, CR856, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 59888
list_price 5.9
map NO
mfr_num CR856-4 27141
net_weight 0.46
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 59888
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 59888
2 CR856-4 27141
3 ancient woodland, CR856, 4 oz.
timestamp 2015-03-30T16:20:54.124Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754982773
barcode_type UPC
col1 blueberries
col1_sortorder 626
col2 CR905
col2_sortorder 1422
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description blueberries, CR905, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 29632
list_price 5.9
map NO
mfr_num CR905-4 98277
net_weight 0.42
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 29632
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 29632
2 CR905-4 98277
3 blueberries, CR905, 4 oz.
timestamp 2015-03-30T16:19:55.904Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754211897
barcode_type UPC
col1 caramel latte
col1_sortorder 1097
col2 CR917
col2_sortorder 1434
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description caramel latte, CR917, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 35882
list_price 5.9
map NO
mfr_num CR917-4 21189
net_weight 0.42
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 35882
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 35882
2 CR917-4 21189
3 caramel latte, CR917, 4 oz.
timestamp 2015-03-30T16:20:15.472Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754982872
barcode_type UPC
col1 celadon crackle
col1_sortorder 1142
col2 CR823
col2_sortorder 1407
col3 4 oz.
col3_sortorder 1804
cost 1.81
deal_of_the_week NO
description celadon crackle, CR823, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 14366
list_price 3.95
map NO
mfr_num CR823-4 98287
net_weight 0.42
non_member_discount 20
non_member_price 3.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 14366
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 1.98
ta_price 3.95
text
array
1 14366
2 CR823-4 98287
3 celadon crackle, CR823, 4 oz.
timestamp 2015-03-30T16:19:25.049Z
vip_member_price 2.77

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754211910
barcode_type UPC
col1 cherry blossom
col1_sortorder 1197
col2 CR918
col2_sortorder 1435
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description cherry blossom, CR918, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 63345
list_price 5.9
map NO
mfr_num CR918-4 21191
net_weight 0.42
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 63345
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 63345
2 CR918-4 21191
3 cherry blossom, CR918, 4 oz.
timestamp 2015-03-30T16:21:04.264Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754914859
barcode_type UPC
col1 clear crackle
col1_sortorder 1324
col2 CR800
col2_sortorder 1404
col3 4 oz.
col3_sortorder 1804
cost 1.81
deal_of_the_week NO
description clear crackle, CR800, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 45064
list_price 3.95
map NO
mfr_num CR800-4 91485
net_weight 0.4
non_member_discount 20
non_member_price 3.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 45064
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 1.98
ta_price 3.95
text
array
1 45064
2 CR800-4 91485
3 clear crackle, CR800, 4 oz.
timestamp 2015-03-30T16:20:30.209Z
vip_member_price 2.77

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754982889
barcode_type UPC
col1 cranberry frost
col1_sortorder 1590
col2 CR913
col2_sortorder 1430
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description cranberry frost, CR913, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 39925
list_price 5.9
map NO
mfr_num CR913-4 98288
net_weight 0.42
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 39925
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 39925
2 CR913-4 98288
3 cranberry frost, CR913, 4 oz.
timestamp 2015-03-30T16:20:23.538Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754271358
barcode_type UPC
col1 cumulus clouds
col1_sortorder 1642
col2 CR850
col2_sortorder 1408
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description cumulus clouds, CR850, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 59898
list_price 5.9
map NO
mfr_num CR850-4 27135
net_weight 0.43
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 59898
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 59898
2 CR850-4 27135
3 cumulus clouds, CR850, 4 oz.
timestamp 2015-03-30T16:20:54.277Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754982759
barcode_type UPC
col1 emerald falls
col1_sortorder 2035
col2 CR903
col2_sortorder 1420
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description emerald falls, CR903, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 26203
list_price 5.9
map NO
mfr_num CR903-4 98275
net_weight 0.42
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 26203
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 26203
2 CR903-4 98275
3 emerald falls, CR903, 4 oz.
timestamp 2015-03-30T16:19:49.776Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754271365
barcode_type UPC
col1 eternal galaxy
col1_sortorder 2074
col2 CR851
col2_sortorder 1409
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description eternal galaxy, CR851, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 59897
list_price 5.9
map NO
mfr_num CR851-4 27136
net_weight 0.45
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 59897
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 59897
2 CR851-4 27136
3 eternal galaxy, CR851, 4 oz.
timestamp 2015-03-30T16:20:54.261Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754982827
barcode_type UPC
col1 forest moss
col1_sortorder 2252
col2 CR910
col2_sortorder 1427
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description forest moss, CR910, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 50936
list_price 5.9
map NO
mfr_num CR910-4 98282
net_weight 0.42
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 50936
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 50936
2 CR910-4 98282
3 forest moss, CR910, 4 oz.
timestamp 2015-03-30T16:20:39.206Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754982766
barcode_type UPC
col1 fudge marble
col1_sortorder 2365
col2 CR904
col2_sortorder 1421
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description fudge marble, CR904, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 62425
list_price 5.9
map NO
mfr_num CR904-4 98276
net_weight 0.42
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 62425
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 62425
2 CR904-4 98276
3 fudge marble, CR904, 4 oz.
timestamp 2015-03-30T16:21:02.048Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754211972
barcode_type UPC
col1 glacier storm
col1_sortorder 2424
col2 CR921
col2_sortorder 1438
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description glacier storm, CR921, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 42950
list_price 5.9
map NO
mfr_num CR921-4 21197
net_weight 0.42
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 42950
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 42950
2 CR921-4 21197
3 glacier storm, CR921, 4 oz.
timestamp 2015-03-30T16:20:27.428Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754998088
barcode_type UPC
col1 grape splash
col1_sortorder 2588
col2 CR914
col2_sortorder 1431
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description grape splash, CR914, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 82701
list_price 5.9
map NO
mfr_num CR914-4 99808
net_weight 0.42
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 82701
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 82701
2 CR914-4 99808
3 grape splash, CR914, 4 oz.
timestamp 2015-03-30T16:21:49.347Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754211873
barcode_type UPC
col1 holly berries
col1_sortorder 2825
col2 CR916
col2_sortorder 1433
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description holly berries, CR916, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 22896
list_price 5.9
map NO
mfr_num CR916-4 21187
net_weight 0.42
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 22896
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 22896
2 CR916-4 21187
3 holly berries, CR916, 4 oz.
timestamp 2015-03-30T16:19:44.359Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754982797
barcode_type UPC
col1 la fiesta
col1_sortorder 3225
col2 CR907
col2_sortorder 1424
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description la fiesta, CR907, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 22229
list_price 5.9
map NO
mfr_num CR907-4 98279
net_weight 0.42
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 22229
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 22229
2 CR907-4 98279
3 la fiesta, CR907, 4 oz.
timestamp 2015-03-30T16:19:42.927Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754211934
barcode_type UPC
col1 milky way
col1_sortorder 3775
col2 CR919
col2_sortorder 1436
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description milky way, CR919, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 63968
list_price 5.9
map NO
mfr_num CR919-4 21193
net_weight 0.42
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 63968
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 63968
2 CR919-4 21193
3 milky way, CR919, 4 oz.
timestamp 2015-03-30T16:21:05.393Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754982865
barcode_type UPC
col1 mocha cream crackle
col1_sortorder 3816
col2 CR822
col2_sortorder 1406
col3 4 oz.
col3_sortorder 1804
cost 1.81
deal_of_the_week NO
description mocha cream crackle, CR822, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 68156
list_price 3.95
map NO
mfr_num CR822-4 98286
net_weight 0.45
non_member_discount 20
non_member_price 3.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 68156
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 1.98
ta_price 3.95
text
array
1 68156
2 CR822-4 98286
3 mocha cream crackle, CR822, 4 oz.
timestamp 2015-03-30T16:21:15.958Z
vip_member_price 2.77

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754982803
barcode_type UPC
col1 Monet's garden
col1_sortorder 3824
col2 CR908
col2_sortorder 1425
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description Monet's garden, CR908, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 51502
list_price 5.9
map NO
mfr_num CR908-4 98280
net_weight 0.42
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 51502
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 51502
2 CR908-4 98280
3 Monet's garden, CR908, 4 oz.
timestamp 2015-03-30T16:20:39.686Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754982810
barcode_type UPC
col1 moss green
col1_sortorder 3853
col2 CR909
col2_sortorder 1426
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description moss green, CR909, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 83023
list_price 5.9
map NO
mfr_num CR909-4 98281
net_weight 0.42
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 83023
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 83023
2 CR909-4 98281
3 moss green, CR909, 4 oz.
timestamp 2015-03-30T16:21:49.766Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754998095
barcode_type UPC
col1 night frost
col1_sortorder 4094
col2 CR915
col2_sortorder 1432
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description night frost, CR915, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 74851
list_price 5.9
map NO
mfr_num CR915-4 99809
net_weight 0.42
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 74851
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 74851
2 CR915-4 99809
3 night frost, CR915, 4 oz.
timestamp 2015-03-30T16:21:39.599Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754982742
barcode_type UPC
col1 night sky
col1_sortorder 4097
col2 CR902
col2_sortorder 1419
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description night sky, CR902, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 37009
list_price 5.9
map NO
mfr_num CR902-4 98274
net_weight 0.42
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 37009
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 37009
2 CR902-4 98274
3 night sky, CR902, 4 oz.
timestamp 2015-03-30T16:20:18.14Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754982834
barcode_type UPC
col1 ocean mist
col1_sortorder 4126
col2 CR911
col2_sortorder 1428
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description ocean mist, CR911, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 18805
list_price 5.9
map NO
mfr_num CR911-4 98283
net_weight 0.42
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 18805
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 18805
2 CR911-4 98283
3 ocean mist, CR911, 4 oz.
timestamp 2015-03-30T16:19:37.071Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754271396
barcode_type UPC
col1 outer space
col1_sortorder 4280
col2 CR854
col2_sortorder 1412
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description outer space, CR854, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 59893
list_price 5.9
map NO
mfr_num CR854-4 27139
net_weight 0.45
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 59893
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 59893
2 CR854-4 27139
3 outer space, CR854, 4 oz.
timestamp 2015-03-30T16:20:54.208Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754982858
barcode_type UPC
col1 parchment crackle
col1_sortorder 4386
col2 CR821
col2_sortorder 1405
col3 4 oz.
col3_sortorder 1804
cost 1.81
deal_of_the_week NO
description parchment crackle, CR821, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 59818
list_price 3.95
map NO
mfr_num CR821-4 98285
net_weight 0.42
non_member_discount 20
non_member_price 3.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 59818
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 1.98
ta_price 3.95
text
array
1 59818
2 CR821-4 98285
3 parchment crackle, CR821, 4 oz.
timestamp 2015-03-30T16:20:53.307Z
vip_member_price 2.77

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754982780
barcode_type UPC
col1 peppered raspberry
col1_sortorder 4530
col2 CR906
col2_sortorder 1423
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description peppered raspberry, CR906, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 60547
list_price 5.9
map NO
mfr_num CR906-4 98278
net_weight 0.42
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 60547
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 60547
2 CR906-4 98278
3 peppered raspberry, CR906, 4 oz.
timestamp 2015-03-30T16:20:56.277Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754271433
barcode_type UPC
col1 Polynesian lagoon
col1_sortorder 4809
col2 CR858
col2_sortorder 1416
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description Polynesian lagoon, CR858, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 59877
list_price 5.9
map NO
mfr_num CR858-4 27143
net_weight 0.43
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 59877
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 59877
2 CR858-4 27143
3 Polynesian lagoon, CR858, 4 oz.
timestamp 2015-03-30T16:20:53.99Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754271389
barcode_type UPC
col1 sailor's delight
col1_sortorder 5331
col2 CR853
col2_sortorder 1411
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description sailor's delight, CR853, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 59895
list_price 5.9
map NO
mfr_num CR853-4 27138
net_weight 0.45
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 59895
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 59895
2 CR853-4 27138
3 sailor's delight, CR853, 4 oz.
timestamp 2015-03-30T16:20:54.234Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754271372
barcode_type UPC
col1 solar flares
col1_sortorder 5692
col2 CR852
col2_sortorder 1410
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description solar flares, CR852, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 59896
list_price 5.9
map NO
mfr_num CR852-4 27137
net_weight 0.45
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 59896
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 59896
2 CR852-4 27137
3 solar flares, CR852, 4 oz.
timestamp 2015-03-30T16:20:54.25Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302a781609ba7dc46235e6d361c2a6b027
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html
urltoken CFID=30317451&CFTOKEN=24729283&jsessionid=e0302a781609ba7dc46235e6d361c2a6b027
validationerror [empty string]


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

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

ItemIDList: 64838
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754982841
barcode_type UPC
col1 spring meadow
col1_sortorder 5770
col2 CR912
col2_sortorder 1429
col3 4 oz.
col3_sortorder 1804
cost 2.7
deal_of_the_week NO
description spring meadow, CR912, 4 oz.
group_id 7748
group_uname duncan-crackle-crystal-glazes
id 42885
list_price 5.9
map NO
mfr_num CR912-4 98284
net_weight 0.42
non_member_discount 20
non_member_price 4.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 42885
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.54
ta_dealer_c_price 2.95
ta_price 5.9
text
array
1 42885
2 CR912-4 98284
3 spring meadow, CR912, 4 oz.
timestamp 2015-03-30T16:20:27.386Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 64838
CACHED false
EXECUTIONTIME 1
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] = '12263' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-top-rated&paramOpts=fb~duncan~&gr=duncan-crackle-crystal-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 18:43:04'}
sessionid e0302902fb29830bfa212d534b55c637f64f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=sort~1~fb~surebonder~fp~9-43~&gr=surebonder-cl-800-cordless-high-temperature-glue-gun.html
urltoken CFID=30317452&CFTOKEN=44937020&jsessionid=e0302902fb29830bfa212d534b55c637f64f
validationerror [empty string]


EndSessionVariables: