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

Catalyst Silicone Tools

by Princeton


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653260
barcode_type UPC
col1 blade size 15
col1_sortorder 1046
col2 no. 1
col2_sortorder 326
col3 grey
col3_sortorder 2694
cost 4.31
deal_of_the_week NO
description blade size 15, no. 1, grey
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 60784
list_price 13.99
map NO
mfr_num B15-01
net_weight 0.04
non_member_discount 50
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60784
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.04
ta_dealer_c_price 4.76
ta_price 9.09
text
array
1 60784
2 B15-01
3 blade size 15, no. 1, grey
timestamp 2015-03-27T14:47:39.118Z
vip_member_price 5.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653277
barcode_type UPC
col1 blade size 15
col1_sortorder 1046
col2 no. 2
col2_sortorder 327
col3 blue
col3_sortorder 542
cost 4.31
deal_of_the_week NO
description blade size 15, no. 2, blue
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 60786
list_price 13.99
map NO
mfr_num B15-02
net_weight 0.04
non_member_discount 50
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60786
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.04
ta_dealer_c_price 4.76
ta_price 9.09
text
array
1 60786
2 B15-02
3 blade size 15, no. 2, blue
timestamp 2015-03-27T14:47:39.123Z
vip_member_price 5.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653284
barcode_type UPC
col1 blade size 15
col1_sortorder 1046
col2 no. 3
col2_sortorder 328
col3 green
col3_sortorder 2621
cost 4.31
deal_of_the_week NO
description blade size 15, no. 3, green
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 60788
list_price 13.99
map NO
mfr_num B15-03
net_weight 0.05
non_member_discount 50
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60788
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.04
ta_dealer_c_price 4.76
ta_price 9.09
text
array
1 60788
2 B15-03
3 blade size 15, no. 3, green
timestamp 2015-03-27T14:47:39.127Z
vip_member_price 5.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653291
barcode_type UPC
col1 blade size 15
col1_sortorder 1046
col2 no. 4
col2_sortorder 329
col3 yellow
col3_sortorder 6670
cost 4.31
deal_of_the_week NO
description blade size 15, no. 4, yellow
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 60789
list_price 13.99
map NO
mfr_num B15-04
net_weight 0.05
non_member_discount 50
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60789
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.04
ta_dealer_c_price 4.76
ta_price 9.09
text
array
1 60789
2 B15-04
3 blade size 15, no. 4, yellow
timestamp 2015-03-27T14:47:39.129Z
vip_member_price 5.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653307
barcode_type UPC
col1 blade size 15
col1_sortorder 1046
col2 no. 5
col2_sortorder 330
col3 orange
col3_sortorder 4215
cost 4.31
deal_of_the_week NO
description blade size 15, no. 5, orange
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 60790
list_price 13.99
map NO
mfr_num B15-05
net_weight 0.05
non_member_discount 50
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60790
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.04
ta_dealer_c_price 4.76
ta_price 9.09
text
array
1 60790
2 B15-05
3 blade size 15, no. 5, orange
timestamp 2015-03-27T14:47:39.132Z
vip_member_price 5.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653314
barcode_type UPC
col1 blade size 15
col1_sortorder 1046
col2 No. 6
col2_sortorder 331
col3 white
col3_sortorder 6534
cost 4.31
deal_of_the_week NO
description blade size 15, No. 6, white
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 60792
list_price 13.99
map NO
mfr_num B15-06
net_weight 0.04
non_member_discount 50
non_member_price 6.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60792
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.04
ta_dealer_c_price 4.76
ta_price 9.09
text
array
1 60792
2 B15-06
3 blade size 15, No. 6, white
timestamp 2015-03-27T14:47:39.136Z
vip_member_price 5.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653321
barcode_type UPC
col1 blade size 30
col1_sortorder 1047
col2 no. 1
col2_sortorder 326
col3 grey
col3_sortorder 2694
cost 5.22
deal_of_the_week NO
description blade size 30, no. 1, grey
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 60793
list_price 16.99
map NO
mfr_num B30-01
net_weight 0.11
non_member_discount 50
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 60793
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.12
ta_dealer_c_price 5.78
ta_price 11.04
text
array
1 60793
2 B30-01
3 blade size 30, no. 1, grey
timestamp 2015-03-27T14:47:39.142Z
vip_member_price 6.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653338
barcode_type UPC
col1 blade size 30
col1_sortorder 1047
col2 no. 2
col2_sortorder 327
col3 blue
col3_sortorder 542
cost 5.22
deal_of_the_week NO
description blade size 30, no. 2, blue
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 60794
list_price 16.99
map NO
mfr_num B30-02
net_weight 0.11
non_member_discount 50
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 60794
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.12
ta_dealer_c_price 5.78
ta_price 11.04
text
array
1 60794
2 B30-02
3 blade size 30, no. 2, blue
timestamp 2015-03-27T14:47:39.145Z
vip_member_price 6.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653345
barcode_type UPC
col1 blade size 30
col1_sortorder 1047
col2 no. 3
col2_sortorder 328
col3 green
col3_sortorder 2621
cost 5.22
deal_of_the_week NO
description blade size 30, no. 3, green
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 60795
list_price 16.99
map NO
mfr_num B30-03
net_weight 0.11
non_member_discount 50
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 60795
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.12
ta_dealer_c_price 5.78
ta_price 11.04
text
array
1 60795
2 B30-03
3 blade size 30, no. 3, green
timestamp 2015-03-27T14:47:39.147Z
vip_member_price 6.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653352
barcode_type UPC
col1 blade size 30
col1_sortorder 1047
col2 no. 4
col2_sortorder 329
col3 yellow
col3_sortorder 6670
cost 5.22
deal_of_the_week NO
description blade size 30, no. 4, yellow
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 60796
list_price 16.99
map NO
mfr_num B30-04
net_weight 0.11
non_member_discount 50
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 60796
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.12
ta_dealer_c_price 5.78
ta_price 11.04
text
array
1 60796
2 B30-04
3 blade size 30, no. 4, yellow
timestamp 2015-03-27T14:47:39.149Z
vip_member_price 6.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653369
barcode_type UPC
col1 blade size 30
col1_sortorder 1047
col2 no. 5
col2_sortorder 330
col3 orange
col3_sortorder 4215
cost 5.22
deal_of_the_week NO
description blade size 30, no. 5, orange
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 60797
list_price 16.99
map NO
mfr_num B30-05
net_weight 0.11
non_member_discount 50
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 60797
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.12
ta_dealer_c_price 5.78
ta_price 11.04
text
array
1 60797
2 B30-05
3 blade size 30, no. 5, orange
timestamp 2015-03-27T14:47:39.151Z
vip_member_price 6.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653376
barcode_type UPC
col1 blade size 30
col1_sortorder 1047
col2 No. 6
col2_sortorder 331
col3 white
col3_sortorder 6534
cost 5.22
deal_of_the_week NO
description blade size 30, No. 6, white
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 60798
list_price 16.99
map NO
mfr_num B30-06
net_weight 0.11
non_member_discount 50
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 60798
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.12
ta_dealer_c_price 5.78
ta_price 11.04
text
array
1 60798
2 B30-06
3 blade size 30, No. 6, white
timestamp 2015-03-27T14:47:39.153Z
vip_member_price 6.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653383
barcode_type UPC
col1 blade size 50
col1_sortorder 1048
col2 no. 1
col2_sortorder 326
col3 grey
col3_sortorder 2694
cost 6.15
deal_of_the_week NO
description blade size 50, no. 1, grey
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 60801
list_price 19.99
map NO
mfr_num B50-01
net_weight 0.19
non_member_discount 50
non_member_price 9.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60801
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.2
ta_dealer_c_price 6.8
ta_price 12.99
text
array
1 60801
2 B50-01
3 blade size 50, no. 1, grey
timestamp 2015-03-27T14:47:39.161Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653390
barcode_type UPC
col1 blade size 50
col1_sortorder 1048
col2 no. 2
col2_sortorder 327
col3 blue
col3_sortorder 542
cost 6.15
deal_of_the_week NO
description blade size 50, no. 2, blue
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 60804
list_price 19.99
map NO
mfr_num B50-02
net_weight 0.19
non_member_discount 50
non_member_price 9.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60804
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.2
ta_dealer_c_price 6.8
ta_price 12.99
text
array
1 60804
2 B50-02
3 blade size 50, no. 2, blue
timestamp 2015-03-27T14:47:39.171Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653406
barcode_type UPC
col1 blade size 50
col1_sortorder 1048
col2 no. 3
col2_sortorder 328
col3 green
col3_sortorder 2621
cost 6.15
deal_of_the_week NO
description blade size 50, no. 3, green
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 60805
list_price 19.99
map NO
mfr_num B50-03
net_weight 0.18
non_member_discount 50
non_member_price 9.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60805
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.2
ta_dealer_c_price 6.8
ta_price 12.99
text
array
1 60805
2 B50-03
3 blade size 50, no. 3, green
timestamp 2015-03-27T14:47:39.173Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653413
barcode_type UPC
col1 blade size 50
col1_sortorder 1048
col2 no. 4
col2_sortorder 329
col3 yellow
col3_sortorder 6670
cost 6.15
deal_of_the_week NO
description blade size 50, no. 4, yellow
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 60806
list_price 19.99
map NO
mfr_num B50-04
net_weight 0.18
non_member_discount 50
non_member_price 9.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60806
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.2
ta_dealer_c_price 6.8
ta_price 12.99
text
array
1 60806
2 B50-04
3 blade size 50, no. 4, yellow
timestamp 2015-03-27T14:47:39.175Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653420
barcode_type UPC
col1 blade size 50
col1_sortorder 1048
col2 no. 5
col2_sortorder 330
col3 orange
col3_sortorder 4215
cost 6.15
deal_of_the_week NO
description blade size 50, no. 5, orange
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 60807
list_price 19.99
map NO
mfr_num B50-05
net_weight 0.2
non_member_discount 50
non_member_price 9.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60807
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.2
ta_dealer_c_price 6.8
ta_price 12.99
text
array
1 60807
2 B50-05
3 blade size 50, no. 5, orange
timestamp 2015-03-27T14:47:39.178Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653437
barcode_type UPC
col1 blade size 50
col1_sortorder 1048
col2 No. 6
col2_sortorder 331
col3 white
col3_sortorder 6534
cost 6.15
deal_of_the_week NO
description blade size 50, No. 6, white
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 60809
list_price 19.99
map NO
mfr_num B50-06
net_weight 0.17
non_member_discount 50
non_member_price 9.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60809
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.2
ta_dealer_c_price 6.8
ta_price 12.99
text
array
1 60809
2 B50-06
3 blade size 50, No. 6, white
timestamp 2015-03-27T14:47:39.187Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653505
barcode_type UPC
col1 contour
col1_sortorder 1610
col2 No. 21
col2_sortorder 343
col3 green
col3_sortorder 2621
cost 1.84
deal_of_the_week NO
description contour, No. 21, green
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 03969
list_price 5.99
map NO
mfr_num C-21
net_weight 0.04
non_member_discount 50
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 03969
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.16
ta_dealer_c_price 2.04
ta_price 3.89
text
array
1 03969
2 C-21
3 contour, No. 21, green
timestamp 2015-03-27T14:46:11.834Z
vip_member_price 2.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653512
barcode_type UPC
col1 contour
col1_sortorder 1610
col2 no. 22
col2_sortorder 344
col3 green
col3_sortorder 2621
cost 1.84
deal_of_the_week NO
description contour, no. 22, green
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 03970
list_price 5.99
map NO
mfr_num C-22
net_weight 0.04
non_member_discount 50
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 03970
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.16
ta_dealer_c_price 2.04
ta_price 3.89
text
array
1 03970
2 C-22
3 contour, no. 22, green
timestamp 2015-03-27T14:46:11.836Z
vip_member_price 2.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653529
barcode_type UPC
col1 contour
col1_sortorder 1610
col2 no. 23
col3 green
col3_sortorder 2621
cost 1.84
deal_of_the_week NO
description contour, no. 23, green
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 03971
list_price 5.99
map NO
mfr_num C-23
net_weight 0.04
non_member_discount 50
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 03971
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.16
ta_dealer_c_price 2.04
ta_price 3.89
text
array
1 03971
2 C-23
3 contour, no. 23, green
timestamp 2015-03-27T14:46:11.838Z
vip_member_price 2.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653536
barcode_type UPC
col1 contour
col1_sortorder 1610
col2 no. 24
col3 green
col3_sortorder 2621
cost 1.84
deal_of_the_week NO
description contour, no. 24, green
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 03972
list_price 5.99
map NO
mfr_num C-24
net_weight 0.04
non_member_discount 50
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 03972
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.16
ta_dealer_c_price 2.04
ta_price 3.89
text
array
1 03972
2 C-24
3 contour, no. 24, green
timestamp 2015-03-27T14:46:11.842Z
vip_member_price 2.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653581
barcode_type UPC
col1 contour
col1_sortorder 1610
col2 No. 61
col2_sortorder 349
col3 mint
col3_sortorder 3782
cost 1.84
deal_of_the_week NO
description contour, No. 61, mint
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 03973
list_price 5.99
map NO
mfr_num C-61
net_weight 0.04
non_member_discount 50
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 03973
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.16
ta_dealer_c_price 2.04
ta_price 3.89
text
array
1 03973
2 C-61
3 contour, No. 61, mint
timestamp 2015-03-27T14:46:11.847Z
vip_member_price 2.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653598
barcode_type UPC
col1 contour
col1_sortorder 1610
col2 No. 62
col2_sortorder 350
col3 mint
col3_sortorder 3782
cost 1.84
deal_of_the_week NO
description contour, No. 62, mint
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 03974
list_price 5.99
map NO
mfr_num C-62
net_weight 0.04
non_member_discount 50
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 03974
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.16
ta_dealer_c_price 2.04
ta_price 3.89
text
array
1 03974
2 C-62
3 contour, No. 62, mint
timestamp 2015-03-27T14:46:11.853Z
vip_member_price 2.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653604
barcode_type UPC
col1 contour
col1_sortorder 1610
col2 no. 63
col2_sortorder 351
col3 mint
col3_sortorder 3782
cost 1.84
deal_of_the_week NO
description contour, no. 63, mint
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 03975
list_price 5.99
map NO
mfr_num C-63
net_weight 0.04
non_member_discount 50
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 03975
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.16
ta_dealer_c_price 2.04
ta_price 3.89
text
array
1 03975
2 C-63
3 contour, no. 63, mint
timestamp 2015-03-27T14:46:11.856Z
vip_member_price 2.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653611
barcode_type UPC
col1 contour
col1_sortorder 1610
col2 No. 64
col2_sortorder 352
col3 mint
col3_sortorder 3782
cost 1.84
deal_of_the_week NO
description contour, No. 64, mint
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 03976
list_price 5.99
map NO
mfr_num C-64
net_weight 0.04
non_member_discount 50
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 03976
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.16
ta_dealer_c_price 2.04
ta_price 3.89
text
array
1 03976
2 C-64
3 contour, No. 64, mint
timestamp 2015-03-27T14:46:11.861Z
vip_member_price 2.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653628
barcode_type UPC
col1 contour
col1_sortorder 1610
col2 No. 81
col2_sortorder 353
col3 taupe
col3_sortorder 5931
cost 1.84
deal_of_the_week NO
description contour, No. 81, taupe
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 03977
list_price 5.99
map NO
mfr_num C-81
net_weight 0.04
non_member_discount 50
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 03977
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.16
ta_dealer_c_price 2.04
ta_price 3.89
text
array
1 03977
2 C-81
3 contour, No. 81, taupe
timestamp 2015-03-27T14:46:11.864Z
vip_member_price 2.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653635
barcode_type UPC
col1 contour
col1_sortorder 1610
col2 No. 82
col2_sortorder 354
col3 taupe
col3_sortorder 5931
cost 1.84
deal_of_the_week NO
description contour, No. 82, taupe
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 03978
list_price 5.99
map NO
mfr_num C-82
net_weight 0.04
non_member_discount 50
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 03978
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.16
ta_dealer_c_price 2.04
ta_price 3.89
text
array
1 03978
2 C-82
3 contour, No. 82, taupe
timestamp 2015-03-27T14:46:11.866Z
vip_member_price 2.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653642
barcode_type UPC
col1 contour
col1_sortorder 1610
col2 No. 83
col2_sortorder 355
col3 taupe
col3_sortorder 5931
cost 1.84
deal_of_the_week NO
description contour, No. 83, taupe
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 03979
list_price 5.99
map NO
mfr_num C-83
net_weight 0.05
non_member_discount 50
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 03979
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.16
ta_dealer_c_price 2.04
ta_price 3.89
text
array
1 03979
2 C-83
3 contour, No. 83, taupe
timestamp 2015-03-27T14:46:11.87Z
vip_member_price 2.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653659
barcode_type UPC
col1 contour
col1_sortorder 1610
col2 No. 84
col2_sortorder 356
col3 taupe
col3_sortorder 5931
cost 1.84
deal_of_the_week NO
description contour, No. 84, taupe
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 03980
list_price 5.99
map NO
mfr_num C-84
net_weight 0.05
non_member_discount 50
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 03980
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.16
ta_dealer_c_price 2.04
ta_price 3.89
text
array
1 03980
2 C-84
3 contour, No. 84, taupe
timestamp 2015-03-27T14:46:11.875Z
vip_member_price 2.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 97.000000000000 42884
2 34.000000000000 48108
3 18.000000000000 50096
4 30.000000000000 55346
5 30.000000000000 62426
6 31.000000000000 65348
7 11.000000000000 77274
CACHED false
EXECUTIONTIME 2
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] = '604' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e0305cc55fa8c325fe6f2a1766785660364b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=sort~1~fb~borden-riley~fp~7-10~&gr=borden-riley-51h-parchment-tracing-paper.html
urltoken CFID=29821799&CFTOKEN=31186856&jsessionid=e0305cc55fa8c325fe6f2a1766785660364b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 00:12:47'}
sessionid e030ea4b3b768ac18df234dd7c97ff11117f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~princeton~fp~5-11~c1~painting~&gr=princeton-catalyst-silicone-tools.html
urltoken CFID=29821800&CFTOKEN=19750616&jsessionid=e030ea4b3b768ac18df234dd7c97ff11117f
validationerror [empty string]


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

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

ItemIDList: 42884,48108,50096,55346,62426,65348,77274
AvailQtyList: 97.000000000000,34.000000000000,18.000000000000,30.000000000000,30.000000000000,31.000000000000,11.000000000000

struct
VIP_member_discount 60
barcode 757063653666
barcode_type UPC
col1 mini blades
col1_sortorder 3871
col2 no. 1
col2_sortorder 326
col3 white
col3_sortorder 6534
cost 2.45
deal_of_the_week NO
description mini blades, no. 1, white
flags
array
1 1
group_id 11015
group_uname princeton-catalyst-silicone-tools
id 03981
list_price 7.99
map NO
mfr_num M-01
net_weight 0.05
non_member_discount 50
non_member_price 3.99
prop65 NO
ship_rule_desc STD