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

Woodcraft Markers

by Zig


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008477
barcode_type UPC
col1 antique metallic (dark champagne)
col1_sortorder 152
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 153-115-70.jpg
cost 2
deal_of_the_week NO
description antique metallic (dark champagne), chisel
group_id 7349
group_uname zig-woodcraft-markers
id 69382
list_price 3.64
map NO
mfr_num PWC-50-123
net_weight 0.04
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 69382
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 69382
2 PWC-50-123
3 antique metallic (dark champagne), chisel
timestamp 2015-03-27T14:47:54.21Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 21
barcode 847340008323
barcode_type UPC
col1 arctic white
col1_sortorder 200
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 255-255-255.jpg
cost 2
deal_of_the_week NO
description arctic white, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 72972
list_price 3.64
map NO
mfr_num PWC-50-000
net_weight 0.04
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 72972
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 72972
2 PWC-50-000
3 arctic white, chisel
timestamp 2015-03-27T14:48:03.11Z
vip_member_price 2.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 21
barcode 015586809336
barcode_type UPC
col1 arctic white
col1_sortorder 200
col2 big squared
col2_sortorder 61
col3 [empty string]
color_swatch 255-255-255.jpg
cost 4.53
deal_of_the_week NO
description arctic white, big squared
group_id 7349
group_uname zig-woodcraft-markers
id 79303
list_price 8.24
map NO
mfr_num PWC-120-000
net_weight 0.04
non_member_discount 10
non_member_price 7.43
prop65 NO
ship_rule_desc STD
shipping STD
sku 79303
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.36
ta_dealer_c_price 5.36
ta_price 7.41
text
array
1 79303
2 PWC-120-000
3 arctic white, big squared
timestamp 2015-03-27T14:48:09.048Z
vip_member_price 6.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 21
barcode 847340008842
barcode_type UPC
col1 black
col1_sortorder 402
col2 big squared
col2_sortorder 61
col3 [empty string]
color_swatch 20-16-17.jpg
cost 4.53
deal_of_the_week NO
description black, big squared
group_id 7349
group_uname zig-woodcraft-markers
id 57202
list_price 8.24
map NO
mfr_num PWC-120-010
net_weight 0.04
non_member_discount 10
non_member_price 7.43
prop65 NO
ship_rule_desc STD
shipping STD
sku 57202
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.36
ta_dealer_c_price 5.36
ta_price 7.41
text
array
1 57202
2 PWC-120-010
3 black, big squared
timestamp 2015-03-27T14:47:32.281Z
vip_member_price 6.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008330
barcode_type UPC
col1 black
col1_sortorder 402
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 20-16-17.jpg
cost 2
deal_of_the_week NO
description black, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 66755
list_price 3.64
map NO
mfr_num PWC-50-010
net_weight 0.04
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 66755
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 66755
2 PWC-50-010
3 black, chisel
timestamp 2015-03-27T14:47:49.359Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008590
barcode_type UPC
col1 bluebell
col1_sortorder 624
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 5-85-134.jpg
cost 2
deal_of_the_week NO
description bluebell, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 44246
list_price 3.64
map NO
mfr_num PWC-50-345
net_weight 0.04
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 44246
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 44246
2 PWC-50-345
3 bluebell, chisel
timestamp 2015-03-27T14:47:16.959Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008538
barcode_type UPC
col1 brick red
col1_sortorder 681
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 124-49-53.jpg
cost 2
deal_of_the_week NO
description brick red, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 69137
list_price 3.64
map NO
mfr_num PWC-50-204
net_weight 0.05
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 69137
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 69137
2 PWC-50-204
3 brick red, chisel
timestamp 2015-03-27T14:47:53.204Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 015586809121
barcode_type UPC
col1 bright green
col1_sortorder 708
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 0-159-89.jpg
cost 2
deal_of_the_week NO
description bright green, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 72080
list_price 3.64
map NO
mfr_num PWC-50-040
net_weight 0.04
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 72080
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 72080
2 PWC-50-040
3 bright green, chisel
timestamp 2015-03-27T14:48:01.043Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008682
barcode_type UPC
col1 burnt sienna
col1_sortorder 875
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 121-68-64.jpg
cost 2
deal_of_the_week NO
description burnt sienna, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 41705
list_price 3.64
map NO
mfr_num PWC-50-621
net_weight 0.04
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 41705
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 41705
2 PWC-50-621
3 burnt sienna, chisel
timestamp 2015-03-27T14:47:14.035Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 21
barcode 847340008712
barcode_type UPC
col1 burnt umber
col1_sortorder 886
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 95-78-70.jpg
cost 2
deal_of_the_week NO
description burnt umber, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 60393
list_price 3.64
map NO
mfr_num PWC-50-624
net_weight 0.04
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 60393
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 60393
2 PWC-50-624
3 burnt umber, chisel
timestamp 2015-03-27T14:47:38.205Z
vip_member_price 2.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008699
barcode_type UPC
col1 buttercup
col1_sortorder 900
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 251-216-126.jpg
cost 2
deal_of_the_week NO
description buttercup, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 69126
list_price 3.64
map NO
mfr_num PWC-50-622
net_weight 0.05
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 69126
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 69126
2 PWC-50-622
3 buttercup, chisel
timestamp 2015-03-27T14:47:53.179Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340016779
barcode_type UPC
col1 cabernet
col1_sortorder 907
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 139-29-90.jpg
cost 2
deal_of_the_week NO
description cabernet, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 69571
list_price 3.64
map NO
mfr_num PWC-50-844
net_weight 0.05
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 69571
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 69571
2 PWC-50-844
3 cabernet, chisel
timestamp 2015-03-27T14:47:54.553Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008354
barcode_type UPC
col1 carnation
col1_sortorder 1119
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 237-148-192.jpg
cost 2
deal_of_the_week NO
description carnation, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 38776
list_price 3.64
map NO
mfr_num PWC-50-025
net_weight 0.04
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 38776
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 38776
2 PWC-50-025
3 carnation, chisel
timestamp 2015-03-27T14:47:10.97Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008545
barcode_type UPC
col1 country blue
col1_sortorder 1568
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 114-172-222.jpg
cost 2
deal_of_the_week NO
description country blue, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 79045
list_price 3.64
map NO
mfr_num PWC-50-340
net_weight 0.04
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 79045
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 79045
2 PWC-50-340
3 country blue, chisel
timestamp 2015-03-27T14:48:08.876Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008347
barcode_type UPC
col1 crimson
col1_sortorder 1607
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 223-30-51.jpg
cost 2
deal_of_the_week NO
description crimson, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 16734
list_price 3.64
map NO
mfr_num PWC-50-020
net_weight 0.04
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 16734
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 16734
2 PWC-50-020
3 crimson, chisel
timestamp 2015-03-27T14:46:36.289Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008637
barcode_type UPC
col1 desert cactus
col1_sortorder 1855
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 46-123-107.jpg
cost 2
deal_of_the_week NO
description desert cactus, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 44365
list_price 3.64
map NO
mfr_num PWC-50-444
net_weight 0.04
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 44365
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 44365
2 PWC-50-444
3 desert cactus, chisel
timestamp 2015-03-27T14:47:17.089Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008651
barcode_type UPC
col1 English cucumber
col1_sortorder 2048
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 63-115-92.jpg
cost 2
deal_of_the_week NO
description English cucumber, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 53609
list_price 3.64
map NO
mfr_num PWC-50-446
net_weight 0.04
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 53609
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 53609
2 PWC-50-446
3 English cucumber, chisel
timestamp 2015-03-27T14:47:28.573Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 21
barcode 847340008729
barcode_type UPC
col1 flesh
col1_sortorder 2188
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 248-212-198.jpg
cost 2
deal_of_the_week NO
description flesh, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 19921
list_price 3.64
map NO
mfr_num PWC-50-711
net_weight 0.04
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 19921
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 19921
2 PWC-50-711
3 flesh, chisel
timestamp 2015-03-27T14:46:39.982Z
vip_member_price 2.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008606
barcode_type UPC
col1 forest green
col1_sortorder 2242
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 2-90-66.jpg
cost 2
deal_of_the_week NO
description forest green, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 10205
list_price 3.64
map NO
mfr_num PWC-50-441
net_weight 0.04
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 10205
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 10205
2 PWC-50-441
3 forest green, chisel
timestamp 2015-03-27T14:46:24.209Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008576
barcode_type UPC
col1 forget me not
col1_sortorder 2253
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 138-187-228.jpg
cost 2
deal_of_the_week NO
description forget me not, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 69125
list_price 3.64
map NO
mfr_num PWC-50-343
net_weight 0.05
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 69125
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 69125
2 PWC-50-343
3 forget me not, chisel
timestamp 2015-03-27T14:47:53.177Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008668
barcode_type UPC
col1 gardenia
col1_sortorder 2378
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 255-252-233.jpg
cost 2
deal_of_the_week NO
description gardenia, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 48421
list_price 3.64
map NO
mfr_num PWC-50-501
net_weight 0.04
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 48421
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 48421
2 PWC-50-501
3 gardenia, chisel
timestamp 2015-03-27T14:47:22.897Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340016755
barcode_type UPC
col1 glacier blue
col1_sortorder 2418
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 56-146-154.jpg
cost 2
deal_of_the_week NO
description glacier blue, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 69568
list_price 3.64
map NO
mfr_num PWC-50-346
net_weight 0.05
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 69568
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 69568
2 PWC-50-346
3 glacier blue, chisel
timestamp 2015-03-27T14:47:54.546Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 21
barcode 847340008705
barcode_type UPC
col1 golden yarrow
col1_sortorder 2558
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 218-140-42.jpg
cost 2
deal_of_the_week NO
description golden yarrow, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 69132
list_price 3.64
map NO
mfr_num PWC-50-623
net_weight 0.05
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 69132
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 69132
2 PWC-50-623
3 golden yarrow, chisel
timestamp 2015-03-27T14:47:53.191Z
vip_member_price 2.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008644
barcode_type UPC
col1 green apple
col1_sortorder 2623
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 0-133-88.jpg
cost 2
deal_of_the_week NO
description green apple, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 69168
list_price 3.64
map NO
mfr_num PWC-50-445
net_weight 0.04
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 69168
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 69168
2 PWC-50-445
3 green apple, chisel
timestamp 2015-03-27T14:47:53.456Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008569
barcode_type UPC
col1 harebell
col1_sortorder 2754
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 190-196-194.jpg
cost 2
deal_of_the_week NO
description harebell, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 69138
list_price 3.64
map NO
mfr_num PWC-50-342
net_weight 0.05
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 69138
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 69138
2 PWC-50-342
3 harebell, chisel
timestamp 2015-03-27T14:47:53.207Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008736
barcode_type UPC
col1 honeysuckle
col1_sortorder 2836
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 244-193-189.jpg
cost 2
deal_of_the_week NO
description honeysuckle, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 69133
list_price 3.64
map NO
mfr_num PWC-50-712
net_weight 0.05
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 69133
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 69133
2 PWC-50-712
3 honeysuckle, chisel
timestamp 2015-03-27T14:47:53.194Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008521
barcode_type UPC
col1 jubilee cherry
col1_sortorder 3162
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 162-33-64.jpg
cost 2
deal_of_the_week NO
description jubilee cherry, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 81314
list_price 3.64
map NO
mfr_num PWC-50-203
net_weight 0.04
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 81314
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 81314
2 PWC-50-203
3 jubilee cherry, chisel
timestamp 2015-03-27T14:48:12.266Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008743
barcode_type UPC
col1 marigold
col1_sortorder 3591
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 218-106-42.jpg
cost 2
deal_of_the_week NO
description marigold, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 69141
list_price 3.64
map NO
mfr_num PWC-50-713
net_weight 0.05
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 69141
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 69141
2 PWC-50-713
3 marigold, chisel
timestamp 2015-03-27T14:47:53.211Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008439
barcode_type UPC
col1 metallic gold
col1_sortorder 3703
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 234-185-57.jpg
cost 2
deal_of_the_week NO
description metallic gold, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 38320
list_price 3.64
map NO
mfr_num PWC-50-101
net_weight 0.04
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 38320
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 38320
2 PWC-50-101
3 metallic gold, chisel
timestamp 2015-03-27T14:47:10.599Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008453
barcode_type UPC
col1 metallic lime
col1_sortorder 3711
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 104-189-96.jpg
cost 2
deal_of_the_week NO
description metallic lime, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 69143
list_price 3.64
map NO
mfr_num PWC-50-121
net_weight 0.04
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 69143
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 69143
2 PWC-50-121
3 metallic lime, chisel
timestamp 2015-03-27T14:47:53.215Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '127' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e0309fdb18f5796ce0e04d17786d7a62724c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pens&CatC=lettering-calligraphy-pens&CatD=cartridge-pens&gr=sheaffer-calligraphy-ink-cartridges.html
urltoken CFID=30173832&CFTOKEN=81081162&jsessionid=e0309fdb18f5796ce0e04d17786d7a62724c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 06:17:07'}
sessionid e03094b1d8fb540a00e0367d217523656546
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=markers&CatC=craft-markers&CatD=fb~zig~fp~3-6~&gr=zig-woodcraft-markers.html
urltoken CFID=30173833&CFTOKEN=76247553&jsessionid=e03094b1d8fb540a00e0367d217523656546
validationerror [empty string]


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

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

ItemIDList: 31940,32302,46408,47261,56307,64915,85381
AvailQtyList: 45.000000000000,50.000000000000,71.000000000000,0E-12,48.000000000000,42.000000000000,60.000000000000

struct
FLAGS 0
VIP_member_discount 22
barcode 847340008460
barcode_type UPC
col1 metallic rose
col1_sortorder 3720
col2 chisel
col2_sortorder 56
col3 [empty string]
color_swatch 225-45-145.jpg
cost 2
deal_of_the_week NO
description metallic rose, chisel
group_id 7349
group_uname zig-woodcraft-markers
id 69127
list_price 3.64
map NO
mfr_num PWC-50-122
net_weight 0.04
non_member_discount 10
non_member_price 3.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 69127
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.37
ta_dealer_c_price 2.37
ta_price 3.28
text
array
1 69127
2 PWC-50-122
3 metallic rose, chisel
timestamp 2015-03-27T14:47:53.183Z
vip_member_price 2.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 45.000000000000 31940
2 50.000000000000 32302
3 71.000000000000 46408
4 0E-12 47261
5 48.000000000000 56307
6 42.000000000000 64915
7 60.000000000000 85381