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

Pigment Sticks

by R & F Handmade Paints


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005402
barcode_type UPC
col1 alizarin crimson
col1_sortorder 81
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 164-0-0.jpg
cost 8.94
deal_of_the_week NO
description alizarin crimson, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 96701
list_price 17.25
map YES
mfr_num 2140
net_weight 0.1
non_member_discount 20
non_member_price 13.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 96701
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.35
ta_dealer_c_price 10.35
ta_price 15.53
text
array
1 96701
2 2140
3 alizarin crimson, 38 ml
timestamp 2015-03-30T16:22:12.463Z
vip_member_price 12.08

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005921
barcode_type UPC
col1 alizarin orange
col1_sortorder 88
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 240-141-92.jpg
cost 8.94
deal_of_the_week NO
description alizarin orange, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 98311
list_price 17.25
map YES
mfr_num 214E
net_weight 0.1
non_member_discount 20
non_member_price 13.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 98311
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.35
ta_dealer_c_price 10.35
ta_price 15.53
text
array
1 98311
2 214E
3 alizarin orange, 38 ml
timestamp 2015-03-30T16:22:15.39Z
vip_member_price 12.08

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005365
barcode_type UPC
col1 azure blue
col1_sortorder 284
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 77-120-255.jpg
cost 8.16
deal_of_the_week NO
description azure blue, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 96697
list_price 15.75
map YES
mfr_num 2136
net_weight 0.13
non_member_discount 20
non_member_price 12.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 96697
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.45
ta_dealer_c_price 9.45
ta_price 14.18
text
array
1 96697
2 2136
3 azure blue, 38 ml
timestamp 2015-03-30T16:22:12.455Z
vip_member_price 11.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005006
barcode_type UPC
col1 blender
col1_sortorder 530
col2 38 ml
col2_sortorder 1721
col3 [empty string]
cost 4.64
deal_of_the_week NO
description blender, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 96680
list_price 8.95
map YES
mfr_num 2100
net_weight 0.09
non_member_discount 20
non_member_price 7.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 96680
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.37
ta_dealer_c_price 5.37
ta_price 8.07
text
array
1 96680
2 2100
3 blender, 38 ml
timestamp 2015-03-30T16:22:12.419Z
vip_member_price 6.27

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943006003
barcode_type UPC
col1 blender
col1_sortorder 530
col2 188 ml
col2_sortorder 1096
col3 [empty string]
cost 15.3
deal_of_the_week NO
description blender, 188 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 98323
list_price 29.5
map YES
mfr_num 2200
net_weight 0.55
non_member_discount 20
non_member_price 23.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 98323
sku_pix YES
supplier_id 1
ta_dealer_a_price 17.7
ta_dealer_c_price 17.7
ta_price 26.56
text
array
1 98323
2 2200
3 blender, 188 ml
timestamp 2015-03-30T16:22:15.429Z
vip_member_price 20.65

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005044
barcode_type UPC
col1 brilliant yellow extra pale
col1_sortorder 774
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 255-237-168.jpg
cost 7.23
deal_of_the_week NO
description brilliant yellow extra pale, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 96694
list_price 13.95
map YES
mfr_num 212D
net_weight 0.13
non_member_discount 20
non_member_price 11.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 96694
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.37
ta_dealer_c_price 8.37
ta_price 12.56
text
array
1 96694
2 212D
3 brilliant yellow extra pale, 38 ml
timestamp 2015-03-30T16:22:12.448Z
vip_member_price 9.77

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943006041
barcode_type UPC
col1 brilliant yellow extra pale
col1_sortorder 774
col2 188 ml
col2_sortorder 1096
col3 [empty string]
color_swatch 255-237-168.jpg
cost 24.63
deal_of_the_week NO
description brilliant yellow extra pale, 188 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 98327
list_price 47.5
map YES
mfr_num 222D
net_weight 0.56
non_member_discount 20
non_member_price 38
prop65 NO
ship_rule_desc STD
shipping STD
sku 98327
sku_pix YES
supplier_id 1
ta_dealer_a_price 28.5
ta_dealer_c_price 28.5
ta_price 42.75
text
array
1 98327
2 222D
3 brilliant yellow extra pale, 188 ml
timestamp 2015-03-30T16:22:15.456Z
vip_member_price 33.25

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005143
barcode_type UPC
col1 burnt sienna
col1_sortorder 876
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 119-70-0.jpg
cost 6.48
deal_of_the_week NO
description burnt sienna, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 96685
list_price 12.5
map YES
mfr_num 2114
net_weight 0.12
non_member_discount 20
non_member_price 10
prop65 NO
ship_rule_desc STD
shipping STD
sku 96685
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.5
ta_dealer_c_price 7.5
ta_price 11.26
text
array
1 96685
2 2114
3 burnt sienna, 38 ml
timestamp 2015-03-30T16:22:12.429Z
vip_member_price 8.75

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005167
barcode_type UPC
col1 burnt umber
col1_sortorder 887
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 104-47-60.jpg
cost 6.48
deal_of_the_week NO
description burnt umber, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 96687
list_price 12.5
map YES
mfr_num 2116
net_weight 0.12
non_member_discount 20
non_member_price 10
prop65 NO
ship_rule_desc STD
shipping STD
sku 96687
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.5
ta_dealer_c_price 7.5
ta_price 11.26
text
array
1 96687
2 2116
3 burnt umber, 38 ml
timestamp 2015-03-30T16:22:12.433Z
vip_member_price 8.75

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005563
barcode_type UPC
col1 cadmium green
col1_sortorder 928
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 92-195-92.jpg
cost 11.02
deal_of_the_week NO
description cadmium green, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 98315
list_price 21.25
map YES
mfr_num 2156
net_weight 0.1
non_member_discount 20
non_member_price 17
prop65 YES
ship_rule_desc STD
shipping STD
sku 98315
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.75
ta_dealer_c_price 12.75
ta_price 19.14
text
array
1 98315
2 2156
3 cadmium green, 38 ml
timestamp 2015-03-30T16:22:15.403Z
vip_member_price 14.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005556
barcode_type UPC
col1 cadmium green pale
col1_sortorder 934
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 210-210-0.jpg
cost 11.02
deal_of_the_week NO
description cadmium green pale, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 96711
list_price 21.25
map YES
mfr_num 2155
net_weight 0.1
non_member_discount 20
non_member_price 17
prop65 YES
ship_rule_desc STD
shipping STD
sku 96711
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.75
ta_dealer_c_price 12.75
ta_price 19.14
text
array
1 96711
2 2155
3 cadmium green pale, 38 ml
timestamp 2015-03-30T16:22:12.485Z
vip_member_price 14.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005549
barcode_type UPC
col1 cadmium orange
col1_sortorder 939
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 240-132-47.jpg
cost 11.02
deal_of_the_week NO
description cadmium orange, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 98313
list_price 21.25
map YES
mfr_num 2154
net_weight 0.13
non_member_discount 20
non_member_price 17
prop65 YES
ship_rule_desc STD
shipping STD
sku 98313
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.75
ta_dealer_c_price 12.75
ta_price 19.14
text
array
1 98313
2 2154
3 cadmium orange, 38 ml
timestamp 2015-03-30T16:22:15.396Z
vip_member_price 14.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005624
barcode_type UPC
col1 cadmium red deep
col1_sortorder 960
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 195-47-47.jpg
cost 12.42
deal_of_the_week NO
description cadmium red deep, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 98314
list_price 23.95
map YES
mfr_num 2162
net_weight 0.12
non_member_discount 20
non_member_price 19.16
prop65 YES
ship_rule_desc STD
shipping STD
sku 98314
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.37
ta_dealer_c_price 14.37
ta_price 21.56
text
array
1 98314
2 2162
3 cadmium red deep, 38 ml
timestamp 2015-03-30T16:22:15.397Z
vip_member_price 16.77

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005600
barcode_type UPC
col1 cadmium red light
col1_sortorder 970
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 240-110-47.jpg
cost 12.42
deal_of_the_week NO
description cadmium red light, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 96713
list_price 23.95
map YES
mfr_num 2160
net_weight 0.12
non_member_discount 20
non_member_price 19.16
prop65 YES
ship_rule_desc STD
shipping STD
sku 96713
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.37
ta_dealer_c_price 14.37
ta_price 21.56
text
array
1 96713
2 2160
3 cadmium red light, 38 ml
timestamp 2015-03-30T16:22:12.49Z
vip_member_price 16.77

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005617
barcode_type UPC
col1 cadmium red medium
col1_sortorder 978
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 240-83-47.jpg
cost 12.42
deal_of_the_week NO
description cadmium red medium, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 96714
list_price 23.95
map YES
mfr_num 2161
net_weight 0.13
non_member_discount 20
non_member_price 19.16
prop65 YES
ship_rule_desc STD
shipping STD
sku 96714
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.37
ta_dealer_c_price 14.37
ta_price 21.56
text
array
1 96714
2 2161
3 cadmium red medium, 38 ml
timestamp 2015-03-30T16:22:12.491Z
vip_member_price 16.77

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005532
barcode_type UPC
col1 cadmium yellow deep
col1_sortorder 1002
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 240-219-92.jpg
cost 11.02
deal_of_the_week NO
description cadmium yellow deep, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 98312
list_price 21.25
map YES
mfr_num 2153
net_weight 0.13
non_member_discount 20
non_member_price 17
prop65 YES
ship_rule_desc STD
shipping STD
sku 98312
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.75
ta_dealer_c_price 12.75
ta_price 19.14
text
array
1 98312
2 2153
3 cadmium yellow deep, 38 ml
timestamp 2015-03-30T16:22:15.393Z
vip_member_price 14.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005518
barcode_type UPC
col1 cadmium yellow light
col1_sortorder 1011
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 240-240-47.jpg
cost 11.02
deal_of_the_week NO
description cadmium yellow light, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 96709
list_price 21.25
map YES
mfr_num 2151
net_weight 0.13
non_member_discount 20
non_member_price 17
prop65 YES
ship_rule_desc STD
shipping STD
sku 96709
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.75
ta_dealer_c_price 12.75
ta_price 19.14
text
array
1 96709
2 2151
3 cadmium yellow light, 38 ml
timestamp 2015-03-30T16:22:12.481Z
vip_member_price 14.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005525
barcode_type UPC
col1 cadmium yellow medium
col1_sortorder 1020
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 240-226-47.jpg
cost 11.02
deal_of_the_week NO
description cadmium yellow medium, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 96710
list_price 21.25
map YES
mfr_num 2152
net_weight 0.13
non_member_discount 20
non_member_price 17
prop65 YES
ship_rule_desc STD
shipping STD
sku 96710
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.75
ta_dealer_c_price 12.75
ta_price 19.14
text
array
1 96710
2 2152
3 cadmium yellow medium, 38 ml
timestamp 2015-03-30T16:22:12.483Z
vip_member_price 14.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005945
barcode_type UPC
col1 celadon green
col1_sortorder 1143
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 171-195-138.jpg
cost 8.16
deal_of_the_week NO
description celadon green, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 96700
list_price 15.75
map YES
mfr_num 213C
net_weight 0.13
non_member_discount 20
non_member_price 12.6
prop65 YES
ship_rule_desc STD
shipping STD
sku 96700
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.45
ta_dealer_c_price 9.45
ta_price 14.18
text
array
1 96700
2 213C
3 celadon green, 38 ml
timestamp 2015-03-30T16:22:12.461Z
vip_member_price 11.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005464
barcode_type UPC
col1 cerulean extra pale
col1_sortorder 1169
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 213-229-255.jpg
cost 8.94
deal_of_the_week NO
description cerulean extra pale, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 96704
list_price 17.25
map YES
mfr_num 2146
net_weight 0.12
non_member_discount 20
non_member_price 13.8
prop65 YES
ship_rule_desc STD
shipping STD
sku 96704
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.35
ta_dealer_c_price 10.35
ta_price 15.53
text
array
1 96704
2 2146
3 cerulean extra pale, 38 ml
timestamp 2015-03-30T16:22:12.471Z
vip_member_price 12.08

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005631
barcode_type UPC
col1 cobalt blue
col1_sortorder 1353
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 91-47-240.jpg
cost 12.42
deal_of_the_week NO
description cobalt blue, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 96715
list_price 23.95
map YES
mfr_num 2163
net_weight 0.11
non_member_discount 20
non_member_price 19.16
prop65 YES
ship_rule_desc STD
shipping STD
sku 96715
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.37
ta_dealer_c_price 14.37
ta_price 21.56
text
array
1 96715
2 2163
3 cobalt blue, 38 ml
timestamp 2015-03-30T16:22:12.493Z
vip_member_price 16.77

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005761
barcode_type UPC
col1 dianthus pink
col1_sortorder 1899
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 240-138-182.jpg
cost 8.16
deal_of_the_week NO
description dianthus pink, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 96699
list_price 15.75
map YES
mfr_num 213B
net_weight 0.12
non_member_discount 20
non_member_price 12.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 96699
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.45
ta_dealer_c_price 9.45
ta_price 14.18
text
array
1 96699
2 213B
3 dianthus pink, 38 ml
timestamp 2015-03-30T16:22:12.459Z
vip_member_price 11.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005938
barcode_type UPC
col1 Egyptian violet
col1_sortorder 2015
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 88-47-104.jpg
cost 11.02
deal_of_the_week NO
description Egyptian violet, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 98316
list_price 21.25
map YES
mfr_num 215B
net_weight 0.09
non_member_discount 20
non_member_price 17
prop65 NO
ship_rule_desc STD
shipping STD
sku 98316
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.75
ta_dealer_c_price 12.75
ta_price 19.14
text
array
1 98316
2 215B
3 Egyptian violet, 38 ml
timestamp 2015-03-30T16:22:15.408Z
vip_member_price 14.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005907
barcode_type UPC
col1 green gold
col1_sortorder 2650
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 149-149-47.jpg
cost 11.02
deal_of_the_week NO
description green gold, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 96712
list_price 21.25
map YES
mfr_num 215A
net_weight 0.12
non_member_discount 20
non_member_price 17
prop65 NO
ship_rule_desc STD
shipping STD
sku 96712
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.75
ta_dealer_c_price 12.75
ta_price 19.14
text
array
1 96712
2 215A
3 green gold, 38 ml
timestamp 2015-03-30T16:22:12.487Z
vip_member_price 14.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005914
barcode_type UPC
col1 Indian yellow
col1_sortorder 2943
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 240-184-47.jpg
cost 8.94
deal_of_the_week NO
description Indian yellow, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 98317
list_price 17.25
map YES
mfr_num 214D
net_weight 0.09
non_member_discount 20
non_member_price 13.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 98317
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.35
ta_dealer_c_price 10.35
ta_price 15.53
text
array
1 98317
2 214D
3 Indian yellow, 38 ml
timestamp 2015-03-30T16:22:15.41Z
vip_member_price 12.08

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005853
barcode_type UPC
col1 iridescent gold
col1_sortorder 3033
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 210-158-0.jpg
cost 11.02
deal_of_the_week NO
description iridescent gold, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 96717
list_price 21.25
map YES
mfr_num 2185
net_weight 0.12
non_member_discount 20
non_member_price 17
prop65 NO
ship_rule_desc STD
shipping STD
sku 96717
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.75
ta_dealer_c_price 12.75
ta_price 19.14
text
array
1 96717
2 2185
3 iridescent gold, 38 ml
timestamp 2015-03-30T16:22:12.497Z
vip_member_price 14.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005808
barcode_type UPC
col1 iridescent pearl
col1_sortorder 3051
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 225-225-225.jpg
cost 11.02
deal_of_the_week NO
description iridescent pearl, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 97234
list_price 21.25
map YES
mfr_num 2180
net_weight 0.11
non_member_discount 20
non_member_price 17
prop65 NO
ship_rule_desc STD
shipping STD
sku 97234
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.75
ta_dealer_c_price 12.75
ta_price 19.14
text
array
1 97234
2 2180
3 iridescent pearl, 38 ml
timestamp 2015-03-30T16:22:13.499Z
vip_member_price 14.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005815
barcode_type UPC
col1 iridescent silver
col1_sortorder 3072
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 210-210-210.jpg
cost 11.02
deal_of_the_week NO
description iridescent silver, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 96716
list_price 21.25
map YES
mfr_num 2181
net_weight 0.11
non_member_discount 20
non_member_price 17
prop65 NO
ship_rule_desc STD
shipping STD
sku 96716
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.75
ta_dealer_c_price 12.75
ta_price 19.14
text
array
1 96716
2 2181
3 iridescent silver, 38 ml
timestamp 2015-03-30T16:22:12.495Z
vip_member_price 14.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005129
barcode_type UPC
col1 ivory black
col1_sortorder 3126
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 0-0-0.jpg
cost 6.48
deal_of_the_week NO
description ivory black, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 96683
list_price 12.5
map YES
mfr_num 2112
net_weight 0.12
non_member_discount 20
non_member_price 10
prop65 NO
ship_rule_desc STD
shipping STD
sku 96683
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.5
ta_dealer_c_price 7.5
ta_price 11.26
text
array
1 96683
2 2112
3 ivory black, 38 ml
timestamp 2015-03-30T16:22:12.425Z
vip_member_price 8.75

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943006126
barcode_type UPC
col1 ivory black
col1_sortorder 3126
col2 188 ml
col2_sortorder 1096
col3 [empty string]
color_swatch 0-0-0.jpg
cost 22.03
deal_of_the_week NO
description ivory black, 188 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 98325
list_price 42.5
map YES
mfr_num 2212
net_weight 0.55
non_member_discount 20
non_member_price 34
prop65 NO
ship_rule_desc STD
shipping STD
sku 98325
sku_pix YES
supplier_id 1
ta_dealer_a_price 25.5
ta_dealer_c_price 25.5
ta_price 38.25
text
array
1 98325
2 2212
3 ivory black, 188 ml
timestamp 2015-03-30T16:22:15.441Z
vip_member_price 29.75

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005754
barcode_type UPC
col1 jaune brilliant
col1_sortorder 3146
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 240-172-92.jpg
cost 8.16
deal_of_the_week NO
description jaune brilliant, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 98318
list_price 15.75
map YES
mfr_num 213A
net_weight 0.13
non_member_discount 20
non_member_price 12.6
prop65 YES
ship_rule_desc STD
shipping STD
sku 98318
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.45
ta_dealer_c_price 9.45
ta_price 14.18
text
array
1 98318
2 213A
3 jaune brilliant, 38 ml
timestamp 2015-03-30T16:22:15.411Z
vip_member_price 11.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


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

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

ItemIDList: 94563
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 836943005488
barcode_type UPC
col1 king's blue
col1_sortorder 3211
col2 38 ml
col2_sortorder 1721
col3 [empty string]
color_swatch 77-143-210.jpg
cost 8.94
deal_of_the_week NO
description king's blue, 38 ml
group_id 10020
group_uname r-f-handmade-paints-pigment-sticks
id 96705
list_price 17.25
map YES
mfr_num 2148
net_weight 0.13
non_member_discount 20
non_member_price 13.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 96705
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.35
ta_dealer_c_price 10.35
ta_price 15.53
text
array
1 96705
2 2148
3 king's blue, 38 ml
timestamp 2015-03-30T16:22:12.473Z
vip_member_price 12.08

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 94563
CACHED false
EXECUTIONTIME 17
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] = '13868' 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.163.190.170

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 10:50:50'}
sessionid e030e33228edc28a96f52a562a1a5f261c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fb~r-f-handmade-paints~fp~5-8~&gr=r-f-handmade-paints-pigment-sticks.html
urltoken CFID=30503516&CFTOKEN=86530164&jsessionid=e030e33228edc28a96f52a562a1a5f261c1b
validationerror [empty string]


EndSessionVariables: