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

Oil Color

by Van Gogh


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219291
barcode_type EAN
col1 azo orange
col1_sortorder 270
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 210-90-0.jpg
cost 2.92
deal_of_the_week NO
description azo orange, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 27985
list_price 7.35
map NO
mfr_num 100514794
net_weight 0.18
non_member_discount 32
non_member_price 4.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 27985
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.31
ta_price 5.15
text
array
1 27985
2 100514794
3 azo orange, 40 ml (1.35 oz)
timestamp 2015-03-30T16:19:52.922Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219352
barcode_type EAN
col1 azo red deep
col1_sortorder 272
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 164-0-62.jpg
cost 2.92
deal_of_the_week NO
description azo red deep, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 66644
list_price 7.35
map NO
mfr_num 100514799
net_weight 0.18
non_member_discount 32
non_member_price 4.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 66644
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.31
ta_price 5.15
text
array
1 66644
2 100514799
3 azo red deep, 40 ml (1.35 oz)
timestamp 2015-03-30T16:21:11.444Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219345
barcode_type EAN
col1 azo red light
col1_sortorder 273
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 195-75-47.jpg
cost 2.92
deal_of_the_week NO
description azo red light, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 57952
list_price 7.35
map NO
mfr_num 100514798
net_weight 0.18
non_member_discount 32
non_member_price 4.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 57952
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.31
ta_price 5.15
text
array
1 57952
2 100514798
3 azo red light, 40 ml (1.35 oz)
timestamp 2015-03-30T16:20:50.119Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219451
barcode_type EAN
col1 azo red medium
col1_sortorder 274
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 195-47-47.jpg
cost 2.92
deal_of_the_week NO
description azo red medium, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 30300
list_price 7.35
map NO
mfr_num 100514810
net_weight 0.18
non_member_discount 32
non_member_price 4.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 30300
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.31
ta_price 5.15
text
array
1 30300
2 100514810
3 azo red medium, 40 ml (1.35 oz)
timestamp 2015-03-30T16:19:57.801Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219284
barcode_type EAN
col1 azo yellow deep
col1_sortorder 276
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 240-172-92.jpg
cost 2.92
deal_of_the_week NO
description azo yellow deep, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 36119
list_price 7.35
map NO
mfr_num 100514792
net_weight 0.18
non_member_discount 32
non_member_price 4.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 36119
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.31
ta_price 5.15
text
array
1 36119
2 100514792
3 azo yellow deep, 40 ml (1.35 oz)
timestamp 2015-03-30T16:20:16.039Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219253
barcode_type EAN
col1 azo yellow lemon
col1_sortorder 277
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 240-229-92.jpg
cost 2.92
deal_of_the_week NO
description azo yellow lemon, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 18807
list_price 7.35
map NO
mfr_num 100514789
net_weight 0.18
non_member_discount 32
non_member_price 4.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 18807
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.31
ta_price 5.15
text
array
1 18807
2 100514789
3 azo yellow lemon, 40 ml (1.35 oz)
timestamp 2015-03-30T16:19:37.084Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219260
barcode_type EAN
col1 azo yellow light
col1_sortorder 278
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 240-213-47.jpg
cost 2.92
deal_of_the_week NO
description azo yellow light, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 24614
list_price 7.35
map NO
mfr_num 100514790
net_weight 0.18
non_member_discount 32
non_member_price 4.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 24614
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.31
ta_price 5.15
text
array
1 24614
2 100514790
3 azo yellow light, 40 ml (1.35 oz)
timestamp 2015-03-30T16:19:46.663Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219277
barcode_type EAN
col1 azo yellow medium
col1_sortorder 279
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 240-199-47.jpg
cost 2.92
deal_of_the_week NO
description azo yellow medium, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 25607
list_price 7.35
map NO
mfr_num 100514791
net_weight 0.18
non_member_discount 32
non_member_price 4.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 25607
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.31
ta_price 5.15
text
array
1 25607
2 100514791
3 azo yellow medium, 40 ml (1.35 oz)
timestamp 2015-03-30T16:19:48.316Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219499
barcode_type EAN
col1 burnt sienna
col1_sortorder 876
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 119-60-0.jpg
cost 2.92
deal_of_the_week NO
description burnt sienna, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 55539
list_price 7.35
map NO
mfr_num 100514814
net_weight 0.18
non_member_discount 32
non_member_price 4.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 55539
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.31
ta_price 5.15
text
array
1 55539
2 100514814
3 burnt sienna, 40 ml (1.35 oz)
timestamp 2015-03-30T16:20:47.245Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219482
barcode_type EAN
col1 burnt umber
col1_sortorder 887
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 74-58-0.jpg
cost 2.92
deal_of_the_week NO
description burnt umber, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 80774
list_price 7.35
map NO
mfr_num 100514813
net_weight 0.18
non_member_discount 32
non_member_price 4.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 80774
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.31
ta_price 5.15
text
array
1 80774
2 100514813
3 burnt umber, 40 ml (1.35 oz)
timestamp 2015-03-30T16:21:46.617Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219178
barcode_type EAN
col1 cadmium orange
col1_sortorder 939
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 210-121-77.jpg
cost 6.15
deal_of_the_week NO
description cadmium orange, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 82333
list_price 15.5
map NO
mfr_num 100514781
net_weight 0.18
non_member_discount 32
non_member_price 10.49
prop65 YES
ship_rule_desc STD
shipping STD
sku 82333
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.75
ta_dealer_c_price 6.98
ta_price 10.85
text
array
1 82333
2 100514781
3 cadmium orange, 40 ml (1.35 oz)
timestamp 2015-03-30T16:21:49.048Z
vip_member_price 6.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219321
barcode_type EAN
col1 cadmium red deep
col1_sortorder 960
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 164-0-62.jpg
cost 6.15
deal_of_the_week NO
description cadmium red deep, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 30951
list_price 15.5
map NO
mfr_num 100514796
net_weight 0.18
non_member_discount 32
non_member_price 10.49
prop65 YES
ship_rule_desc STD
shipping STD
sku 30951
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.75
ta_dealer_c_price 6.98
ta_price 10.85
text
array
1 30951
2 100514796
3 cadmium red deep, 40 ml (1.35 oz)
timestamp 2015-03-30T16:19:59.535Z
vip_member_price 6.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219307
barcode_type EAN
col1 cadmium red light
col1_sortorder 970
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 195-75-47.jpg
cost 6.15
deal_of_the_week NO
description cadmium red light, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 64567
list_price 15.5
map NO
mfr_num 100514795
net_weight 0.18
non_member_discount 32
non_member_price 10.49
prop65 YES
ship_rule_desc STD
shipping STD
sku 64567
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.75
ta_dealer_c_price 6.98
ta_price 10.85
text
array
1 64567
2 100514795
3 cadmium red light, 40 ml (1.35 oz)
timestamp 2015-03-30T16:21:06.563Z
vip_member_price 6.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079222307
barcode_type EAN
col1 cadmium red medium
col1_sortorder 978
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 195-47-47.jpg
cost 6.15
deal_of_the_week NO
description cadmium red medium, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 20586
list_price 15.5
map NO
mfr_num 100514800
net_weight 0.18
non_member_discount 32
non_member_price 10.49
prop65 YES
ship_rule_desc STD
shipping STD
sku 20586
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.75
ta_dealer_c_price 6.98
ta_price 10.85
text
array
1 20586
2 100514800
3 cadmium red medium, 40 ml (1.35 oz)
timestamp 2015-03-30T16:19:40.041Z
vip_member_price 6.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219161
barcode_type EAN
col1 cadmium yellow deep
col1_sortorder 1002
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 240-197-92.jpg
cost 6.15
deal_of_the_week NO
description cadmium yellow deep, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 47934
list_price 15.5
map NO
mfr_num 100514780
net_weight 0.18
non_member_discount 32
non_member_price 10.49
prop65 YES
ship_rule_desc STD
shipping STD
sku 47934
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.75
ta_dealer_c_price 6.98
ta_price 10.85
text
array
1 47934
2 100514780
3 cadmium yellow deep, 40 ml (1.35 oz)
timestamp 2015-03-30T16:20:34.303Z
vip_member_price 6.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219147
barcode_type EAN
col1 cadmium yellow light
col1_sortorder 1011
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 240-213-47.jpg
cost 6.15
deal_of_the_week NO
description cadmium yellow light, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 59547
list_price 15.5
map NO
mfr_num 100514779
net_weight 0.18
non_member_discount 32
non_member_price 10.49
prop65 YES
ship_rule_desc STD
shipping STD
sku 59547
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.75
ta_dealer_c_price 6.98
ta_price 10.85
text
array
1 59547
2 100514779
3 cadmium yellow light, 40 ml (1.35 oz)
timestamp 2015-03-30T16:20:52.67Z
vip_member_price 6.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079222277
barcode_type EAN
col1 cadmium yellow medium
col1_sortorder 1020
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 240-213-47.jpg
cost 6.15
deal_of_the_week NO
description cadmium yellow medium, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 83487
list_price 15.5
map NO
mfr_num 100514793
net_weight 0.18
non_member_discount 32
non_member_price 10.49
prop65 YES
ship_rule_desc STD
shipping STD
sku 83487
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.75
ta_dealer_c_price 6.98
ta_price 10.85
text
array
1 83487
2 100514793
3 cadmium yellow medium, 40 ml (1.35 oz)
timestamp 2015-03-30T16:21:50.847Z
vip_member_price 6.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219567
barcode_type EAN
col1 cerulean blue
col1_sortorder 1155
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 0-98-210.jpg
cost 6.15
deal_of_the_week NO
description cerulean blue, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 37144
list_price 15.5
map NO
mfr_num 100514822
net_weight 0.18
non_member_discount 32
non_member_price 10.49
prop65 YES
ship_rule_desc STD
shipping STD
sku 37144
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.75
ta_dealer_c_price 6.98
ta_price 10.85
text
array
1 37144
2 100514822
3 cerulean blue, 40 ml (1.35 oz)
timestamp 2015-03-30T16:20:18.522Z
vip_member_price 6.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219574
barcode_type EAN
col1 cerulean blue phthalo
col1_sortorder 1167
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 0-98-210.jpg
cost 2.92
deal_of_the_week NO
description cerulean blue phthalo, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 83563
list_price 7.35
map NO
mfr_num 100514823
net_weight 0.18
non_member_discount 32
non_member_price 4.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 83563
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.31
ta_price 5.15
text
array
1 83563
2 100514823
3 cerulean blue phthalo, 40 ml (1.35 oz)
timestamp 2015-03-30T16:21:51.05Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079004835
barcode_type EAN
col1 chrome oxide green
col1_sortorder 1251
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 77-164-164.jpg
cost 6.15
deal_of_the_week NO
description chrome oxide green, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 25204
list_price 15.5
map NO
mfr_num 100514838
net_weight 0.18
non_member_discount 32
non_member_price 10.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 25204
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.75
ta_dealer_c_price 6.98
ta_price 10.85
text
array
1 25204
2 100514838
3 chrome oxide green, 40 ml (1.35 oz)
timestamp 2015-03-30T16:19:47.723Z
vip_member_price 6.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219529
barcode_type EAN
col1 cobalt blue
col1_sortorder 1353
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 0-0-119.jpg
cost 6.15
deal_of_the_week NO
description cobalt blue, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 77924
list_price 15.5
map NO
mfr_num 100514817
net_weight 0.18
non_member_discount 32
non_member_price 10.49
prop65 YES
ship_rule_desc STD
shipping STD
sku 77924
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.75
ta_dealer_c_price 6.98
ta_price 10.85
text
array
1 77924
2 100514817
3 cobalt blue, 40 ml (1.35 oz)
timestamp 2015-03-30T16:21:43.209Z
vip_member_price 6.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219536
barcode_type EAN
col1 cobalt blue ultramarine
col1_sortorder 1368
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 0-0-164.jpg
cost 2.92
deal_of_the_week NO
description cobalt blue ultramarine, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 55367
list_price 7.35
map NO
mfr_num 100514818
net_weight 0.18
non_member_discount 32
non_member_price 4.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 55367
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.31
ta_price 5.15
text
array
1 55367
2 100514818
3 cobalt blue ultramarine, 40 ml (1.35 oz)
timestamp 2015-03-30T16:20:47.035Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219642
barcode_type EAN
col1 emerald green
col1_sortorder 2037
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 47-195-172.jpg
cost 2.92
deal_of_the_week NO
description emerald green, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 61345
list_price 7.35
map NO
mfr_num 100514830
net_weight 0.18
non_member_discount 32
non_member_price 4.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 61345
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.31
ta_price 5.15
text
array
1 61345
2 100514830
3 emerald green, 40 ml (1.35 oz)
timestamp 2015-03-30T16:20:59.409Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219703
barcode_type EAN
col1 green earth
col1_sortorder 2640
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 0-74-74.jpg
cost 2.92
deal_of_the_week NO
description green earth, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 52965
list_price 7.35
map NO
mfr_num 100514836
net_weight 0.18
non_member_discount 32
non_member_price 4.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 52965
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.31
ta_price 5.15
text
array
1 52965
2 100514836
3 green earth, 40 ml (1.35 oz)
timestamp 2015-03-30T16:20:45.629Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219413
barcode_type EAN
col1 Indian red
col1_sortorder 2940
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 119-60-0.jpg
cost 6.15
deal_of_the_week NO
description Indian red, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 68295
list_price 15.5
map NO
mfr_num 100514806
net_weight 0.18
non_member_discount 32
non_member_price 10.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 68295
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.75
ta_dealer_c_price 6.98
ta_price 10.85
text
array
1 68295
2 100514806
3 Indian red, 40 ml (1.35 oz)
timestamp 2015-03-30T16:21:16.371Z
vip_member_price 6.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219239
barcode_type EAN
col1 Indian yellow
col1_sortorder 2943
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 240-172-92.jpg
cost 6.15
deal_of_the_week NO
description Indian yellow, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 10028
list_price 15.5
map NO
mfr_num 100514787
net_weight 0.18
non_member_discount 32
non_member_price 10.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 10028
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.75
ta_dealer_c_price 6.98
ta_price 10.85
text
array
1 10028
2 100514787
3 Indian yellow, 40 ml (1.35 oz)
timestamp 2015-03-30T16:19:12.172Z
vip_member_price 6.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219741
barcode_type EAN
col1 ivory black
col1_sortorder 3126
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 0-0-0.jpg
cost 2.92
deal_of_the_week NO
description ivory black, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 36341
list_price 7.35
map NO
mfr_num 100514840
net_weight 0.18
non_member_discount 32
non_member_price 4.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 36341
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.31
ta_price 5.15
text
array
1 36341
2 100514840
3 ivory black, 40 ml (1.35 oz)
timestamp 2015-03-30T16:20:17.127Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219758
barcode_type EAN
col1 lamp black
col1_sortorder 3236
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 0-0-0.jpg
cost 2.92
deal_of_the_week NO
description lamp black, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 49093
list_price 7.35
map NO
mfr_num 100514841
net_weight 0.18
non_member_discount 32
non_member_price 4.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 49093
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.31
ta_price 5.15
text
array
1 49093
2 100514841
3 lamp black, 40 ml (1.35 oz)
timestamp 2015-03-30T16:20:35.919Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219406
barcode_type EAN
col1 light oxide red
col1_sortorder 3389
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 164-93-77.jpg
cost 2.92
deal_of_the_week NO
description light oxide red, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 52224
list_price 7.35
map NO
mfr_num 100514805
net_weight 0.18
non_member_discount 32
non_member_price 4.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 52224
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.31
ta_price 5.15
text
array
1 52224
2 100514805
3 light oxide red, 40 ml (1.35 oz)
timestamp 2015-03-30T16:20:41.154Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219390
barcode_type EAN
col1 madder lake deep
col1_sortorder 3530
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 164-0-62.jpg
cost 2.92
deal_of_the_week NO
description madder lake deep, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 27441
list_price 7.35
map NO
mfr_num 100514804
net_weight 0.18
non_member_discount 32
non_member_price 4.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 27441
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.31
ta_price 5.15
text
array
1 27441
2 100514804
3 madder lake deep, 40 ml (1.35 oz)
timestamp 2015-03-30T16:19:52.266Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219383
barcode_type EAN
col1 madder lake light
col1_sortorder 3531
col2 40 ml (1.35 oz)
col2_sortorder 1851
col3 [empty string]
color_swatch 255-122-152.jpg
cost 2.92
deal_of_the_week NO
description madder lake light, 40 ml (1.35 oz)
group_id 415
group_uname van-gogh-oil-color
id 51054
list_price 7.35
map NO
mfr_num 100514803
net_weight 0.18
non_member_discount 32
non_member_price 4.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 51054
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.68
ta_dealer_c_price 3.31
ta_price 5.15
text
array
1 51054
2 100514803
3 madder lake light, 40 ml (1.35 oz)
timestamp 2015-03-30T16:20:39.285Z
vip_member_price 3.29

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 1.000000000000 04009
2 6.000000000000 04010
3 5.000000000000 04011
4 5.000000000000 04012
CACHED false
EXECUTIONTIME 3
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] = '11753' 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.87.180.131

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030edcba99267da43341e54420784c30577
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=leather-crafting&CatC=fb~tandy-leather~fp~7-12~&gr=tandy-leather-craft-strip-lace.html
urltoken CFID=30373962&CFTOKEN=39815529&jsessionid=e030edcba99267da43341e54420784c30577
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 23:22:43'}
sessionid e030b6b9efe2a305fb084e2749253e37d4f6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~van-gogh~fp~7-13~&gr=van-gogh-oil-color.html
urltoken CFID=30373961&CFTOKEN=80782653&jsessionid=e030b6b9efe2a305fb084e2749253e37d4f6
validationerror [empty string]


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

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

ItemIDList: 04009,04010,04011,04012
AvailQtyList: 1.000000000000,6.000000000000,5.000000000000,5.000000000000

<
struct
FLAGS 0
VIP_member_discount 55
barcode 8712079219598