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

Artist's Paintstik Oil Colors

by Shiva


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061100
barcode_type UPC
col1 alizarin crimson
col1_sortorder 81
col2 [empty string]
col3 [empty string]
color_swatch 132-23-30.jpg
cost 3.27
deal_of_the_week NO
description alizarin crimson
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 87819
list_price 8.25
map NO
mfr_num 121208
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 87819
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 87819
2 121208
3 alizarin crimson
timestamp 2015-03-27T14:48:20.175Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061049
barcode_type UPC
col1 antique white
col1_sortorder 160
col2 [empty string]
col3 [empty string]
color_swatch 238-233-203.jpg
cost 3.27
deal_of_the_week NO
description antique white
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 50106
list_price 8.25
map NO
mfr_num 121202
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 50106
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 50106
2 121202
3 antique white
timestamp 2015-03-27T14:47:24.454Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061247
barcode_type UPC
col1 azo orange
col1_sortorder 270
col2 [empty string]
col3 [empty string]
color_swatch 226-59-38.jpg
cost 3.27
deal_of_the_week NO
description azo orange
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 76085
list_price 8.25
map NO
mfr_num 121222
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 76085
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 76085
2 121222
3 azo orange
timestamp 2015-03-27T14:48:06.142Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061216
barcode_type UPC
col1 azo yellow
col1_sortorder 275
col2 [empty string]
col3 [empty string]
color_swatch 243-203-21.jpg
cost 3.27
deal_of_the_week NO
description azo yellow
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 56657
list_price 8.25
map NO
mfr_num 121219
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 56657
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 56657
2 121219
3 azo yellow
timestamp 2015-03-27T14:47:31.769Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061148
barcode_type UPC
col1 barn red
col1_sortorder 334
col2 [empty string]
col3 [empty string]
color_swatch 90-33-21.jpg
cost 3.27
deal_of_the_week NO
description barn red
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 62610
list_price 8.25
map NO
mfr_num 121212
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 62610
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 62610
2 121212
3 barn red
timestamp 2015-03-27T14:47:42.284Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304063593
barcode_type UPC
col1 brown iridescent
col1_sortorder 806
col2 [empty string]
col3 [empty string]
color_swatch 89-56-31.jpg
cost 3.94
deal_of_the_week NO
description brown iridescent
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 50416
list_price 9.95
map NO
mfr_num 121729
net_weight 0.1
non_member_discount 36
non_member_price 6.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 50416
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.98
ta_dealer_c_price 4.48
ta_price 7.96
text
array
1 50416
2 121729
3 brown iridescent
timestamp 2015-03-27T14:47:24.886Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061476
barcode_type UPC
col1 burnt sienna
col1_sortorder 875
col2 [empty string]
col3 [empty string]
color_swatch 97-38-24.jpg
cost 3.27
deal_of_the_week NO
description burnt sienna
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 18939
list_price 8.25
map NO
mfr_num 121245
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 18939
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 18939
2 121245
3 burnt sienna
timestamp 2015-03-27T14:46:39.177Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061483
barcode_type UPC
col1 burnt umber
col1_sortorder 886
col2 [empty string]
col3 [empty string]
color_swatch 49-27-18.jpg
cost 3.27
deal_of_the_week NO
description burnt umber
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 16580
list_price 8.25
map NO
mfr_num 121246
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 16580
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 16580
2 121246
3 burnt umber
timestamp 2015-03-27T14:46:35.97Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061452
barcode_type UPC
col1 celadon green
col1_sortorder 1142
col2 [empty string]
col3 [empty string]
color_swatch 94-113-81.jpg
cost 3.27
deal_of_the_week NO
description celadon green
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 30663
list_price 8.25
map NO
mfr_num 121243
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 30663
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 30663
2 121243
3 celadon green
timestamp 2015-03-27T14:46:55.404Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 47
barcode 717304061292
barcode_type UPC
col1 cobalt blue
col1_sortorder 1352
col2 [empty string]
col3 [empty string]
color_swatch 35-58-139.jpg
cost 6.25
deal_of_the_week NO
description cobalt blue
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 59186
list_price 15.75
map NO
mfr_num 121227
net_weight 0.1
non_member_discount 36
non_member_price 10.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 59186
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.88
ta_dealer_c_price 7.09
ta_price 12.6
text
array
1 59186
2 121227
3 cobalt blue
timestamp 2015-03-27T14:47:34.983Z
vip_member_price 8.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061025
barcode_type UPC
col1 colorless blender
col1_sortorder 1466
col2 [empty string]
col3 [empty string]
color_swatch 255-255-255.jpg
cost 3.27
deal_of_the_week NO
description colorless blender
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 55029
list_price 8.25
map NO
mfr_num 121200
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 55029
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 55029
2 121200
3 colorless blender
timestamp 2015-03-27T14:47:29.701Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304063609
barcode_type UPC
col1 copper iridescent
col1_sortorder 1534
col2 [empty string]
col3 [empty string]
color_swatch 151-70-62.jpg
cost 3.94
deal_of_the_week NO
description copper iridescent
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 49212
list_price 9.95
map NO
mfr_num 121730
net_weight 0.1
non_member_discount 36
non_member_price 6.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 49212
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.98
ta_dealer_c_price 4.48
ta_price 7.96
text
array
1 49212
2 121730
3 copper iridescent
timestamp 2015-03-27T14:47:23.661Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304063548
barcode_type UPC
col1 dark blue iridescent
col1_sortorder 1675
col2 [empty string]
col3 [empty string]
color_swatch 21-67-120.jpg
cost 3.94
deal_of_the_week NO
description dark blue iridescent
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 80601
list_price 9.95
map NO
mfr_num 121724
net_weight 0.1
non_member_discount 36
non_member_price 6.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 80601
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.98
ta_dealer_c_price 4.48
ta_price 7.96
text
array
1 80601
2 121724
3 dark blue iridescent
timestamp 2015-03-27T14:48:11.169Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061155
barcode_type UPC
col1 dusty rose
col1_sortorder 1978
col2 [empty string]
col3 [empty string]
color_swatch 205-136-129.jpg
cost 3.27
deal_of_the_week NO
description dusty rose
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 28752
list_price 8.25
map NO
mfr_num 121213
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 28752
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 28752
2 121213
3 dusty rose
timestamp 2015-03-27T14:46:52.453Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304063524
barcode_type UPC
col1 gold iridescent
col1_sortorder 2506
col2 [empty string]
col3 [empty string]
color_swatch 163-106-54.jpg
cost 3.94
deal_of_the_week NO
description gold iridescent
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 13219
list_price 9.95
map NO
mfr_num 121722
net_weight 0.1
non_member_discount 36
non_member_price 6.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 13219
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.98
ta_dealer_c_price 4.48
ta_price 7.96
text
array
1 13219
2 121722
3 gold iridescent
timestamp 2015-03-27T14:46:28.55Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061377
barcode_type UPC
col1 grape decorative
col1_sortorder 2573
col2 [empty string]
col3 [empty string]
color_swatch 104-32-65.jpg
cost 3.27
deal_of_the_week NO
description grape decorative
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 15997
list_price 8.25
map NO
mfr_num 121235
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 15997
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 15997
2 121235
3 grape decorative
timestamp 2015-03-27T14:46:35.079Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304063579
barcode_type UPC
col1 green iridescent
col1_sortorder 2651
col2 [empty string]
col3 [empty string]
color_swatch 0-123-67.jpg
cost 3.94
deal_of_the_week NO
description green iridescent
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 62294
list_price 9.95
map NO
mfr_num 121727
net_weight 0.1
non_member_discount 36
non_member_price 6.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 62294
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.98
ta_dealer_c_price 4.48
ta_price 7.96
text
array
1 62294
2 121727
3 green iridescent
timestamp 2015-03-27T14:47:41.806Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061346
barcode_type UPC
col1 ice blue
col1_sortorder 2889
col2 [empty string]
col3 [empty string]
color_swatch 135-150-145.jpg
cost 3.27
deal_of_the_week NO
description ice blue
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 71409
list_price 8.25
map NO
mfr_num 121232
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 71409
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 71409
2 121232
3 ice blue
timestamp 2015-03-27T14:47:59.604Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061056
barcode_type UPC
col1 ivory black
col1_sortorder 3120
col2 [empty string]
col3 [empty string]
color_swatch 26-22-24.jpg
cost 3.27
deal_of_the_week NO
description ivory black
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 71808
list_price 8.25
map NO
mfr_num 121203
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 71808
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 71808
2 121203
3 ivory black
timestamp 2015-03-27T14:48:00.65Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304063616
barcode_type UPC
col1 light gold iridescent
col1_sortorder 3343
col2 [empty string]
col3 [empty string]
color_swatch 191-148-45.jpg
cost 3.94
deal_of_the_week NO
description light gold iridescent
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 32362
list_price 9.95
map NO
mfr_num 121731
net_weight 0.1
non_member_discount 36
non_member_price 6.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 32362
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.98
ta_dealer_c_price 4.48
ta_price 7.96
text
array
1 32362
2 121731
3 light gold iridescent
timestamp 2015-03-27T14:46:58.328Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061391
barcode_type UPC
col1 light green decorative
col1_sortorder 3354
col2 [empty string]
col3 [empty string]
color_swatch 140-203-168.jpg
cost 3.27
deal_of_the_week NO
description light green decorative
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 41075
list_price 8.25
map NO
mfr_num 121237
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 41075
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 41075
2 121237
3 light green decorative
timestamp 2015-03-27T14:47:13.177Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061162
barcode_type UPC
col1 medium pink decorative
col1_sortorder 3667
col2 [empty string]
col3 [empty string]
color_swatch 227-147-154.jpg
cost 3.27
deal_of_the_week NO
description medium pink decorative
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 36490
list_price 8.25
map NO
mfr_num 121214
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 36490
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 36490
2 121214
3 medium pink decorative
timestamp 2015-03-27T14:47:07.46Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061087
barcode_type UPC
col1 mudstone decorative
col1_sortorder 3858
col2 [empty string]
col3 [empty string]
color_swatch 143-125-90.jpg
cost 3.27
deal_of_the_week NO
description mudstone decorative
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 65627
list_price 8.25
map NO
mfr_num 121206
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 65627
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 65627
2 121206
3 mudstone decorative
timestamp 2015-03-27T14:47:47.228Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061131
barcode_type UPC
col1 naphthol red
col1_sortorder 3895
col2 [empty string]
col3 [empty string]
color_swatch 183-31-36.jpg
cost 3.27
deal_of_the_week NO
description naphthol red
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 12518
list_price 8.25
map NO
mfr_num 121211
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 12518
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 12518
2 121211
3 naphthol red
timestamp 2015-03-27T14:46:27.597Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061070
barcode_type UPC
col1 pewter gray
col1_sortorder 4646
col2 [empty string]
col3 [empty string]
color_swatch 106-101-98.jpg
cost 3.27
deal_of_the_week NO
description pewter gray
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 64633
list_price 8.25
map NO
mfr_num 121205
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 64633
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 64633
2 121205
3 pewter gray
timestamp 2015-03-27T14:47:45.456Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061285
barcode_type UPC
col1 phthalo blue
col1_sortorder 4652
col2 [empty string]
col3 [empty string]
color_swatch 23-22-65.jpg
cost 3.27
deal_of_the_week NO
description phthalo blue
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 49401
list_price 8.25
map NO
mfr_num 121226
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 49401
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 49401
2 121226
3 phthalo blue
timestamp 2015-03-27T14:47:23.811Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061407
barcode_type UPC
col1 phthalo green
col1_sortorder 4671
col2 [empty string]
col3 [empty string]
color_swatch 5-54-45.jpg
cost 3.27
deal_of_the_week NO
description phthalo green
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 38119
list_price 8.25
map NO
mfr_num 121238
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 38119
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 38119
2 121238
3 phthalo green
timestamp 2015-03-27T14:47:10.376Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061308
barcode_type UPC
col1 Prussian blue
col1_sortorder 4895
col2 [empty string]
col3 [empty string]
color_swatch 23-28-69.jpg
cost 3.27
deal_of_the_week NO
description Prussian blue
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 57185
list_price 8.25
map NO
mfr_num 121228
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 57185
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 57185
2 121228
3 Prussian blue
timestamp 2015-03-27T14:47:32.259Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304063562
barcode_type UPC
col1 purple iridescent
col1_sortorder 4936
col2 [empty string]
col3 [empty string]
color_swatch 93-66-141.jpg
cost 3.94
deal_of_the_week NO
description purple iridescent
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 25017
list_price 9.95
map NO
mfr_num 121726
net_weight 0.1
non_member_discount 36
non_member_price 6.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 25017
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.98
ta_dealer_c_price 4.48
ta_price 7.96
text
array
1 25017
2 121726
3 purple iridescent
timestamp 2015-03-27T14:46:46.643Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061384
barcode_type UPC
col1 purple sage
col1_sortorder 4947
col2 [empty string]
col3 [empty string]
color_swatch 86-74-154.jpg
cost 3.27
deal_of_the_week NO
description purple sage
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 75886
list_price 8.25
map NO
mfr_num 121236
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 75886
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 75886
2 121236
3 purple sage
timestamp 2015-03-27T14:48:06.016Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304061490
barcode_type UPC
col1 raw umber
col1_sortorder 5060
col2 [empty string]
col3 [empty string]
color_swatch 36-30-23.jpg
cost 3.27
deal_of_the_week NO
description raw umber
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 16342
list_price 8.25
map NO
mfr_num 121247
net_weight 0.1
non_member_discount 36
non_member_price 5.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 16342
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.13
ta_dealer_c_price 3.71
ta_price 6.6
text
array
1 16342
2 121247
3 raw umber
timestamp 2015-03-27T14:46:35.754Z
vip_member_price 4.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03092cd207f6dd30dad1b5779521a536633
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=tools-accessories&CatD=sort~1~fb~lineco~fp~7-9999.99~&gr=lineco-bone-folders.html
urltoken CFID=29473169&CFTOKEN=13129110&jsessionid=e03092cd207f6dd30dad1b5779521a536633
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 19:52:41'}
sessionid e03048a65cae6f44bd946f9424d5b633c61a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html
urltoken CFID=29473171&CFTOKEN=54725769&jsessionid=e03048a65cae6f44bd946f9424d5b633c61a
validationerror [empty string]


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

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

ItemIDList: 32484,37073
AvailQtyList: 26.000000000000,121.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 717304063500
barcode_type UPC
col1 red iridescent
col1_sortorder 5114
col2 [empty string]
col3 [empty string]
color_swatch 168-40-49.jpg
cost 3.94
deal_of_the_week NO
description red iridescent
group_id 359
group_uname shiva-artist-s-paintstik-oil-colors
id 46301
list_price 9.95
map NO
mfr_num 121720
net_weight 0.1
non_member_discount 36
non_member_price 6.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 46301
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.98
ta_dealer_c_price 4.48
ta_price 7.96
text
array
1 46301
2 121720
3 red iridescent
timestamp 2015-03-27T14:47:20.194Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 32484
2 121.000000000000 37073
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1692' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=crafts&catB=stenciling&CatC=fp~2-5~&gr=shiva-artist-s-paintstik-oil-colors.html

StartSessionVariables: