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

Basics Acrylics Colors

by Liquitex


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376974690
barcode_type UPC
col1 acra magenta
col1_sortorder 53
col2 8.5 oz.
col2_sortorder 2340
col3 tube
col3_sortorder 684
color_swatch 154-0-89.jpg
cost 5.08
deal_of_the_week NO
description acra magenta, 8.5 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 28425
list_price 11.89
map NO
mfr_num 4385114
net_weight 0.85
non_member_discount 43
non_member_price 6.78
prop65 NO
ship_rule_desc STD
shipping STD
sku 28425
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.95
ta_dealer_c_price 5.59
ta_price 8.32
text
array
1 28425
2 4385114
3 acra magenta, 8.5 oz., tube
timestamp 2015-03-27T14:46:52.067Z
vip_member_price 6.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376922295
barcode_type UPC
col1 acra magenta
col1_sortorder 53
col2 4 oz.
col2_sortorder 1804
col3 tube
col3_sortorder 684
color_swatch 154-0-89.jpg
cost 3.28
deal_of_the_week NO
description acra magenta, 4 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 63552
list_price 7.69
map NO
mfr_num 1046114
net_weight 0.4
non_member_discount 43
non_member_price 4.38
prop65 NO
ship_rule_desc STD
shipping STD
sku 63552
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.85
ta_dealer_c_price 3.61
ta_price 5.38
text
array
1 63552
2 1046114
3 acra magenta, 4 oz., tube
timestamp 2015-03-27T14:47:43.82Z
vip_member_price 3.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376923544
barcode_type UPC
col1 acra magenta
col1_sortorder 53
col2 8 oz.
col2_sortorder 2317
col3 jar
col3_sortorder 346
color_swatch 154-0-89.jpg
cost 5.08
deal_of_the_week NO
description acra magenta, 8 oz., jar
group_id 550
group_uname liquitex-basics-acrylics-colors
id 72106
list_price 11.89
map NO
mfr_num 4608114
net_weight 0.66
non_member_discount 43
non_member_price 6.78
prop65 NO
ship_rule_desc STD
shipping STD
sku 72106
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.95
ta_dealer_c_price 5.59
ta_price 8.32
text
array
1 72106
2 4608114
3 acra magenta, 8 oz., jar
timestamp 2015-03-27T14:48:01.127Z
vip_member_price 6.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376922318
barcode_type UPC
col1 alizarin crimson hue
col1_sortorder 83
col2 4 oz.
col2_sortorder 1804
col3 tube
col3_sortorder 684
color_swatch 115-7-10.jpg
cost 3.28
deal_of_the_week NO
description alizarin crimson hue, 4 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 56942
list_price 7.69
map NO
mfr_num 1046116
net_weight 0.34
non_member_discount 43
non_member_price 4.38
prop65 NO
ship_rule_desc STD
shipping STD
sku 56942
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.85
ta_dealer_c_price 3.61
ta_price 5.38
text
array
1 56942
2 1046116
3 alizarin crimson hue, 4 oz., tube
timestamp 2015-03-27T14:47:32.015Z
vip_member_price 3.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376942293
barcode_type UPC
col1 alizarin crimson hue
col1_sortorder 83
col2 32 oz.
col2_sortorder 1660
col3 jar
col3_sortorder 346
color_swatch 115-7-10.jpg
cost 14.81
deal_of_the_week NO
description alizarin crimson hue, 32 oz., jar
group_id 550
group_uname liquitex-basics-acrylics-colors
id 62482
list_price 34.69
map NO
mfr_num 4332116
net_weight 2.24
non_member_discount 43
non_member_price 19.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 62482
sku_pix YES
supplier_id 1
ta_dealer_a_price 17.35
ta_dealer_c_price 16.3
ta_price 24.28
text
array
1 62482
2 4332116
3 alizarin crimson hue, 32 oz., jar
timestamp 2015-03-27T14:47:42.122Z
vip_member_price 17.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376922554
barcode_type UPC
col1 bright aqua green
col1_sortorder 687
col2 4 oz.
col2_sortorder 1804
col3 tube
col3_sortorder 684
color_swatch 14-179-167.jpg
cost 3.28
deal_of_the_week NO
description bright aqua green, 4 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 17973
list_price 7.69
map NO
mfr_num 1046660
net_weight 0.4
non_member_discount 43
non_member_price 4.38
prop65 NO
ship_rule_desc STD
shipping STD
sku 17973
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.85
ta_dealer_c_price 3.61
ta_price 5.38
text
array
1 17973
2 1046660
3 bright aqua green, 4 oz., tube
timestamp 2015-03-27T14:46:37.959Z
vip_member_price 3.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376974911
barcode_type UPC
col1 bright aqua green
col1_sortorder 687
col2 8.5 oz.
col2_sortorder 2340
col3 tube
col3_sortorder 684
color_swatch 14-179-167.jpg
cost 5.08
deal_of_the_week NO
description bright aqua green, 8.5 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 31963
list_price 11.89
map NO
mfr_num 4385660
net_weight 0.85
non_member_discount 43
non_member_price 6.78
prop65 NO
ship_rule_desc STD
shipping STD
sku 31963
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.95
ta_dealer_c_price 5.59
ta_price 8.32
text
array
1 31963
2 4385660
3 bright aqua green, 8.5 oz., tube
timestamp 2015-03-27T14:46:57.759Z
vip_member_price 6.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376974638
barcode_type UPC
col1 brilliant purple
col1_sortorder 760
col2 4 oz.
col2_sortorder 1804
col3 tube
col3_sortorder 684
color_swatch 139-102-172.jpg
cost 3.28
deal_of_the_week NO
description brilliant purple, 4 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 32664
list_price 7.69
map NO
mfr_num 1046590
net_weight 0.4
non_member_discount 43
non_member_price 4.38
prop65 NO
ship_rule_desc STD
shipping STD
sku 32664
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.85
ta_dealer_c_price 3.61
ta_price 5.38
text
array
1 32664
2 1046590
3 brilliant purple, 4 oz., tube
timestamp 2015-03-27T14:46:58.682Z
vip_member_price 3.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376974607
barcode_type UPC
col1 brilliant yellow green
col1_sortorder 774
col2 4 oz.
col2_sortorder 1804
col3 tube
col3_sortorder 684
color_swatch 194-227-99.jpg
cost 3.28
deal_of_the_week NO
description brilliant yellow green, 4 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 13390
list_price 7.69
map NO
mfr_num 1046840
net_weight 0.4
non_member_discount 43
non_member_price 4.38
prop65 NO
ship_rule_desc STD
shipping STD
sku 13390
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.85
ta_dealer_c_price 3.61
ta_price 5.38
text
array
1 13390
2 1046840
3 brilliant yellow green, 4 oz., tube
timestamp 2015-03-27T14:46:28.85Z
vip_member_price 3.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376974676
barcode_type UPC
col1 bronze
col1_sortorder 790
col2 4 oz.
col2_sortorder 1804
col3 tube
col3_sortorder 684
color_swatch 193-118-87.jpg
cost 3.28
deal_of_the_week NO
description bronze, 4 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 10219
list_price 7.69
map NO
mfr_num 1046229
net_weight 0.4
non_member_discount 43
non_member_price 4.38
prop65 NO
ship_rule_desc STD
shipping STD
sku 10219
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.85
ta_dealer_c_price 3.61
ta_price 5.38
text
array
1 10219
2 1046229
3 bronze, 4 oz., tube
timestamp 2015-03-27T14:46:24.227Z
vip_member_price 3.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376974591
barcode_type UPC
col1 bronze yellow
col1_sortorder 796
col2 4 oz.
col2_sortorder 1804
col3 tube
col3_sortorder 684
color_swatch 177-141-25.jpg
cost 3.28
deal_of_the_week NO
description bronze yellow, 4 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 18531
list_price 7.69
map NO
mfr_num 1046530
net_weight 0.4
non_member_discount 43
non_member_price 4.38
prop65 NO
ship_rule_desc STD
shipping STD
sku 18531
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.85
ta_dealer_c_price 3.61
ta_price 5.38
text
array
1 18531
2 1046530
3 bronze yellow, 4 oz., tube
timestamp 2015-03-27T14:46:38.705Z
vip_member_price 3.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376974713
barcode_type UPC
col1 burnt sienna
col1_sortorder 875
col2 8.5 oz.
col2_sortorder 2340
col3 tube
col3_sortorder 684
color_swatch 145-61-0.jpg
cost 5.08
deal_of_the_week NO
description burnt sienna, 8.5 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 19825
list_price 11.89
map NO
mfr_num 4385127
net_weight 0.85
non_member_discount 43
non_member_price 6.78
prop65 NO
ship_rule_desc STD
shipping STD
sku 19825
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.95
ta_dealer_c_price 5.59
ta_price 8.32
text
array
1 19825
2 4385127
3 burnt sienna, 8.5 oz., tube
timestamp 2015-03-27T14:46:39.917Z
vip_member_price 6.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376945560
barcode_type UPC
col1 burnt sienna
col1_sortorder 875
col2 32 oz.
col2_sortorder 1660
col3 jar
col3_sortorder 346
color_swatch 145-61-0.jpg
cost 14.81
deal_of_the_week NO
description burnt sienna, 32 oz., jar
group_id 550
group_uname liquitex-basics-acrylics-colors
id 50009
list_price 34.69
map NO
mfr_num 4332127
net_weight 2.61
non_member_discount 43
non_member_price 19.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 50009
sku_pix YES
supplier_id 1
ta_dealer_a_price 17.35
ta_dealer_c_price 16.3
ta_price 24.28
text
array
1 50009
2 4332127
3 burnt sienna, 32 oz., jar
timestamp 2015-03-27T14:47:24.37Z
vip_member_price 17.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376922325
barcode_type UPC
col1 burnt sienna
col1_sortorder 875
col2 4 oz.
col2_sortorder 1804
col3 tube
col3_sortorder 684
color_swatch 145-61-0.jpg
cost 3.28
deal_of_the_week NO
description burnt sienna, 4 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 71887
list_price 7.69
map NO
mfr_num 1046127
net_weight 0.4
non_member_discount 43
non_member_price 4.38
prop65 NO
ship_rule_desc STD
shipping STD
sku 71887
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.85
ta_dealer_c_price 3.61
ta_price 5.38
text
array
1 71887
2 1046127
3 burnt sienna, 4 oz., tube
timestamp 2015-03-27T14:48:00.771Z
vip_member_price 3.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376974720
barcode_type UPC
col1 burnt umber
col1_sortorder 886
col2 8.5 oz.
col2_sortorder 2340
col3 tube
col3_sortorder 684
color_swatch 68-39-15.jpg
cost 5.08
deal_of_the_week NO
description burnt umber, 8.5 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 11361
list_price 11.89
map NO
mfr_num 4385128
net_weight 0.85
non_member_discount 43
non_member_price 6.78
prop65 NO
ship_rule_desc STD
shipping STD
sku 11361
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.95
ta_dealer_c_price 5.59
ta_price 8.32
text
array
1 11361
2 4385128
3 burnt umber, 8.5 oz., tube
timestamp 2015-03-27T14:46:25.667Z
vip_member_price 6.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376922332
barcode_type UPC
col1 burnt umber
col1_sortorder 886
col2 4 oz.
col2_sortorder 1804
col3 tube
col3_sortorder 684
color_swatch 68-39-15.jpg
cost 3.28
deal_of_the_week NO
description burnt umber, 4 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 51278
list_price 7.69
map NO
mfr_num 1046128
net_weight 0.4
non_member_discount 43
non_member_price 4.38
prop65 NO
ship_rule_desc STD
shipping STD
sku 51278
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.85
ta_dealer_c_price 3.61
ta_price 5.38
text
array
1 51278
2 1046128
3 burnt umber, 4 oz., tube
timestamp 2015-03-27T14:47:25.42Z
vip_member_price 3.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376942323
barcode_type UPC
col1 burnt umber
col1_sortorder 886
col2 32 oz.
col2_sortorder 1660
col3 jar
col3_sortorder 346
color_swatch 68-39-15.jpg
cost 14.81
deal_of_the_week NO
description burnt umber, 32 oz., jar
group_id 550
group_uname liquitex-basics-acrylics-colors
id 61611
list_price 34.69
map NO
mfr_num 4332128
net_weight 2.58
non_member_discount 43
non_member_price 19.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 61611
sku_pix YES
supplier_id 1
ta_dealer_a_price 17.35
ta_dealer_c_price 16.3
ta_price 24.28
text
array
1 61611
2 4332128
3 burnt umber, 32 oz., jar
timestamp 2015-03-27T14:47:41.063Z
vip_member_price 17.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376923575
barcode_type UPC
col1 burnt umber
col1_sortorder 886
col2 8 oz.
col2_sortorder 2317
col3 jar
col3_sortorder 346
color_swatch 68-39-15.jpg
cost 5.08
deal_of_the_week NO
description burnt umber, 8 oz., jar
group_id 550
group_uname liquitex-basics-acrylics-colors
id 89656
list_price 11.89
map NO
mfr_num 4608128
net_weight 0.65
non_member_discount 43
non_member_price 6.78
prop65 NO
ship_rule_desc STD
shipping STD
sku 89656
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.95
ta_dealer_c_price 5.59
ta_price 8.32
text
array
1 89656
2 4608128
3 burnt umber, 8 oz., jar
timestamp 2015-03-27T14:48:24.481Z
vip_member_price 6.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376974928
barcode_type UPC
col1 cadmium orange hue
col1_sortorder 947
col2 8.5 oz.
col2_sortorder 2340
col3 tube
col3_sortorder 684
color_swatch 251-86-0.jpg
cost 5.08
deal_of_the_week NO
description cadmium orange hue, 8.5 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 10538
list_price 11.89
map NO
mfr_num 4385720
net_weight 0.85
non_member_discount 43
non_member_price 6.78
prop65 NO
ship_rule_desc STD
shipping STD
sku 10538
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.95
ta_dealer_c_price 5.59
ta_price 8.32
text
array
1 10538
2 4385720
3 cadmium orange hue, 8.5 oz., tube
timestamp 2015-03-27T14:46:24.489Z
vip_member_price 6.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376945621
barcode_type UPC
col1 cadmium orange hue
col1_sortorder 947
col2 32 oz.
col2_sortorder 1660
col3 jar
col3_sortorder 346
color_swatch 251-86-0.jpg
cost 14.81
deal_of_the_week NO
description cadmium orange hue, 32 oz., jar
group_id 550
group_uname liquitex-basics-acrylics-colors
id 79548
list_price 34.69
map NO
mfr_num 4332720
net_weight 2.55
non_member_discount 43
non_member_price 19.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 79548
sku_pix YES
supplier_id 1
ta_dealer_a_price 17.35
ta_dealer_c_price 16.3
ta_price 24.28
text
array
1 79548
2 4332720
3 cadmium orange hue, 32 oz., jar
timestamp 2015-03-27T14:48:09.318Z
vip_member_price 17.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376922561
barcode_type UPC
col1 cadmium orange hue
col1_sortorder 947
col2 4 oz.
col2_sortorder 1804
col3 tube
col3_sortorder 684
color_swatch 251-86-0.jpg
cost 3.28
deal_of_the_week NO
description cadmium orange hue, 4 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 87432
list_price 7.69
map NO
mfr_num 1046720
net_weight 0.4
non_member_discount 43
non_member_price 4.38
prop65 NO
ship_rule_desc STD
shipping STD
sku 87432
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.85
ta_dealer_c_price 3.61
ta_price 5.38
text
array
1 87432
2 1046720
3 cadmium orange hue, 4 oz., tube
timestamp 2015-03-27T14:48:19.364Z
vip_member_price 3.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376974805
barcode_type UPC
col1 cadmium red deep hue
col1_sortorder 961
col2 8.5 oz.
col2_sortorder 2340
col3 tube
col3_sortorder 684
color_swatch 180-24-10.jpg
cost 5.08
deal_of_the_week NO
description cadmium red deep hue, 8.5 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 15343
list_price 11.89
map NO
mfr_num 4385311
net_weight 0.85
non_member_discount 43
non_member_price 6.78
prop65 NO
ship_rule_desc STD
shipping STD
sku 15343
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.95
ta_dealer_c_price 5.59
ta_price 8.32
text
array
1 15343
2 4385311
3 cadmium red deep hue, 8.5 oz., tube
timestamp 2015-03-27T14:46:34.275Z
vip_member_price 6.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376945614
barcode_type UPC
col1 cadmium red deep hue
col1_sortorder 961
col2 32 oz.
col2_sortorder 1660
col3 jar
col3_sortorder 346
color_swatch 180-24-10.jpg
cost 14.81
deal_of_the_week NO
description cadmium red deep hue, 32 oz., jar
group_id 550
group_uname liquitex-basics-acrylics-colors
id 40195
list_price 34.69
map NO
mfr_num 4332311
net_weight 2.58
non_member_discount 43
non_member_price 19.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 40195
sku_pix YES
supplier_id 1
ta_dealer_a_price 17.35
ta_dealer_c_price 16.3
ta_price 24.28
text
array
1 40195
2 4332311
3 cadmium red deep hue, 32 oz., jar
timestamp 2015-03-27T14:47:12.457Z
vip_member_price 17.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376922424
barcode_type UPC
col1 cadmium red deep hue
col1_sortorder 961
col2 4 oz.
col2_sortorder 1804
col3 tube
col3_sortorder 684
color_swatch 180-24-10.jpg
cost 3.28
deal_of_the_week NO
description cadmium red deep hue, 4 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 83181
list_price 7.69
map NO
mfr_num 1046311
net_weight 0.4
non_member_discount 43
non_member_price 4.38
prop65 NO
ship_rule_desc STD
shipping STD
sku 83181
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.85
ta_dealer_c_price 3.61
ta_price 5.38
text
array
1 83181
2 1046311
3 cadmium red deep hue, 4 oz., tube
timestamp 2015-03-27T14:48:13.596Z
vip_member_price 3.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376974898
barcode_type UPC
col1 cadmium red light hue
col1_sortorder 973
col2 8.5 oz.
col2_sortorder 2340
col3 tube
col3_sortorder 684
color_swatch 237-63-0.jpg
cost 5.08
deal_of_the_week NO
description cadmium red light hue, 8.5 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 10393
list_price 11.89
map NO
mfr_num 4385510
net_weight 0.85
non_member_discount 43
non_member_price 6.78
prop65 NO
ship_rule_desc STD
shipping STD
sku 10393
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.95
ta_dealer_c_price 5.59
ta_price 8.32
text
array
1 10393
2 4385510
3 cadmium red light hue, 8.5 oz., tube
timestamp 2015-03-27T14:46:24.392Z
vip_member_price 6.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376922530
barcode_type UPC
col1 cadmium red light hue
col1_sortorder 973
col2 4 oz.
col2_sortorder 1804
col3 tube
col3_sortorder 684
color_swatch 237-63-0.jpg
cost 3.28
deal_of_the_week NO
description cadmium red light hue, 4 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 57353
list_price 7.69
map NO
mfr_num 1046510
net_weight 0.4
non_member_discount 43
non_member_price 4.38
prop65 NO
ship_rule_desc STD
shipping STD
sku 57353
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.85
ta_dealer_c_price 3.61
ta_price 5.38
text
array
1 57353
2 1046510
3 cadmium red light hue, 4 oz., tube
timestamp 2015-03-27T14:47:32.383Z
vip_member_price 3.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376974737
barcode_type UPC
col1 cadmium red medium hue
col1_sortorder 981
col2 8.5 oz.
col2_sortorder 2340
col3 tube
col3_sortorder 684
color_swatch 212-0-0.jpg
cost 5.08
deal_of_the_week NO
description cadmium red medium hue, 8.5 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 11163
list_price 11.89
map NO
mfr_num 4385151
net_weight 0.85
non_member_discount 43
non_member_price 6.78
prop65 NO
ship_rule_desc STD
shipping STD
sku 11163
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.95
ta_dealer_c_price 5.59
ta_price 8.32
text
array
1 11163
2 4385151
3 cadmium red medium hue, 8.5 oz., tube
timestamp 2015-03-27T14:46:25.217Z
vip_member_price 6.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376922349
barcode_type UPC
col1 cadmium red medium hue
col1_sortorder 981
col2 4 oz.
col2_sortorder 1804
col3 tube
col3_sortorder 684
color_swatch 212-0-0.jpg
cost 3.28
deal_of_the_week NO
description cadmium red medium hue, 4 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 52742
list_price 7.69
map NO
mfr_num 1046151
net_weight 0.4
non_member_discount 43
non_member_price 4.38
prop65 NO
ship_rule_desc STD
shipping STD
sku 52742
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.85
ta_dealer_c_price 3.61
ta_price 5.38
text
array
1 52742
2 1046151
3 cadmium red medium hue, 4 oz., tube
timestamp 2015-03-27T14:47:28.087Z
vip_member_price 3.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376942392
barcode_type UPC
col1 cadmium red medium hue
col1_sortorder 981
col2 32 oz.
col2_sortorder 1660
col3 jar
col3_sortorder 346
color_swatch 212-0-0.jpg
cost 14.81
deal_of_the_week NO
description cadmium red medium hue, 32 oz., jar
group_id 550
group_uname liquitex-basics-acrylics-colors
id 82179
list_price 34.69
map NO
mfr_num 4332151
net_weight 2.56
non_member_discount 43
non_member_price 19.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 82179
sku_pix YES
supplier_id 1
ta_dealer_a_price 17.35
ta_dealer_c_price 16.3
ta_price 24.28
text
array
1 82179
2 4332151
3 cadmium red medium hue, 32 oz., jar
timestamp 2015-03-27T14:48:12.884Z
vip_member_price 17.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376974744
barcode_type UPC
col1 cadmium yellow deep hue
col1_sortorder 1003
col2 8.5 oz.
col2_sortorder 2340
col3 tube
col3_sortorder 684
color_swatch 249-199-34.jpg
cost 5.08
deal_of_the_week NO
description cadmium yellow deep hue, 8.5 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 35282
list_price 11.89
map NO
mfr_num 4385163
net_weight 0.85
non_member_discount 43
non_member_price 6.78
prop65 NO
ship_rule_desc STD
shipping STD
sku 35282
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.95
ta_dealer_c_price 5.59
ta_price 8.32
text
array
1 35282
2 4385163
3 cadmium yellow deep hue, 8.5 oz., tube
timestamp 2015-03-27T14:47:05.985Z
vip_member_price 6.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376932942
barcode_type UPC
col1 cadmium yellow deep hue
col1_sortorder 1003
col2 4 oz.
col2_sortorder 1804
col3 tube
col3_sortorder 684
color_swatch 249-199-34.jpg
cost 3.28
deal_of_the_week NO
description cadmium yellow deep hue, 4 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 61677
list_price 7.69
map NO
mfr_num 1046163
net_weight 0.4
non_member_discount 43
non_member_price 4.38
prop65 NO
ship_rule_desc STD
shipping STD
sku 61677
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.85
ta_dealer_c_price 3.61
ta_price 5.38
text
array
1 61677
2 1046163
3 cadmium yellow deep hue, 4 oz., tube
timestamp 2015-03-27T14:47:41.127Z
vip_member_price 3.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e0309fe33e3b90c3e1797a1b5878b1a1e3dd
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=sort~1~fb~barron-s~fp~13-22~c1~books-media~c2~painting~&gr=barron-s-how-to-make-silver-charms-from-metal-clay.html
urltoken CFID=30003817&CFTOKEN=94181587&jsessionid=e0309fe33e3b90c3e1797a1b5878b1a1e3dd
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 15:52:32'}
sessionid e030feed2682810bf5d3675a1869776e4e19
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~liquitex~&gr=liquitex-basics-acrylics-colors.html
urltoken CFID=30003816&CFTOKEN=94858608&jsessionid=e030feed2682810bf5d3675a1869776e4e19
validationerror [empty string]


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

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

ItemIDList: 03785
AvailQtyList: 3.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 094376974751
barcode_type UPC
col1 cadmium yellow light hue
col1_sortorder 1014
col2 8.5 oz.
col2_sortorder 2340
col3 tube
col3_sortorder 684
color_swatch 255-244-0.jpg
cost 5.08
deal_of_the_week NO
description cadmium yellow light hue, 8.5 oz., tube
group_id 550
group_uname liquitex-basics-acrylics-colors
id 20360
list_price 11.89
map NO
mfr_num 4385160
net_weight 0.85
non_member_discount 43
non_member_price 6.78
prop65 NO
ship_rule_desc STD
shipping STD
sku 20360
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.95
ta_dealer_c_price 5.59
ta_price 8.32
text
array
1 20360
2 4385160
3 cadmium yellow light hue, 8.5 oz., tube
timestamp 2015-03-27T14:46:40.545Z
vip_member_price 6.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 03785
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] = '11648' 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.161.155.142

URL: