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

Standard Series Acrylic Paint

by Amsterdam


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079158149
barcode_type EAN
col1 azo lemon yellow
col1_sortorder 269
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 253-245-101.jpg
cost 2.7
deal_of_the_week NO
description azo lemon yellow, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 77203
list_price 6.8
map NO
mfr_num 100515143
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 77203
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 77203
2 100515143
3 azo lemon yellow, 120 ml
timestamp 2015-03-30T16:21:42.143Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079158200
barcode_type EAN
col1 azo orange
col1_sortorder 270
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 253-114-10.jpg
cost 2.7
deal_of_the_week NO
description azo orange, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 38661
list_price 6.8
map NO
mfr_num 100515150
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 38661
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 38661
2 100515150
3 azo orange, 120 ml
timestamp 2015-03-30T16:20:20.698Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079254728
barcode_type EAN
col1 azo orange
col1_sortorder 270
col2 250 ml
col2_sortorder 1400
col3 [empty string]
color_swatch 253-114-10.jpg
cost 4.79
deal_of_the_week NO
description azo orange, 250 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 71115
list_price 12.1
map NO
mfr_num 100515214
net_weight 0.66
non_member_discount 41
non_member_price 7.18
prop65 NO
ship_rule_desc STD
shipping STD
sku 71115
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.2
ta_dealer_c_price 5.2
ta_price 7.87
text
array
1 71115
2 100515214
3 azo orange, 250 ml
timestamp 2015-03-30T16:21:28.175Z
vip_member_price 5.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079158187
barcode_type EAN
col1 azo yellow deep
col1_sortorder 276
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 245-173-27.jpg
cost 2.7
deal_of_the_week NO
description azo yellow deep, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 50722
list_price 6.8
map NO
mfr_num 100515146
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 50722
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 50722
2 100515146
3 azo yellow deep, 120 ml
timestamp 2015-03-30T16:20:39.071Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079254704
barcode_type EAN
col1 azo yellow deep
col1_sortorder 276
col2 250 ml
col2_sortorder 1400
col3 [empty string]
color_swatch 245-173-27.jpg
cost 4.79
deal_of_the_week NO
description azo yellow deep, 250 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 71113
list_price 12.1
map NO
mfr_num 100515212
net_weight 0.67
non_member_discount 41
non_member_price 7.18
prop65 NO
ship_rule_desc STD
shipping STD
sku 71113
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.2
ta_dealer_c_price 5.2
ta_price 7.87
text
array
1 71113
2 100515212
3 azo yellow deep, 250 ml
timestamp 2015-03-30T16:21:28.164Z
vip_member_price 5.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079210991
barcode_type EAN
col1 azo yellow light
col1_sortorder 278
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 251-222-39.jpg
cost 2.7
deal_of_the_week NO
description azo yellow light, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 85145
list_price 6.8
map NO
mfr_num 100515144
net_weight 0.22
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 85145
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 85145
2 100515144
3 azo yellow light, 120 ml
timestamp 2015-03-30T16:21:53.8Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079268015
barcode_type EAN
col1 azo yellow medium
col1_sortorder 279
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 255-198-0.jpg
cost 2.7
deal_of_the_week NO
description azo yellow medium, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 35612
list_price 6.8
map NO
mfr_num 100515145
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 35612
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 35612
2 100515145
3 azo yellow medium, 120 ml
timestamp 2015-03-30T16:20:13.847Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079158408
barcode_type EAN
col1 brilliant blue
col1_sortorder 753
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 0-173-230.jpg
cost 2.7
deal_of_the_week NO
description brilliant blue, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 79522
list_price 6.8
map NO
mfr_num 100515180
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 79522
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 79522
2 100515180
3 brilliant blue, 120 ml
timestamp 2015-03-30T16:21:45.466Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079268282
barcode_type EAN
col1 brilliant green
col1_sortorder 757
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 42-181-0.jpg
cost 2.7
deal_of_the_week NO
description brilliant green, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 35615
list_price 6.8
map NO
mfr_num 100515188
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 35615
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 35615
2 100515188
3 brilliant green, 120 ml
timestamp 2015-03-30T16:20:13.91Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079158347
barcode_type EAN
col1 burnt sienna
col1_sortorder 876
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 170-66-0.jpg
cost 2.7
deal_of_the_week NO
description burnt sienna, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 25280
list_price 6.8
map NO
mfr_num 100515171
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 25280
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 25280
2 100515171
3 burnt sienna, 120 ml
timestamp 2015-03-30T16:19:47.942Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079254827
barcode_type EAN
col1 burnt sienna
col1_sortorder 876
col2 250 ml
col2_sortorder 1400
col3 [empty string]
color_swatch 170-66-0.jpg
cost 4.79
deal_of_the_week NO
description burnt sienna, 250 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 71121
list_price 12.1
map NO
mfr_num 100515219
net_weight 0.67
non_member_discount 41
non_member_price 7.18
prop65 NO
ship_rule_desc STD
shipping STD
sku 71121
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.2
ta_dealer_c_price 5.2
ta_price 7.87
text
array
1 71121
2 100515219
3 burnt sienna, 250 ml
timestamp 2015-03-30T16:21:28.222Z
vip_member_price 5.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079158323
barcode_type EAN
col1 burnt umber
col1_sortorder 887
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 89-53-37.jpg
cost 2.7
deal_of_the_week NO
description burnt umber, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 39032
list_price 6.8
map NO
mfr_num 100515170
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 39032
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 39032
2 100515170
3 burnt umber, 120 ml
timestamp 2015-03-30T16:20:21.995Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079254810
barcode_type EAN
col1 burnt umber
col1_sortorder 887
col2 250 ml
col2_sortorder 1400
col3 [empty string]
color_swatch 89-53-37.jpg
cost 4.79
deal_of_the_week NO
description burnt umber, 250 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 71120
list_price 12.1
map NO
mfr_num 100515218
net_weight 0.68
non_member_discount 41
non_member_price 7.18
prop65 NO
ship_rule_desc STD
shipping STD
sku 71120
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.2
ta_dealer_c_price 5.2
ta_price 7.87
text
array
1 71120
2 100515218
3 burnt umber, 250 ml
timestamp 2015-03-30T16:21:28.219Z
vip_member_price 5.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079158224
barcode_type EAN
col1 carmine
col1_sortorder 1111
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 219-0-57.jpg
cost 2.7
deal_of_the_week NO
description carmine, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 31655
list_price 6.8
map NO
mfr_num 100515158
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 31655
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 31655
2 100515158
3 carmine, 120 ml
timestamp 2015-03-30T16:20:01.283Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079254735
barcode_type EAN
col1 carmine
col1_sortorder 1111
col2 250 ml
col2_sortorder 1400
col3 [empty string]
color_swatch 219-0-57.jpg
cost 4.79
deal_of_the_week NO
description carmine, 250 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 71116
list_price 12.1
map NO
mfr_num 100515215
net_weight 0.65
non_member_discount 41
non_member_price 7.18
prop65 NO
ship_rule_desc STD
shipping STD
sku 71116
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.2
ta_dealer_c_price 5.2
ta_price 7.87
text
array
1 71116
2 100515215
3 carmine, 250 ml
timestamp 2015-03-30T16:21:28.179Z
vip_member_price 5.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079158385
barcode_type EAN
col1 cobalt blue
col1_sortorder 1353
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 2-87-197.jpg
cost 2.7
deal_of_the_week NO
description cobalt blue, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 41540
list_price 6.8
map NO
mfr_num 100515174
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 41540
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 41540
2 100515174
3 cobalt blue, 120 ml
timestamp 2015-03-30T16:20:25.602Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079217549
barcode_type EAN
col1 deep gold
col1_sortorder 1816
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 223-175-43.jpg
cost 3.42
deal_of_the_week NO
description deep gold, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 57538
list_price 8.6
map NO
mfr_num 100515204
net_weight 0.22
non_member_discount 41
non_member_price 5.12
prop65 NO
ship_rule_desc STD
shipping STD
sku 57538
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.7
ta_dealer_c_price 3.7
ta_price 5.59
text
array
1 57538
2 100515204
3 deep gold, 120 ml
timestamp 2015-03-30T16:20:49.82Z
vip_member_price 4.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079158460
barcode_type EAN
col1 emerald green
col1_sortorder 2037
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 2-154-107.jpg
cost 2.7
deal_of_the_week NO
description emerald green, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 39033
list_price 6.8
map NO
mfr_num 100515189
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 39033
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 39033
2 100515189
3 emerald green, 120 ml
timestamp 2015-03-30T16:20:21.997Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079267988
barcode_type EAN
col1 gold ochre
col1_sortorder 2525
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 235-163-3.jpg
cost 2.7
deal_of_the_week NO
description gold ochre, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 35618
list_price 6.8
map NO
mfr_num 100515137
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 35618
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 35618
2 100515137
3 gold ochre, 120 ml
timestamp 2015-03-30T16:20:13.938Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079268008
barcode_type EAN
col1 gold yellow
col1_sortorder 2542
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 248-189-109.jpg
cost 2.7
deal_of_the_week NO
description gold yellow, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 35619
list_price 6.8
map NO
mfr_num 100515140
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 35619
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 35619
2 100515140
3 gold yellow, 120 ml
timestamp 2015-03-30T16:20:13.952Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079268237
barcode_type EAN
col1 greenish blue
col1_sortorder 2692
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 5-153-186.jpg
cost 2.7
deal_of_the_week NO
description greenish blue, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 35620
list_price 6.8
map NO
mfr_num 100515178
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 35620
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 35620
2 100515178
3 greenish blue, 120 ml
timestamp 2015-03-30T16:20:13.97Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079267995
barcode_type EAN
col1 greenish yellow
col1_sortorder 2695
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 222-232-24.jpg
cost 2.7
deal_of_the_week NO
description greenish yellow, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 35621
list_price 6.8
map NO
mfr_num 100515139
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 35621
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 35621
2 100515139
3 greenish yellow, 120 ml
timestamp 2015-03-30T16:20:13.99Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079268244
barcode_type EAN
col1 greyish blue
col1_sortorder 2719
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 155-175-204.jpg
cost 2.7
deal_of_the_week NO
description greyish blue, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 35622
list_price 6.8
map NO
mfr_num 100515179
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 35622
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 35622
2 100515179
3 greyish blue, 120 ml
timestamp 2015-03-30T16:20:14.005Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079268190
barcode_type EAN
col1 king's blue
col1_sortorder 3211
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 77-177-222.jpg
cost 2.7
deal_of_the_week NO
description king's blue, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 35623
list_price 6.8
map NO
mfr_num 100515175
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 35623
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 35623
2 100515175
3 king's blue, 120 ml
timestamp 2015-03-30T16:20:14.02Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079268329
barcode_type EAN
col1 lamp black
col1_sortorder 3236
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 36-35-37.jpg
cost 2.7
deal_of_the_week NO
description lamp black, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 35624
list_price 6.8
map NO
mfr_num 100515198
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 35624
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 35624
2 100515198
3 lamp black, 120 ml
timestamp 2015-03-30T16:20:14.032Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079217525
barcode_type EAN
col1 light gold
col1_sortorder 3348
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 239-199-83.jpg
cost 3.42
deal_of_the_week NO
description light gold, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 30557
list_price 8.6
map NO
mfr_num 100515203
net_weight 0.22
non_member_discount 41
non_member_price 5.12
prop65 NO
ship_rule_desc STD
shipping STD
sku 30557
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.7
ta_dealer_c_price 3.7
ta_price 5.59
text
array
1 30557
2 100515203
3 light gold, 120 ml
timestamp 2015-03-30T16:19:58.786Z
vip_member_price 4.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079268152
barcode_type EAN
col1 light rose
col1_sortorder 3406
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 254-203-226.jpg
cost 2.7
deal_of_the_week NO
description light rose, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 35676
list_price 6.8
map NO
mfr_num 100515161
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 35676
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 35676
2 100515161
3 light rose, 120 ml
timestamp 2015-03-30T16:20:14.683Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079268275
barcode_type EAN
col1 manganese blue phthalo
col1_sortorder 3577
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 25-113-188.jpg
cost 2.7
deal_of_the_week NO
description manganese blue phthalo, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 35629
list_price 6.8
map NO
mfr_num 100515187
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 35629
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 35629
2 100515187
3 manganese blue phthalo, 120 ml
timestamp 2015-03-30T16:20:14.114Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079211011
barcode_type EAN
col1 naphthol red deep
col1_sortorder 3903
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 209-35-33.jpg
cost 2.7
deal_of_the_week NO
description naphthol red deep, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 17791
list_price 6.8
map NO
mfr_num 100515168
net_weight 0.22
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 17791
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 17791
2 100515168
3 naphthol red deep, 120 ml
timestamp 2015-03-30T16:19:34.718Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079158286
barcode_type EAN
col1 naphthol red light
col1_sortorder 3904
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 242-83-16.jpg
cost 2.7
deal_of_the_week NO
description naphthol red light, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 58866
list_price 6.8
map NO
mfr_num 100515167
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 58866
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 58866
2 100515167
3 naphthol red light, 120 ml
timestamp 2015-03-30T16:20:51.369Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

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

ItemIDList: 11995,29729,72873,83197,84171
AvailQtyList: 31.000000000000,17.000000000000,10.000000000000,18.000000000000,21.000000000000

struct
FLAGS 0
VIP_member_discount 51
barcode 8712079158262
barcode_type EAN
col1 naphthol red medium
col1_sortorder 3905
col2 120 ml
col2_sortorder 888
col3 [empty string]
color_swatch 241-75-57.jpg
cost 2.7
deal_of_the_week NO
description naphthol red medium, 120 ml
group_id 7367
group_uname amsterdam-standard-series-acrylic-paint
id 10067
list_price 6.8
map NO
mfr_num 100515166
net_weight 0.3
non_member_discount 41
non_member_price 4.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 10067
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.92
ta_dealer_c_price 2.92
ta_price 4.42
text
array
1 10067
2 100515166
3 naphthol red medium, 120 ml
timestamp 2015-03-30T16:19:12.2Z
vip_member_price 3.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 31.000000000000 11995
2 17.000000000000 29729
3 10.000000000000 72873
4 18.000000000000 83197
5 21.000000000000 84171
CACHED false
EXECUTIONTIME 6
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] = '515' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=cleaning&CatC=solvents-thinners&CatD=fp~6-9~&gr=martin-f-weber-turpenoid-natural.html
urltoken CFID=30437540&CFTOKEN=99525855&jsessionid=e030e1a5d9d2239cfd1d6b2671ed7c5a01d2
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:49:53'}
sessionid e030cfd481f338a8efd931c38583c6b4d221
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=fb~amsterdam~&gr=amsterdam-standard-series-acrylic-paint.html
urltoken CFID=30437539&CFTOKEN=69369043&jsessionid=e030cfd481f338a8efd931c38583c6b4d221
validationerror [empty string]


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

SOLR Query: http://10.100.22.71:8888