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

Max Water Miscible Oil Colors

by Grumbacher


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351685
barcode_type UPC
col1 alizarin crimson
col1_sortorder 81
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 164-0-90.jpg
cost 6.76
deal_of_the_week NO
description alizarin crimson, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 55666
list_price 16.45
map NO
mfr_num M001
net_weight 0.16
non_member_discount 43
non_member_price 9.33
prop65 NO
ship_rule_desc STD
shipping STD
sku 55666
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.23
ta_dealer_c_price 7.73
ta_price 11.52
text
array
1 55666
2 M001
3 alizarin crimson, 1.25 oz.
timestamp 2015-03-26T14:51:31.709Z
vip_member_price 8.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351692
barcode_type UPC
col1 burnt sienna
col1_sortorder 875
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 119-60-0.jpg
cost 4.17
deal_of_the_week NO
description burnt sienna, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 72701
list_price 10.15
map NO
mfr_num M023
net_weight 0.16
non_member_discount 43
non_member_price 5.76
prop65 NO
ship_rule_desc STD
shipping STD
sku 72701
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.08
ta_dealer_c_price 4.77
ta_price 7.11
text
array
1 72701
2 M023
3 burnt sienna, 1.25 oz.
timestamp 2015-03-26T14:52:03.372Z
vip_member_price 4.97

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351708
barcode_type UPC
col1 burnt umber
col1_sortorder 886
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 74-58-0.jpg
cost 4.17
deal_of_the_week NO
description burnt umber, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 25912
list_price 10.15
map NO
mfr_num M024
net_weight 0.16
non_member_discount 43
non_member_price 5.76
prop65 NO
ship_rule_desc STD
shipping STD
sku 25912
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.08
ta_dealer_c_price 4.77
ta_price 7.11
text
array
1 25912
2 M024
3 burnt umber, 1.25 oz.
timestamp 2015-03-26T14:50:49.209Z
vip_member_price 4.97

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351722
barcode_type UPC
col1 cadmium barium red deep
col1_sortorder 916
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 164-0-90.jpg
cost 10.75
deal_of_the_week NO
description cadmium barium red deep, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 15127
list_price 26.15
map NO
mfr_num M026
net_weight 0.16
non_member_discount 43
non_member_price 14.9
prop65 YES
ship_rule_desc STD
shipping STD
sku 15127
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.08
ta_dealer_c_price 12.29
ta_price 18.31
text
array
1 15127
2 M026
3 cadmium barium red deep, 1.25 oz.
timestamp 2015-03-26T14:50:34.875Z
vip_member_price 12.81

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351753
barcode_type UPC
col1 cadmium barium vermilion
col1_sortorder 919
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 164-93-77.jpg
cost 10.75
deal_of_the_week NO
description cadmium barium vermilion, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 51093
list_price 26.15
map NO
mfr_num M030
net_weight 0.16
non_member_discount 43
non_member_price 14.9
prop65 YES
ship_rule_desc STD
shipping STD
sku 51093
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.08
ta_dealer_c_price 12.29
ta_price 18.31
text
array
1 51093
2 M030
3 cadmium barium vermilion, 1.25 oz.
timestamp 2015-03-26T14:51:24.406Z
vip_member_price 12.81

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351760
barcode_type UPC
col1 cadmium barium yellow deep
col1_sortorder 920
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 240-172-92.jpg
cost 8.94
deal_of_the_week NO
description cadmium barium yellow deep, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 54980
list_price 21.75
map NO
mfr_num M031
net_weight 0.16
non_member_discount 43
non_member_price 12.38
prop65 YES
ship_rule_desc STD
shipping STD
sku 54980
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.88
ta_dealer_c_price 10.22
ta_price 15.23
text
array
1 54980
2 M031
3 cadmium barium yellow deep, 1.25 oz.
timestamp 2015-03-26T14:51:30.625Z
vip_member_price 10.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351791
barcode_type UPC
col1 cadmium barium yellow orange
col1_sortorder 923
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 255-173-77.jpg
cost 8.94
deal_of_the_week NO
description cadmium barium yellow orange, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 35389
list_price 21.75
map NO
mfr_num M035
net_weight 0.16
non_member_discount 43
non_member_price 12.38
prop65 YES
ship_rule_desc STD
shipping STD
sku 35389
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.88
ta_dealer_c_price 10.22
ta_price 15.23
text
array
1 35389
2 M035
3 cadmium barium yellow orange, 1.25 oz.
timestamp 2015-03-26T14:51:05.028Z
vip_member_price 10.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351715
barcode_type UPC
col1 cadmium-barium orange
col1_sortorder 1035
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 210-90-0.jpg
cost 8.94
deal_of_the_week NO
description cadmium-barium orange, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 64033
list_price 21.75
map NO
mfr_num M025
net_weight 0.16
non_member_discount 43
non_member_price 12.38
prop65 YES
ship_rule_desc STD
shipping STD
sku 64033
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.88
ta_dealer_c_price 10.22
ta_price 15.23
text
array
1 64033
2 M025
3 cadmium-barium orange, 1.25 oz.
timestamp 2015-03-26T14:51:46.059Z
vip_member_price 10.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351739
barcode_type UPC
col1 cadmium-barium red light
col1_sortorder 1036
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 195-75-47.jpg
cost 10.75
deal_of_the_week NO
description cadmium-barium red light, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 88089
list_price 26.15
map NO
mfr_num M027
net_weight 0.16
non_member_discount 43
non_member_price 14.9
prop65 YES
ship_rule_desc STD
shipping STD
sku 88089
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.08
ta_dealer_c_price 12.29
ta_price 18.31
text
array
1 88089
2 M027
3 cadmium-barium red light, 1.25 oz.
timestamp 2015-03-26T14:52:19.788Z
vip_member_price 12.81

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351746
barcode_type UPC
col1 cadmium-barium red medium
col1_sortorder 1037
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 195-47-47.jpg
cost 10.75
deal_of_the_week NO
description cadmium-barium red medium, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 85213
list_price 26.15
map NO
mfr_num M029
net_weight 0.16
non_member_discount 43
non_member_price 14.9
prop65 YES
ship_rule_desc STD
shipping STD
sku 85213
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.08
ta_dealer_c_price 12.29
ta_price 18.31
text
array
1 85213
2 M029
3 cadmium-barium red medium, 1.25 oz.
timestamp 2015-03-26T14:52:17.136Z
vip_member_price 12.81

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351777
barcode_type UPC
col1 cadmium-barium yellow light
col1_sortorder 1038
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 240-213-47.jpg
cost 8.94
deal_of_the_week NO
description cadmium-barium yellow light, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 64698
list_price 21.75
map NO
mfr_num M033
net_weight 0.16
non_member_discount 43
non_member_price 12.38
prop65 YES
ship_rule_desc STD
shipping STD
sku 64698
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.88
ta_dealer_c_price 10.22
ta_price 15.23
text
array
1 64698
2 M033
3 cadmium-barium yellow light, 1.25 oz.
timestamp 2015-03-26T14:51:47.426Z
vip_member_price 10.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351784
barcode_type UPC
col1 cadmium-barium yellow medium
col1_sortorder 1039
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 240-197-92.jpg
cost 8.94
deal_of_the_week NO
description cadmium-barium yellow medium, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 19160
list_price 21.75
map NO
mfr_num M034
net_weight 0.16
non_member_discount 43
non_member_price 12.38
prop65 YES
ship_rule_desc STD
shipping STD
sku 19160
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.88
ta_dealer_c_price 10.22
ta_price 15.23
text
array
1 19160
2 M034
3 cadmium-barium yellow medium, 1.25 oz.
timestamp 2015-03-26T14:50:40.32Z
vip_member_price 10.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351807
barcode_type UPC
col1 cadmium-barium yellow pale
col1_sortorder 1040
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 240-226-47.jpg
cost 8.94
deal_of_the_week NO
description cadmium-barium yellow pale, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 65719
list_price 21.75
map NO
mfr_num M036
net_weight 0.16
non_member_discount 43
non_member_price 12.38
prop65 YES
ship_rule_desc STD
shipping STD
sku 65719
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.88
ta_dealer_c_price 10.22
ta_price 15.23
text
array
1 65719
2 M036
3 cadmium-barium yellow pale, 1.25 oz.
timestamp 2015-03-26T14:51:49.642Z
vip_member_price 10.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351814
barcode_type UPC
col1 cerulean blue
col1_sortorder 1154
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 0-120-210.jpg
cost 12.6
deal_of_the_week NO
description cerulean blue, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 25716
list_price 30.65
map NO
mfr_num M040
net_weight 0.16
non_member_discount 43
non_member_price 17.42
prop65 YES
ship_rule_desc STD
shipping STD
sku 25716
sku_pix YES
supplier_id 1
ta_dealer_a_price 15.33
ta_dealer_c_price 14.41
ta_price 21.46
text
array
1 25716
2 M040
3 cerulean blue, 1.25 oz.
timestamp 2015-03-26T14:50:49.043Z
vip_member_price 15.02

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351821
barcode_type UPC
col1 chromium oxide green opaque
col1_sortorder 1267
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 77-164-164.jpg
cost 6.76
deal_of_the_week NO
description chromium oxide green opaque, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 88376
list_price 16.45
map NO
mfr_num M048
net_weight 0.16
non_member_discount 43
non_member_price 9.33
prop65 YES
ship_rule_desc STD
shipping STD
sku 88376
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.23
ta_dealer_c_price 7.73
ta_price 11.52
text
array
1 88376
2 M048
3 chromium oxide green opaque, 1.25 oz.
timestamp 2015-03-26T14:52:20.104Z
vip_member_price 8.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351838
barcode_type UPC
col1 cobalt blue
col1_sortorder 1352
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 0-98-210.jpg
cost 10.75
deal_of_the_week NO
description cobalt blue, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 20053
list_price 26.15
map NO
mfr_num M049
net_weight 0.16
non_member_discount 43
non_member_price 14.9
prop65 NO
ship_rule_desc STD
shipping STD
sku 20053
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.08
ta_dealer_c_price 12.29
ta_price 18.31
text
array
1 20053
2 M049
3 cobalt blue, 1.25 oz.
timestamp 2015-03-26T14:50:41.488Z
vip_member_price 12.81

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351845
barcode_type UPC-RANDOM
col1 cobalt titanate blue
col1_sortorder 1385
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 47-149-149.jpg
cost 8.94
deal_of_the_week NO
description cobalt titanate blue, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 30234
list_price 21.75
map NO
mfr_num M059
net_weight 0.16
non_member_discount 43
non_member_price 12.38
prop65 YES
ship_rule_desc STD
shipping STD
sku 30234
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.88
ta_dealer_c_price 10.22
ta_price 15.23
text
array
1 30234
2 M059
3 cobalt titanate blue, 1.25 oz.
timestamp 2015-03-26T14:50:55.093Z
vip_member_price 10.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173352286
barcode_type UPC
col1 cobalt turquoise
col1_sortorder 1388
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 0-141-164.jpg
cost 8.94
deal_of_the_week NO
description cobalt turquoise, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 60748
list_price 21.75
map NO
mfr_num M309
net_weight 0.16
non_member_discount 43
non_member_price 12.38
prop65 YES
ship_rule_desc STD
shipping STD
sku 60748
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.88
ta_dealer_c_price 10.22
ta_price 15.23
text
array
1 60748
2 M309
3 cobalt turquoise, 1.25 oz.
timestamp 2015-03-26T14:51:39.404Z
vip_member_price 10.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351852
barcode_type UPC
col1 diarylide yellow
col1_sortorder 1898
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 255-173-77.jpg
cost 6.76
deal_of_the_week NO
description diarylide yellow, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 75215
list_price 16.45
map NO
mfr_num M060
net_weight 0.16
non_member_discount 43
non_member_price 9.33
prop65 YES
ship_rule_desc STD
shipping STD
sku 75215
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.23
ta_dealer_c_price 7.73
ta_price 11.52
text
array
1 75215
2 M060
3 diarylide yellow, 1.25 oz.
timestamp 2015-03-26T14:52:05.406Z
vip_member_price 8.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351869
barcode_type UPC
col1 dioxazine purple
col1_sortorder 1907
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 140-0-164.jpg
cost 6.76
deal_of_the_week NO
description dioxazine purple, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 42234
list_price 16.45
map NO
mfr_num M061
net_weight 0.16
non_member_discount 43
non_member_price 9.33
prop65 NO
ship_rule_desc STD
shipping STD
sku 42234
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.23
ta_dealer_c_price 7.73
ta_price 11.52
text
array
1 42234
2 M061
3 dioxazine purple, 1.25 oz.
timestamp 2015-03-26T14:51:11.866Z
vip_member_price 8.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351876
barcode_type UPC
col1 flesh hue
col1_sortorder 2189
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 195-148-138.jpg
cost 5.45
deal_of_the_week NO
description flesh hue, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 86136
list_price 13.25
map NO
mfr_num M071
net_weight 0.16
non_member_discount 43
non_member_price 7.55
prop65 NO
ship_rule_desc STD
shipping STD
sku 86136
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.63
ta_dealer_c_price 6.23
ta_price 9.28
text
array
1 86136
2 M071
3 flesh hue, 1.25 oz.
timestamp 2015-03-26T14:52:18.097Z
vip_member_price 6.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351883
barcode_type UPC
col1 French ultramarine blue
col1_sortorder 2327
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 0-0-210.jpg
cost 5.45
deal_of_the_week NO
description French ultramarine blue, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 29229
list_price 13.25
map NO
mfr_num M076
net_weight 0.16
non_member_discount 43
non_member_price 7.55
prop65 NO
ship_rule_desc STD
shipping STD
sku 29229
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.63
ta_dealer_c_price 6.23
ta_price 9.28
text
array
1 29229
2 M076
3 French ultramarine blue, 1.25 oz.
timestamp 2015-03-26T14:50:53.694Z
vip_member_price 6.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351890
barcode_type UPC
col1 gold ochre hue
col1_sortorder 2521
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 149-102-47.jpg
cost 4.17
deal_of_the_week NO
description gold ochre hue, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 36817
list_price 10.15
map NO
mfr_num M080
net_weight 0.16
non_member_discount 43
non_member_price 5.76
prop65 NO
ship_rule_desc STD
shipping STD
sku 36817
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.08
ta_dealer_c_price 4.77
ta_price 7.11
text
array
1 36817
2 M080
3 gold ochre hue, 1.25 oz.
timestamp 2015-03-26T14:51:06.516Z
vip_member_price 4.97

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351906
barcode_type UPC
col1 green earth hue (terre verte)
col1_sortorder 2637
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 0-74-74.jpg
cost 4.17
deal_of_the_week NO
description green earth hue (terre verte), 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 15839
list_price 10.15
map NO
mfr_num M085
net_weight 0.16
non_member_discount 43
non_member_price 5.76
prop65 YES
ship_rule_desc STD
shipping STD
sku 15839
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.08
ta_dealer_c_price 4.77
ta_price 7.11
text
array
1 15839
2 M085
3 green earth hue (terre verte), 1.25 oz.
timestamp 2015-03-26T14:50:35.68Z
vip_member_price 4.97

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351920
barcode_type UPC
col1 Grumbacher red (naphthol red)
col1_sortorder 2719
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 195-47-47.jpg
cost 6.76
deal_of_the_week NO
description Grumbacher red (naphthol red), 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 17885
list_price 16.45
map NO
mfr_num M095
net_weight 0.16
non_member_discount 43
non_member_price 9.33
prop65 NO
ship_rule_desc STD
shipping STD
sku 17885
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.23
ta_dealer_c_price 7.73
ta_price 11.52
text
array
1 17885
2 M095
3 Grumbacher red (naphthol red), 1.25 oz.
timestamp 2015-03-26T14:50:38.931Z
vip_member_price 8.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351944
barcode_type UPC
col1 Indian red
col1_sortorder 2934
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 149-92-47.jpg
cost 4.17
deal_of_the_week NO
description Indian red, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 26565
list_price 10.15
map NO
mfr_num M110
net_weight 0.16
non_member_discount 43
non_member_price 5.76
prop65 NO
ship_rule_desc STD
shipping STD
sku 26565
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.08
ta_dealer_c_price 4.77
ta_price 7.11
text
array
1 26565
2 M110
3 Indian red, 1.25 oz.
timestamp 2015-03-26T14:50:49.992Z
vip_member_price 4.97

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351951
barcode_type UPC
col1 ivory black
col1_sortorder 3120
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 0-0-0.jpg
cost 4.17
deal_of_the_week NO
description ivory black, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 14613
list_price 10.15
map NO
mfr_num M115
net_weight 0.16
non_member_discount 43
non_member_price 5.76
prop65 NO
ship_rule_desc STD
shipping STD
sku 14613
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.08
ta_dealer_c_price 4.77
ta_price 7.11
text
array
1 14613
2 M115
3 ivory black, 1.25 oz.
timestamp 2015-03-26T14:50:33.517Z
vip_member_price 4.97

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351968
barcode_type UPC
col1 lamp black
col1_sortorder 3230
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 0-0-0.jpg
cost 4.17
deal_of_the_week NO
description lamp black, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 34964
list_price 10.15
map NO
mfr_num M116
net_weight 0.16
non_member_discount 43
non_member_price 5.76
prop65 NO
ship_rule_desc STD
shipping STD
sku 34964
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.08
ta_dealer_c_price 4.77
ta_price 7.11
text
array
1 34964
2 M116
3 lamp black, 1.25 oz.
timestamp 2015-03-26T14:51:04.664Z
vip_member_price 4.97

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351975
barcode_type UPC
col1 mars black
col1_sortorder 3604
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 0-0-0.jpg
cost 5.45
deal_of_the_week NO
description mars black, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 89322
list_price 13.25
map NO
mfr_num M134
net_weight 0.16
non_member_discount 43
non_member_price 7.55
prop65 NO
ship_rule_desc STD
shipping STD
sku 89322
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.63
ta_dealer_c_price 6.23
ta_price 9.28
text
array
1 89322
2 M134
3 mars black, 1.25 oz.
timestamp 2015-03-26T14:52:20.79Z
vip_member_price 6.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351982
barcode_type UPC
col1 Naples yellow hue
col1_sortorder 3906
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 240-232-183.jpg
cost 5.45
deal_of_the_week NO
description Naples yellow hue, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 65803
list_price 13.25
map NO
mfr_num M146
net_weight 0.16
non_member_discount 43
non_member_price 7.55
prop65 YES
ship_rule_desc STD
shipping STD
sku 65803
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.63
ta_dealer_c_price 6.23
ta_price 9.28
text
array
1 65803
2 M146
3 Naples yellow hue, 1.25 oz.
timestamp 2015-03-26T14:51:49.778Z
vip_member_price 6.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173351999
barcode_type UPC
col1 nickel titanate yellow
col1_sortorder 4075
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 98-119-0.jpg
cost 8.98
deal_of_the_week NO
description nickel titanate yellow, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 49573
list_price 21.85
map NO
mfr_num M148
net_weight 0.16
non_member_discount 43
non_member_price 12.43
prop65 NO
ship_rule_desc STD
shipping STD
sku 49573
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.93
ta_dealer_c_price 10.27
ta_price 15.3
text
array
1 49573
2 M148
3 nickel titanate yellow, 1.25 oz.
timestamp 2015-03-26T14:51:22.237Z
vip_member_price 10.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 51
barcode 014173352002
barcode_type UPC
col1 payne's gray
col1_sortorder 4418
col2 1.25 oz.
col2_sortorder 530
col3 [empty string]
color_swatch 75-75-75.jpg
cost 5.45
deal_of_the_week NO
description payne's gray, 1.25 oz.
group_id 519
group_uname grumbacher-max-water-miscible-oil-colors
id 19247
list_price 13.25
map NO
mfr_num M156
net_weight 0.16
non_member_discount 43
non_member_price 7.55
prop65 NO
ship_rule_desc STD
shipping STD
sku 19247
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.63
ta_dealer_c_price 6.23
ta_price 9.28
text
array
1 19247
2 M156
3 payne's gray, 1.25 oz.
timestamp 2015-03-26T14:50:40.513Z
vip_member_price 6.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
CACHED false
EXECUTIONTIME 9
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] = '8402' 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.146.154

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 00:49:58'}
sessionid e030978e4c1d777d660571116c5e97a3c415
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~grumbacher~&gr=grumbacher-max-water-miscible-oil-colors.html
urltoken CFID=29267828&CFTOKEN=30592008&jsessionid=e030978e4c1d777d660571116c5e97a3c415
validationerror [empty string]


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

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