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

Artist's Oil Colors

by Rembrandt


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079059019
barcode_type EAN
col1 asphaltum
col1_sortorder 221
col2 40 ml
col2_sortorder 1850
col3 414
col3_sortorder 620
color_swatch 33-18-18.jpg
cost 6.43
deal_of_the_week NO
description asphaltum, 40 ml, 414
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 10889
list_price 14.05
map YES
mfr_num 100514680
net_weight 0.18
non_member_discount 25
non_member_price 10.54
prop65 NO
ship_rule_desc STD
shipping STD
sku 10889
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.03
ta_dealer_c_price 7.03
ta_price 10.54
text
array
1 10889
2 100514680
3 asphaltum, 40 ml, 414
timestamp 2015-03-30T16:19:14.223Z
vip_member_price 9.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079058593
barcode_type EAN
col1 aureolin
col1_sortorder 253
col2 40 ml
col2_sortorder 1850
col3 242
col3_sortorder 414
color_swatch 142-106-0.jpg
cost 14.98
deal_of_the_week NO
description aureolin, 40 ml, 242
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 10738
list_price 32.75
map YES
mfr_num 100514637
net_weight 0.18
non_member_discount 25
non_member_price 24.56
prop65 YES
ship_rule_desc STD
shipping STD
sku 10738
sku_pix YES
supplier_id 1
ta_dealer_a_price 16.38
ta_dealer_c_price 16.38
ta_price 24.57
text
array
1 10738
2 100514637
3 aureolin, 40 ml, 242
timestamp 2015-03-30T16:19:13.889Z
vip_member_price 21.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079059576
barcode_type EAN
col1 bronze
col1_sortorder 791
col2 40 ml
col2_sortorder 1850
col3 811
col3_sortorder 1017
color_swatch 187-110-55.jpg
cost 11.55
deal_of_the_week NO
description bronze, 40 ml, 811
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 53175
list_price 25.25
map YES
mfr_num 100514736
net_weight 0.18
non_member_discount 25
non_member_price 18.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 53175
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.63
ta_dealer_c_price 12.63
ta_price 18.94
text
array
1 53175
2 100514736
3 bronze, 40 ml, 811
timestamp 2015-03-30T16:20:45.737Z
vip_member_price 16.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079059057
barcode_type EAN
col1 brown ochre
col1_sortorder 812
col2 40 ml
col2_sortorder 1850
col3 430
col3_sortorder 629
color_swatch 140-66-33.jpg
cost 6.43
deal_of_the_week NO
description brown ochre, 40 ml, 430
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 83718
list_price 14.05
map YES
mfr_num 100514684
net_weight 0.18
non_member_discount 25
non_member_price 10.54
prop65 NO
ship_rule_desc STD
shipping STD
sku 83718
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.03
ta_dealer_c_price 7.03
ta_price 10.54
text
array
1 83718
2 100514684
3 brown ochre, 40 ml, 430
timestamp 2015-03-30T16:21:51.468Z
vip_member_price 9.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079058821
barcode_type EAN
col1 burnt carmine
col1_sortorder 864
col2 40 ml
col2_sortorder 1850
col3 323
col3_sortorder 496
color_swatch 39-0-0.jpg
cost 11.55
deal_of_the_week NO
description burnt carmine, 40 ml, 323
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 57426
list_price 25.25
map YES
mfr_num 100514660
net_weight 0.18
non_member_discount 25
non_member_price 18.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 57426
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.63
ta_dealer_c_price 12.63
ta_price 18.94
text
array
1 57426
2 100514660
3 burnt carmine, 40 ml, 323
timestamp 2015-03-30T16:20:49.775Z
vip_member_price 16.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079059002
barcode_type EAN
col1 burnt sienna
col1_sortorder 876
col2 40 ml
col2_sortorder 1850
col3 411
col3_sortorder 612
color_swatch 118-30-14.jpg
cost 6.43
deal_of_the_week NO
description burnt sienna, 40 ml, 411
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 11035
list_price 14.05
map YES
mfr_num 100514679
net_weight 0.18
non_member_discount 25
non_member_price 10.54
prop65 NO
ship_rule_desc STD
shipping STD
sku 11035
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.03
ta_dealer_c_price 7.03
ta_price 10.54
text
array
1 11035
2 100514679
3 burnt sienna, 40 ml, 411
timestamp 2015-03-30T16:19:14.367Z
vip_member_price 9.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079058982
barcode_type EAN
col1 burnt umber
col1_sortorder 887
col2 40 ml
col2_sortorder 1850
col3 409
col3_sortorder 604
color_swatch 15-13-13.jpg
cost 6.43
deal_of_the_week NO
description burnt umber, 40 ml, 409
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 21169
list_price 14.05
map YES
mfr_num 100514677
net_weight 0.18
non_member_discount 25
non_member_price 10.54
prop65 NO
ship_rule_desc STD
shipping STD
sku 21169
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.03
ta_dealer_c_price 7.03
ta_price 10.54
text
array
1 21169
2 100514677
3 burnt umber, 40 ml, 409
timestamp 2015-03-30T16:19:41.199Z
vip_member_price 9.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079058500
barcode_type EAN
col1 cadmium orange
col1_sortorder 939
col2 40 ml
col2_sortorder 1850
col3 211
col3_sortorder 356
color_swatch 255-109-0.jpg
cost 14.98
deal_of_the_week NO
description cadmium orange, 40 ml, 211
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 27364
list_price 32.75
map YES
mfr_num 100514628
net_weight 0.18
non_member_discount 25
non_member_price 24.56
prop65 YES
ship_rule_desc STD
shipping STD
sku 27364
sku_pix YES
supplier_id 1
ta_dealer_a_price 16.38
ta_dealer_c_price 16.38
ta_price 24.57
text
array
1 27364
2 100514628
3 cadmium orange, 40 ml, 211
timestamp 2015-03-30T16:19:52.164Z
vip_member_price 21.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079058753
barcode_type EAN
col1 cadmium red deep
col1_sortorder 960
col2 40 ml
col2_sortorder 1850
col3 306
col3_sortorder 474
color_swatch 214-0-37.jpg
cost 14.98
deal_of_the_week NO
description cadmium red deep, 40 ml, 306
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 30868
list_price 32.75
map YES
mfr_num 100514653
net_weight 0.18
non_member_discount 25
non_member_price 24.56
prop65 YES
ship_rule_desc STD
shipping STD
sku 30868
sku_pix YES
supplier_id 1
ta_dealer_a_price 16.38
ta_dealer_c_price 16.38
ta_price 24.57
text
array
1 30868
2 100514653
3 cadmium red deep, 40 ml, 306
timestamp 2015-03-30T16:19:59.412Z
vip_member_price 21.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079058746
barcode_type EAN
col1 cadmium red light
col1_sortorder 970
col2 40 ml
col2_sortorder 1850
col3 303
col3_sortorder 471
color_swatch 237-63-0.jpg
cost 14.98
deal_of_the_week NO
description cadmium red light, 40 ml, 303
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 67526
list_price 32.75
map YES
mfr_num 100514652
net_weight 0.18
non_member_discount 25
non_member_price 24.56
prop65 YES
ship_rule_desc STD
shipping STD
sku 67526
sku_pix YES
supplier_id 1
ta_dealer_a_price 16.38
ta_dealer_c_price 16.38
ta_price 24.57
text
array
1 67526
2 100514652
3 cadmium red light, 40 ml, 303
timestamp 2015-03-30T16:21:13.962Z
vip_member_price 21.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079058784
barcode_type EAN
col1 cadmium red medium
col1_sortorder 978
col2 40 ml
col2_sortorder 1850
col3 314
col3_sortorder 483
color_swatch 221-30-0.jpg
cost 14.98
deal_of_the_week NO
description cadmium red medium, 40 ml, 314
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 49307
list_price 32.75
map YES
mfr_num 100514656
net_weight 0.18
non_member_discount 25
non_member_price 24.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 49307
sku_pix YES
supplier_id 1
ta_dealer_a_price 16.38
ta_dealer_c_price 16.38
ta_price 24.57
text
array
1 49307
2 100514656
3 cadmium red medium, 40 ml, 314
timestamp 2015-03-30T16:20:36.785Z
vip_member_price 21.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079058760
barcode_type EAN
col1 cadmium red purple
col1_sortorder 990
col2 40 ml
col2_sortorder 1850
col3 309
col3_sortorder 477
color_swatch 173-0-18.jpg
cost 14.98
deal_of_the_week NO
description cadmium red purple, 40 ml, 309
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 24500
list_price 32.75
map YES
mfr_num 100514654
net_weight 0.18
non_member_discount 25
non_member_price 24.56
prop65 YES
ship_rule_desc STD
shipping STD
sku 24500
sku_pix YES
supplier_id 1
ta_dealer_a_price 16.38
ta_dealer_c_price 16.38
ta_price 24.57
text
array
1 24500
2 100514654
3 cadmium red purple, 40 ml, 309
timestamp 2015-03-30T16:19:46.523Z
vip_member_price 21.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079058494
barcode_type EAN
col1 cadmium yellow deep
col1_sortorder 1002
col2 40 ml
col2_sortorder 1850
col3 210
col3_sortorder 355
color_swatch 255-161-0.jpg
cost 14.98
deal_of_the_week NO
description cadmium yellow deep, 40 ml, 210
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 60535
list_price 32.75
map YES
mfr_num 100514627
net_weight 0.18
non_member_discount 25
non_member_price 24.56
prop65 YES
ship_rule_desc STD
shipping STD
sku 60535
sku_pix YES
supplier_id 1
ta_dealer_a_price 16.38
ta_dealer_c_price 16.38
ta_price 24.57
text
array
1 60535
2 100514627
3 cadmium yellow deep, 40 ml, 210
timestamp 2015-03-30T16:20:56.259Z
vip_member_price 21.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079058470
barcode_type EAN
col1 cadmium yellow lemon
col1_sortorder 1010
col2 40 ml
col2_sortorder 1850
col3 207
col3_sortorder 352
color_swatch 255-241-0.jpg
cost 14.98
deal_of_the_week NO
description cadmium yellow lemon, 40 ml, 207
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 86105
list_price 32.75
map YES
mfr_num 100514625
net_weight 0.18
non_member_discount 25
non_member_price 24.56
prop65 YES
ship_rule_desc STD
shipping STD
sku 86105
sku_pix YES
supplier_id 1
ta_dealer_a_price 16.38
ta_dealer_c_price 16.38
ta_price 24.57
text
array
1 86105
2 100514625
3 cadmium yellow lemon, 40 ml, 207
timestamp 2015-03-30T16:21:56.271Z
vip_member_price 21.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079058487
barcode_type EAN
col1 cadmium yellow light
col1_sortorder 1011
col2 40 ml
col2_sortorder 1850
col3 208
col3_sortorder 353
color_swatch 255-236-30.jpg
cost 14.98
deal_of_the_week NO
description cadmium yellow light, 40 ml, 208
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 16259
list_price 32.75
map YES
mfr_num 100514626
net_weight 0.18
non_member_discount 25
non_member_price 24.56
prop65 YES
ship_rule_desc STD
shipping STD
sku 16259
sku_pix YES
supplier_id 1
ta_dealer_a_price 16.38
ta_dealer_c_price 16.38
ta_price 24.57
text
array
1 16259
2 100514626
3 cadmium yellow light, 40 ml, 208
timestamp 2015-03-30T16:19:32.305Z
vip_member_price 21.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079058647
barcode_type EAN
col1 cadmium yellow medium
col1_sortorder 1020
col2 40 ml
col2_sortorder 1850
col3 271
col3_sortorder 443
color_swatch 255-223-28.jpg
cost 14.98
deal_of_the_week NO
description cadmium yellow medium, 40 ml, 271
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 23563
list_price 32.75
map YES
mfr_num 100514642
net_weight 0.18
non_member_discount 25
non_member_price 24.56
prop65 YES
ship_rule_desc STD
shipping STD
sku 23563
sku_pix YES
supplier_id 1
ta_dealer_a_price 16.38
ta_dealer_c_price 16.38
ta_price 24.57
text
array
1 23563
2 100514642
3 cadmium yellow medium, 40 ml, 271
timestamp 2015-03-30T16:19:45.352Z
vip_member_price 21.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079058876
barcode_type EAN
col1 caput mortuum violet
col1_sortorder 1092
col2 40 ml
col2_sortorder 1850
col3 344
col3_sortorder 534
color_swatch 95-35-47.jpg
cost 6.43
deal_of_the_week NO
description caput mortuum violet, 40 ml, 344
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 55491
list_price 14.05
map YES
mfr_num 100514665
net_weight 0.18
non_member_discount 25
non_member_price 10.54
prop65 NO
ship_rule_desc STD
shipping STD
sku 55491
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.03
ta_dealer_c_price 7.03
ta_price 10.54
text
array
1 55491
2 100514665
3 caput mortuum violet, 40 ml, 344
timestamp 2015-03-30T16:20:47.161Z
vip_member_price 9.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079058807
barcode_type EAN
col1 carmine
col1_sortorder 1111
col2 40 ml
col2_sortorder 1850
col3 318
col3_sortorder 486
color_swatch 159-12-34.jpg
cost 11.55
deal_of_the_week NO
description carmine, 40 ml, 318
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 71232
list_price 25.25
map YES
mfr_num 100514658
net_weight 0.18
non_member_discount 25
non_member_price 18.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 71232
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.63
ta_dealer_c_price 12.63
ta_price 18.94
text
array
1 71232
2 100514658
3 carmine, 40 ml, 318
timestamp 2015-03-30T16:21:28.914Z
vip_member_price 16.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079059170
barcode_type EAN
col1 cerulean blue
col1_sortorder 1155
col2 40 ml
col2_sortorder 1850
col3 534
col3_sortorder 723
color_swatch 45-126-189.jpg
cost 21.75
deal_of_the_week NO
description cerulean blue, 40 ml, 534
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 72656
list_price 47.55
map YES
mfr_num 100514696
net_weight 0.18
non_member_discount 25
non_member_price 35.66
prop65 YES
ship_rule_desc STD
shipping STD
sku 72656
sku_pix YES
supplier_id 1
ta_dealer_a_price 23.78
ta_dealer_c_price 23.78
ta_price 35.67
text
array
1 72656
2 100514696
3 cerulean blue, 40 ml, 534
timestamp 2015-03-30T16:21:35.722Z
vip_member_price 30.91

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079059422
barcode_type EAN
col1 chromium oxide green
col1_sortorder 1264
col2 40 ml
col2_sortorder 1850
col3 668
col3_sortorder 879
color_swatch 79-115-55.jpg
cost 11.55
deal_of_the_week NO
description chromium oxide green, 40 ml, 668
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 61086
list_price 25.25
map YES
mfr_num 100514721
net_weight 0.18
non_member_discount 25
non_member_price 18.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 61086
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.63
ta_dealer_c_price 12.63
ta_price 18.94
text
array
1 61086
2 100514721
3 chromium oxide green, 40 ml, 668
timestamp 2015-03-30T16:20:58.404Z
vip_member_price 16.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079059385
barcode_type EAN
col1 cinnabar green deep
col1_sortorder 1281
col2 40 ml
col2_sortorder 1850
col3 627
col3_sortorder 835
color_swatch 18-99-18.jpg
cost 8.83
deal_of_the_week NO
description cinnabar green deep, 40 ml, 627
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 20058
list_price 19.3
map YES
mfr_num 100514717
net_weight 0.18
non_member_discount 25
non_member_price 14.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 20058
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.65
ta_dealer_c_price 9.65
ta_price 14.48
text
array
1 20058
2 100514717
3 cinnabar green deep, 40 ml, 627
timestamp 2015-03-30T16:19:39.034Z
vip_member_price 12.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079059378
barcode_type EAN
col1 cinnabar green light
col1_sortorder 1283
col2 40 ml
col2_sortorder 1850
col3 626
col3_sortorder 829
color_swatch 161-175-0.jpg
cost 8.83
deal_of_the_week NO
description cinnabar green light, 40 ml, 626
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 89898
list_price 19.3
map YES
mfr_num 100514716
net_weight 0.18
non_member_discount 25
non_member_price 14.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 89898
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.65
ta_dealer_c_price 9.65
ta_price 14.48
text
array
1 89898
2 100514716
3 cinnabar green light, 40 ml, 626
timestamp 2015-03-30T16:22:02.686Z
vip_member_price 12.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079059361
barcode_type EAN
col1 cinnabar green medium
col1_sortorder 1285
col2 40 ml
col2_sortorder 1850
col3 625
col3_sortorder 828
color_swatch 99-160-0.jpg
cost 8.83
deal_of_the_week NO
description cinnabar green medium, 40 ml, 625
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 76232
list_price 19.3
map YES
mfr_num 100514715
net_weight 0.18
non_member_discount 25
non_member_price 14.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 76232
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.65
ta_dealer_c_price 9.65
ta_price 14.48
text
array
1 76232
2 100514715
3 cinnabar green medium, 40 ml, 625
timestamp 2015-03-30T16:21:41.298Z
vip_member_price 12.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079059125
barcode_type EAN
col1 cobalt blue deep
col1_sortorder 1354
col2 40 ml
col2_sortorder 1850
col3 515
col3_sortorder 704
color_swatch 5-19-151.jpg
cost 21.75
deal_of_the_week NO
description cobalt blue deep, 40 ml, 515
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 32017
list_price 47.55
map YES
mfr_num 100514691
net_weight 0.18
non_member_discount 25
non_member_price 35.66
prop65 YES
ship_rule_desc STD
shipping STD
sku 32017
sku_pix YES
supplier_id 1
ta_dealer_a_price 23.78
ta_dealer_c_price 23.78
ta_price 35.67
text
array
1 32017
2 100514691
3 cobalt blue deep, 40 ml, 515
timestamp 2015-03-30T16:20:02.038Z
vip_member_price 30.91

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079059118
barcode_type EAN
col1 cobalt blue light
col1_sortorder 1363
col2 40 ml
col2_sortorder 1850
col3 513
col3_sortorder 702
color_swatch 0-25-160.jpg
cost 21.75
deal_of_the_week NO
description cobalt blue light, 40 ml, 513
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 71770
list_price 47.55
map YES
mfr_num 100514690
net_weight 0.18
non_member_discount 25
non_member_price 35.66
prop65 YES
ship_rule_desc STD
shipping STD
sku 71770
sku_pix YES
supplier_id 1
ta_dealer_a_price 23.78
ta_dealer_c_price 23.78
ta_price 35.67
text
array
1 71770
2 100514690
3 cobalt blue light, 40 ml, 513
timestamp 2015-03-30T16:21:31.53Z
vip_member_price 30.91

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079059101
barcode_type EAN
col1 cobalt blue ultramarine
col1_sortorder 1368
col2 40 ml
col2_sortorder 1850
col3 512
col3_sortorder 701
color_swatch 0-2-145.jpg
cost 8.83
deal_of_the_week NO
description cobalt blue ultramarine, 40 ml, 512
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 18980
list_price 19.3
map YES
mfr_num 100514689
net_weight 0.18
non_member_discount 25
non_member_price 14.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 18980
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.65
ta_dealer_c_price 9.65
ta_price 14.48
text
array
1 18980
2 100514689
3 cobalt blue ultramarine, 40 ml, 512
timestamp 2015-03-30T16:19:37.496Z
vip_member_price 12.55

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079059286
barcode_type EAN
col1 cobalt green
col1_sortorder 1372
col2 40 ml
col2_sortorder 1850
col3 610
col3_sortorder 803
color_swatch 2-111-86.jpg
cost 21.75
deal_of_the_week NO
description cobalt green, 40 ml, 610
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 63703
list_price 47.55
map YES
mfr_num 100514707
net_weight 0.18
non_member_discount 25
non_member_price 35.66
prop65 YES
ship_rule_desc STD
shipping STD
sku 63703
sku_pix YES
supplier_id 1
ta_dealer_a_price 23.78
ta_dealer_c_price 23.78
ta_price 35.67
text
array
1 63703
2 100514707
3 cobalt green, 40 ml, 610
timestamp 2015-03-30T16:21:04.954Z
vip_member_price 30.91

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079059279
barcode_type EAN
col1 cobalt turquoise blue
col1_sortorder 1390
col2 40 ml
col2_sortorder 1850
col3 586
col3_sortorder 791
color_swatch 0-86-139.jpg
cost 21.75
deal_of_the_week NO
description cobalt turquoise blue, 40 ml, 586
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 71603
list_price 47.55
map YES
mfr_num 100514706
net_weight 0.18
non_member_discount 25
non_member_price 35.66
prop65 YES
ship_rule_desc STD
shipping STD
sku 71603
sku_pix YES
supplier_id 1
ta_dealer_a_price 23.78
ta_dealer_c_price 23.78
ta_price 35.67
text
array
1 71603
2 100514706
3 cobalt turquoise blue, 40 ml, 586
timestamp 2015-03-30T16:21:31.06Z
vip_member_price 30.91

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079059453
barcode_type EAN
col1 cobalt turquoise green
col1_sortorder 1391
col2 40 ml
col2_sortorder 1850
col3 682
col3_sortorder 896
color_swatch 18-113-39.jpg
cost 21.75
deal_of_the_week NO
description cobalt turquoise green, 40 ml, 682
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 73416
list_price 47.55
map YES
mfr_num 100514724
net_weight 0.18
non_member_discount 25
non_member_price 35.66
prop65 YES
ship_rule_desc STD
shipping STD
sku 73416
sku_pix YES
supplier_id 1
ta_dealer_a_price 23.78
ta_dealer_c_price 23.78
ta_price 35.67
text
array
1 73416
2 100514724
3 cobalt turquoise green, 40 ml, 682
timestamp 2015-03-30T16:21:37.121Z
vip_member_price 30.91

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079059194
barcode_type EAN
col1 cobalt violet
col1_sortorder 1396
col2 40 ml
col2_sortorder 1850
col3 539
col3_sortorder 740
color_swatch 141-45-154.jpg
cost 21.75
deal_of_the_week NO
description cobalt violet, 40 ml, 539
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 77901
list_price 47.55
map YES
mfr_num 100514698
net_weight 0.18
non_member_discount 25
non_member_price 35.66
prop65 YES
ship_rule_desc STD
shipping STD
sku 77901
sku_pix YES
supplier_id 1
ta_dealer_a_price 23.78
ta_dealer_c_price 23.78
ta_price 35.67
text
array
1 77901
2 100514698
3 cobalt violet, 40 ml, 539
timestamp 2015-03-30T16:21:43.132Z
vip_member_price 30.91

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079059507
barcode_type EAN
col1 cold gray
col1_sortorder 1428
col2 40 ml
col2_sortorder 1850
col3 717
col3_sortorder 937
color_swatch 113-113-113.jpg
cost 6.43
deal_of_the_week NO
description cold gray, 40 ml, 717
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 61233
list_price 14.05
map YES
mfr_num 100514729
net_weight 0.18
non_member_discount 25
non_member_price 10.54
prop65 NO
ship_rule_desc STD
shipping STD
sku 61233
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.03
ta_dealer_c_price 7.03
ta_price 10.54
text
array
1 61233
2 100514729
3 cold gray, 40 ml, 717
timestamp 2015-03-30T16:20:58.862Z
vip_member_price 9.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:39'}
sessionid e03063b6738660934b127b6749344d68673a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~&gr=winsor-newton-cotman-water-colour-compact-set.html
urltoken CFID=30516575&CFTOKEN=51195885&jsessionid=e03063b6738660934b127b6749344d68673a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 11:59:38'}
sessionid e030e60d4bcc6070646354253a1f69151977
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html
urltoken CFID=30516573&CFTOKEN=32301834&jsessionid=e030e60d4bcc6070646354253a1f69151977
validationerror [empty string]


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

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

ItemIDList: 57108
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 8712079059569
barcode_type EAN
col1 copper
col1_sortorder 1529
col2 40 ml
col2_sortorder 1850
col3 805
col3_sortorder 1011
color_swatch 173-86-35.jpg
cost 11.55
deal_of_the_week NO
description copper, 40 ml, 805
group_id 849
group_uname rembrandt-artist-s-oil-colors
id 57377
list_price 25.25
map YES
mfr_num 100514735
net_weight 0.18
non_member_discount 25
non_member_price 18.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 57377
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.63
ta_dealer_c_price 12.63
ta_price 18.94
text
array
1 57377
2 100514735
3 copper, 40 ml, 805
timestamp 2015-03-30T16:20:49.697Z
vip_member_price 16.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 57108
CACHED false
EXECUTIONTIME 1
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '2617' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&gr=rembrandt-artist-s-oil-colors.html

StartSessionVariables: