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

ChromaTemp Artists' Tempera Paint

by Chroma Inc.


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200020001
barcode_type UPC
col1 black
col1_sortorder 402
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 0-0-0.jpg
cost 0.7
deal_of_the_week NO
description black, 2 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 13299
list_price 2.32
map NO
mfr_num 2000
net_weight 0.16
non_member_discount 40
non_member_price 1.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 13299
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.81
ta_dealer_c_price 0.81
ta_price 1.21
text
array
1 13299
2 2000
3 black, 2 oz.
timestamp 2015-03-27T14:46:28.681Z
vip_member_price 1.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=furniture&catB=tables-drawing-boards&CatC=art-tables&gr=alvin-craftmaster-hobby-station.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200024009
barcode_type UPC
col1 black
col1_sortorder 402
col2 16.9 oz.
col2_sortorder 1019
col3 [empty string]
color_swatch 0-0-0.jpg
cost 2.07
deal_of_the_week NO
description black, 16.9 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 16246
list_price 5.66
map NO
mfr_num 2400
net_weight 1.2
non_member_discount 40
non_member_price 3.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 16246
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.26
ta_dealer_c_price 2.26
ta_price 3.4
text
array
1 16246
2 2400
3 black, 16.9 oz.
timestamp 2015-03-27T14:46:35.671Z
vip_member_price 2.83

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=furniture&catB=tables-drawing-boards&CatC=art-tables&gr=alvin-craftmaster-hobby-station.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200022005
barcode_type UPC
col1 black
col1_sortorder 402
col2 8 oz.
col2_sortorder 2317
col3 [empty string]
color_swatch 0-0-0.jpg
cost 1.27
deal_of_the_week NO
description black, 8 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 17534
list_price 4
map NO
mfr_num 2200
net_weight 0.74
non_member_discount 40
non_member_price 2.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 17534
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.08
text
array
1 17534
2 2200
3 black, 8 oz.
timestamp 2015-03-27T14:46:37.422Z
vip_member_price 2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=furniture&catB=tables-drawing-boards&CatC=art-tables&gr=alvin-craftmaster-hobby-station.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200026003
barcode_type UPC
col1 black
col1_sortorder 402
col2 32 oz.
col2_sortorder 1660
col3 [empty string]
color_swatch 0-0-0.jpg
cost 3.44
deal_of_the_week NO
description black, 32 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 37271
list_price 10.49
map NO
mfr_num 2600
net_weight 2.32
non_member_discount 40
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 37271
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.78
ta_dealer_c_price 3.78
ta_price 5.66
text
array
1 37271
2 2600
3 black, 32 oz.
timestamp 2015-03-27T14:47:09.057Z
vip_member_price 5.25

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=furniture&catB=tables-drawing-boards&CatC=art-tables&gr=alvin-craftmaster-hobby-station.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200029004
barcode_type UPC
col1 black
col1_sortorder 402
col2 gallon
col2_sortorder 2486
col3 [empty string]
color_swatch 0-0-0.jpg
cost 10.92
deal_of_the_week NO
description black, gallon
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 70064
list_price 32.79
map NO
mfr_num 2900
net_weight 9.1
non_member_discount 40
non_member_price 19.67
prop65 NO
ship_rule_desc STD
shipping STD
sku 70064
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.13
ta_dealer_c_price 12.13
ta_price 18.03
text
array
1 70064
2 2900
3 black, gallon
timestamp 2015-03-27T14:47:55.862Z
vip_member_price 16.4

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=furniture&catB=tables-drawing-boards&CatC=art-tables&gr=alvin-craftmaster-hobby-station.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200024016
barcode_type UPC
col1 blue
col1_sortorder 542
col2 16.9 oz.
col2_sortorder 1019
col3 [empty string]
color_swatch 0-0-164.jpg
cost 2.07
deal_of_the_week NO
description blue, 16.9 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 14115
list_price 5.66
map NO
mfr_num 2401
net_weight 1.2
non_member_discount 40
non_member_price 3.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 14115
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.26
ta_dealer_c_price 2.26
ta_price 3.4
text
array
1 14115
2 2401
3 blue, 16.9 oz.
timestamp 2015-03-27T14:46:30.049Z
vip_member_price 2.83

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=furniture&catB=tables-drawing-boards&CatC=art-tables&gr=alvin-craftmaster-hobby-station.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200020018
barcode_type UPC
col1 blue
col1_sortorder 542
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 0-0-164.jpg
cost 0.7
deal_of_the_week NO
description blue, 2 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 24683
list_price 2.32
map NO
mfr_num 2001
net_weight 0.16
non_member_discount 40
non_member_price 1.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 24683
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.81
ta_dealer_c_price 0.81
ta_price 1.21
text
array
1 24683
2 2001
3 blue, 2 oz.
timestamp 2015-03-27T14:46:45.999Z
vip_member_price 1.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=furniture&catB=tables-drawing-boards&CatC=art-tables&gr=alvin-craftmaster-hobby-station.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200022012
barcode_type UPC
col1 blue
col1_sortorder 542
col2 8 oz.
col2_sortorder 2317
col3 [empty string]
color_swatch 0-0-164.jpg
cost 1.27
deal_of_the_week NO
description blue, 8 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 42156
list_price 4
map NO
mfr_num 2201
net_weight 0.74
non_member_discount 40
non_member_price 2.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 42156
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.08
text
array
1 42156
2 2201
3 blue, 8 oz.
timestamp 2015-03-27T14:47:14.62Z
vip_member_price 2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=furniture&catB=tables-drawing-boards&CatC=art-tables&gr=alvin-craftmaster-hobby-station.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200024023
barcode_type UPC
col1 brown
col1_sortorder 798
col2 16.9 oz.
col2_sortorder 1019
col3 [empty string]
color_swatch 119-60-0.jpg
cost 2.07
deal_of_the_week NO
description brown, 16.9 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 55946
list_price 5.66
map NO
mfr_num 2402
net_weight 1.2
non_member_discount 40
non_member_price 3.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 55946
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.26
ta_dealer_c_price 2.26
ta_price 3.4
text
array
1 55946
2 2402
3 brown, 16.9 oz.
timestamp 2015-03-27T14:47:30.847Z
vip_member_price 2.83

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=furniture&catB=tables-drawing-boards&CatC=art-tables&gr=alvin-craftmaster-hobby-station.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200020025
barcode_type UPC
col1 brown
col1_sortorder 798
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 119-60-0.jpg
cost 0.7
deal_of_the_week NO
description brown, 2 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 83981
list_price 2.32
map NO
mfr_num 2002
net_weight 0.16
non_member_discount 40
non_member_price 1.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 83981
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.81
ta_dealer_c_price 0.81
ta_price 1.21
text
array
1 83981
2 2002
3 brown, 2 oz.
timestamp 2015-03-27T14:48:14.326Z
vip_member_price 1.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=furniture&catB=tables-drawing-boards&CatC=art-tables&gr=alvin-craftmaster-hobby-station.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200022029
barcode_type UPC
col1 brown
col1_sortorder 798
col2 8 oz.
col2_sortorder 2317
col3 [empty string]
color_swatch 119-60-0.jpg
cost 1.27
deal_of_the_week NO
description brown, 8 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 87224
list_price 4
map NO
mfr_num 2202
net_weight 0.74
non_member_discount 40
non_member_price 2.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 87224
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.08
text
array
1 87224
2 2202
3 brown, 8 oz.
timestamp 2015-03-27T14:48:19.237Z
vip_member_price 2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=furniture&catB=tables-drawing-boards&CatC=art-tables&gr=alvin-craftmaster-hobby-station.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200026027
barcode_type UPC
col1 brown
col1_sortorder 798
col2 32 oz.
col2_sortorder 1660
col3 [empty string]
color_swatch 119-60-0.jpg
cost 3.44
deal_of_the_week NO
description brown, 32 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 87900
list_price 10.46
map NO
mfr_num 2602
net_weight 2.32
non_member_discount 40
non_member_price 6.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 87900
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.77
ta_dealer_c_price 3.77
ta_price 5.65
text
array
1 87900
2 2602
3 brown, 32 oz.
timestamp 2015-03-27T14:48:20.593Z
vip_member_price 5.23

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=furniture&catB=tables-drawing-boards&CatC=art-tables&gr=alvin-craftmaster-hobby-station.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200022142
barcode_type UPC
col1 fluorescent blue
col1_sortorder 2210
col2 8 oz.
col2_sortorder 2317
col3 [empty string]
color_swatch 0-86-255.jpg
cost 1.65
deal_of_the_week NO
description fluorescent blue, 8 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 43924
list_price 4.93
map NO
mfr_num 2214
net_weight 0.74
non_member_discount 40
non_member_price 2.96
prop65 NO
ship_rule_desc STD
shipping STD
sku 43924
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.73
ta_dealer_c_price 1.73
ta_price 2.56
text
array
1 43924
2 2214
3 fluorescent blue, 8 oz.
timestamp 2015-03-27T14:47:16.463Z
vip_member_price 2.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=furniture&catB=tables-drawing-boards&CatC=art-tables&gr=alvin-craftmaster-hobby-station.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200020148
barcode_type UPC
col1 fluorescent blue
col1_sortorder 2210
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 0-86-255.jpg
cost 0.92
deal_of_the_week NO
description fluorescent blue, 2 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 70900
list_price 2.87
map NO
mfr_num 2014
net_weight 0.16
non_member_discount 40
non_member_price 1.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 70900
sku_pix YES
supplier_id 1
ta_dealer_a_price 1
ta_dealer_c_price 1
ta_price 1.49
text
array
1 70900
2 2014
3 fluorescent blue, 2 oz.
timestamp 2015-03-27T14:47:58.09Z
vip_member_price 1.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=furniture&catB=tables-drawing-boards&CatC=art-tables&gr=alvin-craftmaster-hobby-station.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200024146
barcode_type UPC
col1 fluorescent blue
col1_sortorder 2210
col2 16.9 oz.
col2_sortorder 1019
col3 [empty string]
color_swatch 0-86-255.jpg
cost 3.09
deal_of_the_week NO
description fluorescent blue, 16.9 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 80888
list_price 7.52
map NO
mfr_num 2414
net_weight 1.3
non_member_discount 40
non_member_price 4.51
prop65 NO
ship_rule_desc STD
shipping STD
sku 80888
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.38
ta_dealer_c_price 3.38
ta_price 4.89
text
array
1 80888
2 2414
3 fluorescent blue, 16.9 oz.
timestamp 2015-03-27T14:48:11.623Z
vip_member_price 3.76

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=furniture&catB=tables-drawing-boards&CatC=art-tables&gr=alvin-craftmaster-hobby-station.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200022159
barcode_type UPC
col1 fluorescent green
col1_sortorder 2215
col2 8 oz.
col2_sortorder 2317
col3 [empty string]
color_swatch 177-210-77.jpg
cost 1.65
deal_of_the_week NO
description fluorescent green, 8 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 26979
list_price 4.93
map NO
mfr_num 2215
net_weight 0.74
non_member_discount 40
non_member_price 2.96
prop65 NO
ship_rule_desc STD
shipping STD
sku 26979
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.73
ta_dealer_c_price 1.73
ta_price 2.56
text
array
1 26979
2 2215
3 fluorescent green, 8 oz.
timestamp 2015-03-27T14:46:49.961Z
vip_member_price 2.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=furniture&catB=tables-drawing-boards&CatC=art-tables&gr=alvin-craftmaster-hobby-station.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200024153
barcode_type UPC
col1 fluorescent green
col1_sortorder 2215
col2 16.9 oz.
col2_sortorder 1019
col3 [empty string]
color_swatch 177-210-77.jpg
cost 3.09
deal_of_the_week NO
description fluorescent green, 16.9 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 47508
list_price 7.52
map NO
mfr_num 2415
net_weight 1.3
non_member_discount 40
non_member_price 4.51
prop65 NO
ship_rule_desc STD
shipping STD
sku 47508
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.38
ta_dealer_c_price 3.38
ta_price 4.89
text
array
1 47508
2 2415
3 fluorescent green, 16.9 oz.
timestamp 2015-03-27T14:47:21.683Z
vip_member_price 3.76

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=furniture&catB=tables-drawing-boards&CatC=art-tables&gr=alvin-craftmaster-hobby-station.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200020155
barcode_type UPC
col1 fluorescent green
col1_sortorder 2215
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 177-210-77.jpg
cost 0.92
deal_of_the_week NO
description fluorescent green, 2 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 54701
list_price 2.87
map NO
mfr_num 2015
net_weight 0.16
non_member_discount 40
non_member_price 1.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 54701
sku_pix YES
supplier_id 1
ta_dealer_a_price 1
ta_dealer_c_price 1
ta_price 1.49
text
array
1 54701
2 2015
3 fluorescent green, 2 oz.
timestamp 2015-03-27T14:47:29.256Z
vip_member_price 1.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=furniture&catB=tables-drawing-boards&CatC=art-tables&gr=alvin-craftmaster-hobby-station.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200020162
barcode_type UPC
col1 fluorescent orange
col1_sortorder 2221
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 255-173-77.jpg
cost 0.92
deal_of_the_week NO
description fluorescent orange, 2 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 15224
list_price 2.87
map NO
mfr_num 2016
net_weight 0.16
non_member_discount 40
non_member_price 1.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 15224
sku_pix YES
supplier_id 1
ta_dealer_a_price 1
ta_dealer_c_price 1
ta_price 1.49
text
array
1 15224
2 2016
3 fluorescent orange, 2 oz.
timestamp 2015-03-27T14:46:33.895Z
vip_member_price 1.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=furniture&catB=tables-drawing-boards&CatC=art-tables&gr=alvin-craftmaster-hobby-station.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200024160
barcode_type UPC
col1 fluorescent orange
col1_sortorder 2221
col2 16.9 oz.
col2_sortorder 1019
col3 [empty string]
color_swatch 255-173-77.jpg
cost 3.09
deal_of_the_week NO
description fluorescent orange, 16.9 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 30989
list_price 7.52
map NO
mfr_num 2416
net_weight 1.3
non_member_discount 40
non_member_price 4.51
prop65 NO
ship_rule_desc STD
shipping STD
sku 30989
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.38
ta_dealer_c_price 3.38
ta_price 4.89
text
array
1 30989
2 2416
3 fluorescent orange, 16.9 oz.
timestamp 2015-03-27T14:46:56.005Z
vip_member_price 3.76

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=furniture&catB=tables-drawing-boards&CatC=art-tables&gr=alvin-craftmaster-hobby-station.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200022166
barcode_type UPC
col1 fluorescent orange
col1_sortorder 2221
col2 8 oz.
col2_sortorder 2317
col3 [empty string]
color_swatch 255-173-77.jpg
cost 1.65
deal_of_the_week NO
description fluorescent orange, 8 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 53729
list_price 4.93
map NO
mfr_num 2216
net_weight 0.74
non_member_discount 40
non_member_price 2.96
prop65 NO
ship_rule_desc STD
shipping STD
sku 53729
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.73
ta_dealer_c_price 1.73
ta_price 2.56
text
array
1 53729
2 2216
3 fluorescent orange, 8 oz.
timestamp 2015-03-27T14:47:28.673Z
vip_member_price 2.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:50'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=canvas-boards&gr=fredrix-archival-watercolor-canvas-board.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200024184
barcode_type UPC
col1 fluorescent pink (violet)
col1_sortorder 2223
col2 16.9 oz.
col2_sortorder 1019
col3 [empty string]
color_swatch 185-77-210.jpg
cost 3.09
deal_of_the_week NO
description fluorescent pink (violet), 16.9 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 52825
list_price 7.52
map NO
mfr_num 2418
net_weight 1.3
non_member_discount 40
non_member_price 4.51
prop65 NO
ship_rule_desc STD
shipping STD
sku 52825
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.38
ta_dealer_c_price 3.38
ta_price 4.89
text
array
1 52825
2 2418
3 fluorescent pink (violet), 16.9 oz.
timestamp 2015-03-27T14:47:28.125Z
vip_member_price 3.76

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:50'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=canvas-boards&gr=fredrix-archival-watercolor-canvas-board.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200020186
barcode_type UPC
col1 fluorescent pink (violet)
col1_sortorder 2223
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 185-77-210.jpg
cost 0.92
deal_of_the_week NO
description fluorescent pink (violet), 2 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 62751
list_price 2.87
map NO
mfr_num 2018
net_weight 0.16
non_member_discount 40
non_member_price 1.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 62751
sku_pix YES
supplier_id 1
ta_dealer_a_price 1
ta_dealer_c_price 1
ta_price 1.49
text
array
1 62751
2 2018
3 fluorescent pink (violet), 2 oz.
timestamp 2015-03-27T14:47:42.459Z
vip_member_price 1.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:50'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=canvas-boards&gr=fredrix-archival-watercolor-canvas-board.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200022180
barcode_type UPC
col1 fluorescent pink (violet)
col1_sortorder 2223
col2 8 oz.
col2_sortorder 2317
col3 [empty string]
color_swatch 185-77-210.jpg
cost 1.65
deal_of_the_week NO
description fluorescent pink (violet), 8 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 85000
list_price 4.93
map NO
mfr_num 2218
net_weight 0.74
non_member_discount 40
non_member_price 2.96
prop65 NO
ship_rule_desc STD
shipping STD
sku 85000
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.73
ta_dealer_c_price 1.73
ta_price 2.56
text
array
1 85000
2 2218
3 fluorescent pink (violet), 8 oz.
timestamp 2015-03-27T14:48:15.014Z
vip_member_price 2.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:50'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=canvas-boards&gr=fredrix-archival-watercolor-canvas-board.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200024177
barcode_type UPC
col1 fluorescent red
col1_sortorder 2225
col2 16.9 oz.
col2_sortorder 1019
col3 [empty string]
color_swatch 240-47-47.jpg
cost 3.09
deal_of_the_week NO
description fluorescent red, 16.9 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 34499
list_price 7.52
map NO
mfr_num 2417
net_weight 1.3
non_member_discount 40
non_member_price 4.51
prop65 NO
ship_rule_desc STD
shipping STD
sku 34499
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.38
ta_dealer_c_price 3.38
ta_price 4.89
text
array
1 34499
2 2417
3 fluorescent red, 16.9 oz.
timestamp 2015-03-27T14:47:04.835Z
vip_member_price 3.76

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:50'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=canvas-boards&gr=fredrix-archival-watercolor-canvas-board.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200020179
barcode_type UPC
col1 fluorescent red
col1_sortorder 2225
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 240-47-47.jpg
cost 0.92
deal_of_the_week NO
description fluorescent red, 2 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 74147
list_price 2.87
map NO
mfr_num 2017
net_weight 0.16
non_member_discount 40
non_member_price 1.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 74147
sku_pix YES
supplier_id 1
ta_dealer_a_price 1
ta_dealer_c_price 1
ta_price 1.49
text
array
1 74147
2 2017
3 fluorescent red, 2 oz.
timestamp 2015-03-27T14:48:04.522Z
vip_member_price 1.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:50'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=canvas-boards&gr=fredrix-archival-watercolor-canvas-board.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200022173
barcode_type UPC
col1 fluorescent red
col1_sortorder 2225
col2 8 oz.
col2_sortorder 2317
col3 [empty string]
color_swatch 240-47-47.jpg
cost 1.65
deal_of_the_week NO
description fluorescent red, 8 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 77980
list_price 4.93
map NO
mfr_num 2217
net_weight 0.74
non_member_discount 40
non_member_price 2.96
prop65 NO
ship_rule_desc STD
shipping STD
sku 77980
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.73
ta_dealer_c_price 1.73
ta_price 2.56
text
array
1 77980
2 2217
3 fluorescent red, 8 oz.
timestamp 2015-03-27T14:48:07.664Z
vip_member_price 2.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:50'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=canvas-boards&gr=fredrix-archival-watercolor-canvas-board.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200024191
barcode_type UPC
col1 fluorescent yellow
col1_sortorder 2233
col2 16.9 oz.
col2_sortorder 1019
col3 [empty string]
color_swatch 240-226-47.jpg
cost 3.09
deal_of_the_week NO
description fluorescent yellow, 16.9 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 22209
list_price 7.52
map NO
mfr_num 2419
net_weight 1.3
non_member_discount 40
non_member_price 4.51
prop65 NO
ship_rule_desc STD
shipping STD
sku 22209
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.38
ta_dealer_c_price 3.38
ta_price 4.89
text
array
1 22209
2 2419
3 fluorescent yellow, 16.9 oz.
timestamp 2015-03-27T14:46:43.151Z
vip_member_price 3.76

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:50'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=canvas-boards&gr=fredrix-archival-watercolor-canvas-board.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200020193
barcode_type UPC
col1 fluorescent yellow
col1_sortorder 2233
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 240-226-47.jpg
cost 0.92
deal_of_the_week NO
description fluorescent yellow, 2 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 25397
list_price 2.87
map NO
mfr_num 2019
net_weight 0.16
non_member_discount 40
non_member_price 1.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 25397
sku_pix YES
supplier_id 1
ta_dealer_a_price 1
ta_dealer_c_price 1
ta_price 1.49
text
array
1 25397
2 2019
3 fluorescent yellow, 2 oz.
timestamp 2015-03-27T14:46:47.077Z
vip_member_price 1.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:50'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=canvas-boards&gr=fredrix-archival-watercolor-canvas-board.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200022197
barcode_type UPC
col1 fluorescent yellow
col1_sortorder 2233
col2 8 oz.
col2_sortorder 2317
col3 [empty string]
color_swatch 240-226-47.jpg
cost 1.65
deal_of_the_week NO
description fluorescent yellow, 8 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 81873
list_price 4.93
map NO
mfr_num 2219
net_weight 0.74
non_member_discount 40
non_member_price 2.96
prop65 NO
ship_rule_desc STD
shipping STD
sku 81873
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.73
ta_dealer_c_price 1.73
ta_price 2.56
text
array
1 81873
2 2219
3 fluorescent yellow, 8 oz.
timestamp 2015-03-27T14:48:12.628Z
vip_member_price 2.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:50'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=canvas-boards&gr=fredrix-archival-watercolor-canvas-board.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200020032
barcode_type UPC
col1 green
col1_sortorder 2621
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 0-164-123.jpg
cost 0.7
deal_of_the_week NO
description green, 2 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 26029
list_price 2.32
map NO
mfr_num 2003
net_weight 0.16
non_member_discount 40
non_member_price 1.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 26029
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.81
ta_dealer_c_price 0.81
ta_price 1.21
text
array
1 26029
2 2003
3 green, 2 oz.
timestamp 2015-03-27T14:46:47.973Z
vip_member_price 1.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:50'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=canvas-boards&gr=fredrix-archival-watercolor-canvas-board.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:49'}
sessionid e030358fd02cc0530c60353415247e274d4c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29883972&CFTOKEN=56097357&jsessionid=e030358fd02cc0530c60353415247e274d4c
validationerror [empty string]


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

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

ItemIDList: 40973
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 50
barcode 092200022036
barcode_type UPC
col1 green
col1_sortorder 2621
col2 8 oz.
col2_sortorder 2317
col3 [empty string]
color_swatch 0-164-123.jpg
cost 1.27
deal_of_the_week NO
description green, 8 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 37845
list_price 4
map NO
mfr_num 2203
net_weight 0.74
non_member_discount 40
non_member_price 2.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 37845
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.08
text
array
1 37845
2 2203
3 green, 8 oz.
timestamp 2015-03-27T14:47:09.866Z
vip_member_price 2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 40973
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] = '3884' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~chroma-inc-~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 05:27:50'}
sessionid e03026dbab6ba089f38f51261e3d3e1a8075
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=canvas&catB=canvas-boards&gr=fredrix-archival-watercolor-canvas-board.html
urltoken CFID=29883971&CFTOKEN=14524325&jsessionid=e03026dbab6ba089f38f51261e3d3e1a8075
validationerror [empty string]


EndSessionVariables: