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

Airbrush Colors

by Createx


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893454031
barcode_type UPC
col1 fluorescent blue
col1_sortorder 2215
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 47-143-240.jpg
cost 3.86
deal_of_the_week NO
description fluorescent blue, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 54503
list_price 7.02
map NO
mfr_num 5403-04
net_weight 0.32
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 54503
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 54503
2 5403-04
3 fluorescent blue, 4 oz.
timestamp 2015-03-31T17:53:47.722Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893454048
barcode_type UPC
col1 fluorescent green
col1_sortorder 2220
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 168-210-168.jpg
cost 3.86
deal_of_the_week NO
description fluorescent green, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 71424
list_price 7.02
map NO
mfr_num 5404-04
net_weight 0.32
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 71424
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 71424
2 5404-04
3 fluorescent green, 4 oz.
timestamp 2015-03-31T17:54:21.163Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893454062
barcode_type UPC
col1 fluorescent magenta
col1_sortorder 2225
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 255-0-130.jpg
cost 3.86
deal_of_the_week NO
description fluorescent magenta, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 47850
list_price 7.02
map NO
mfr_num 5406-04
net_weight 0.32
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 47850
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 47850
2 5406-04
3 fluorescent magenta, 4 oz.
timestamp 2015-03-31T17:53:33.938Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893454093
barcode_type UPC
col1 fluorescent orange
col1_sortorder 2226
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 255-173-77.jpg
cost 3.86
deal_of_the_week NO
description fluorescent orange, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 57554
list_price 7.02
map NO
mfr_num 5409-04
net_weight 0.32
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 57554
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 57554
2 5409-04
3 fluorescent orange, 4 oz.
timestamp 2015-03-31T17:53:51.484Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893454079
barcode_type UPC
col1 fluorescent pink
col1_sortorder 2227
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 240-47-132.jpg
cost 3.86
deal_of_the_week NO
description fluorescent pink, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 43444
list_price 7.02
map NO
mfr_num 5407-04
net_weight 0.32
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 43444
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 43444
2 5407-04
3 fluorescent pink, 4 oz.
timestamp 2015-03-31T17:53:28.189Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893454024
barcode_type UPC
col1 fluorescent raspberry
col1_sortorder 2229
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 210-0-139.jpg
cost 3.86
deal_of_the_week NO
description fluorescent raspberry, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 84320
list_price 7.02
map NO
mfr_num 5402-04
net_weight 0.32
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 84320
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 84320
2 5402-04
3 fluorescent raspberry, 4 oz.
timestamp 2015-03-31T17:54:38.015Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893454086
barcode_type UPC
col1 fluorescent red
col1_sortorder 2230
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 255-0-196.jpg
cost 3.86
deal_of_the_week NO
description fluorescent red, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 10416
list_price 7.02
map NO
mfr_num 5408-04
net_weight 0.32
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 10416
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 10416
2 5408-04
3 fluorescent red, 4 oz.
timestamp 2015-03-31T17:52:35.433Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893454109
barcode_type UPC
col1 fluorescent sunburst
col1_sortorder 2231
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 210-121-77.jpg
cost 3.86
deal_of_the_week NO
description fluorescent sunburst, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 23335
list_price 7.02
map NO
mfr_num 5410-04
net_weight 0.32
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 23335
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 23335
2 5410-04
3 fluorescent sunburst, 4 oz.
timestamp 2015-03-31T17:52:59.158Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893454017
barcode_type UPC
col1 fluorescent violet
col1_sortorder 2235
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 210-0-210.jpg
cost 3.86
deal_of_the_week NO
description fluorescent violet, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 40244
list_price 7.02
map NO
mfr_num 5401-04
net_weight 0.32
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 40244
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 40244
2 5401-04
3 fluorescent violet, 4 oz.
timestamp 2015-03-31T17:53:23.994Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893454055
barcode_type UPC
col1 fluorescent yellow
col1_sortorder 2238
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 240-233-138.jpg
cost 3.86
deal_of_the_week NO
description fluorescent yellow, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 23650
list_price 7.02
map NO
mfr_num 5405-04
net_weight 0.32
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 23650
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 23650
2 5405-04
3 fluorescent yellow, 4 oz.
timestamp 2015-03-31T17:52:59.445Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893455052
barcode_type UPC
col1 iridescent electric blue
col1_sortorder 3029
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 0-75-210.jpg
cost 6.2
deal_of_the_week NO
description iridescent electric blue, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 59722
list_price 11.28
map NO
mfr_num 5505-04
net_weight 0.32
non_member_discount 24
non_member_price 8.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 59722
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.77
ta_dealer_c_price 6.43
ta_price 10.16
text
array
1 59722
2 5505-04
3 iridescent electric blue, 4 oz.
timestamp 2015-03-31T17:53:53.99Z
vip_member_price 7.73

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893455083
barcode_type UPC
col1 iridescent fuchsia
col1_sortorder 3030
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 240-47-163.jpg
cost 6.2
deal_of_the_week NO
description iridescent fuchsia, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 36694
list_price 11.28
map NO
mfr_num 5508-04
net_weight 0.32
non_member_discount 24
non_member_price 8.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 36694
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.77
ta_dealer_c_price 6.43
ta_price 10.16
text
array
1 36694
2 5508-04
3 iridescent fuchsia, 4 oz.
timestamp 2015-03-31T17:53:19.471Z
vip_member_price 7.73

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893455076
barcode_type UPC
col1 iridescent green
col1_sortorder 3039
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 47-240-107.jpg
cost 6.2
deal_of_the_week NO
description iridescent green, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 42979
list_price 11.28
map NO
mfr_num 5507-04
net_weight 0.62
non_member_discount 24
non_member_price 8.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 42979
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.77
ta_dealer_c_price 6.43
ta_price 10.16
text
array
1 42979
2 5507-04
3 iridescent green, 4 oz.
timestamp 2015-03-31T17:53:27.267Z
vip_member_price 7.73

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893455014
barcode_type UPC
col1 iridescent red
col1_sortorder 3059
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 255-0-82.jpg
cost 6.2
deal_of_the_week NO
description iridescent red, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 15584
list_price 11.28
map NO
mfr_num 5501-04
net_weight 0.32
non_member_discount 24
non_member_price 8.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 15584
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.77
ta_dealer_c_price 6.43
ta_price 10.16
text
array
1 15584
2 5501-04
3 iridescent red, 4 oz.
timestamp 2015-03-31T17:52:46.685Z
vip_member_price 7.73

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893455021
barcode_type UPC
col1 iridescent scarlet
col1_sortorder 3071
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 255-111-77.jpg
cost 6.2
deal_of_the_week NO
description iridescent scarlet, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 84563
list_price 11.28
map NO
mfr_num 5502-04
net_weight 0.32
non_member_discount 24
non_member_price 8.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 84563
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.77
ta_dealer_c_price 6.43
ta_price 10.16
text
array
1 84563
2 5502-04
3 iridescent scarlet, 4 oz.
timestamp 2015-03-31T17:54:38.307Z
vip_member_price 7.73

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893455045
barcode_type UPC
col1 iridescent turquoise
col1_sortorder 3079
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 77-210-210.jpg
cost 6.2
deal_of_the_week NO
description iridescent turquoise, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 71547
list_price 11.28
map NO
mfr_num 5504-04
net_weight 0.32
non_member_discount 24
non_member_price 8.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 71547
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.77
ta_dealer_c_price 6.43
ta_price 10.16
text
array
1 71547
2 5504-04
3 iridescent turquoise, 4 oz.
timestamp 2015-03-31T17:54:21.497Z
vip_member_price 7.73

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893455069
barcode_type UPC
col1 iridescent violet
col1_sortorder 3080
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 114-0-164.jpg
cost 6.2
deal_of_the_week NO
description iridescent violet, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 65695
list_price 11.28
map NO
mfr_num 5506-04
net_weight 0.32
non_member_discount 24
non_member_price 8.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 65695
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.77
ta_dealer_c_price 6.43
ta_price 10.16
text
array
1 65695
2 5506-04
3 iridescent violet, 4 oz.
timestamp 2015-03-31T17:54:09.195Z
vip_member_price 7.73

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893455038
barcode_type UPC
col1 iridescent yellow
col1_sortorder 3083
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 255-255-77.jpg
cost 6.2
deal_of_the_week NO
description iridescent yellow, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 29577
list_price 11.28
map NO
mfr_num 5503-04
net_weight 0.32
non_member_discount 24
non_member_price 8.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 29577
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.77
ta_dealer_c_price 6.43
ta_price 10.16
text
array
1 29577
2 5503-04
3 iridescent yellow, 4 oz.
timestamp 2015-03-31T17:53:07.085Z
vip_member_price 7.73

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893452068
barcode_type UPC
col1 opaque aqua
col1_sortorder 4193
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 92-214-240.jpg
cost 3.86
deal_of_the_week NO
description opaque aqua, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 15106
list_price 7.02
map NO
mfr_num 5206-04
net_weight 0.32
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 15106
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 15106
2 5206-04
3 opaque aqua, 4 oz.
timestamp 2015-03-31T17:52:45.566Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893452112
barcode_type UPC
col1 opaque black
col1_sortorder 4195
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 0-0-0.jpg
cost 3.86
deal_of_the_week NO
description opaque black, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 22729
list_price 7.02
map NO
mfr_num 5211-04
net_weight 0.32
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 22729
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 22729
2 5211-04
3 opaque black, 4 oz.
timestamp 2015-03-31T17:52:58.25Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 717893652116
barcode_type UPC
col1 opaque black
col1_sortorder 4195
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 0-0-0.jpg
cost 13.87
deal_of_the_week NO
description opaque black, 16 oz.
group_id 1492
group_uname createx-airbrush-colors
id 40754
list_price 25.27
map NO
mfr_num 5211-16
net_weight 1.22
non_member_discount 31
non_member_price 16.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 40754
sku_pix YES
supplier_id 1
ta_dealer_a_price 15.16
ta_dealer_c_price 14.4
ta_price 22.74
text
array
1 40754
2 5211-16
3 opaque black, 16 oz.
timestamp 2015-03-31T17:53:24.269Z
vip_member_price 15.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893452013
barcode_type UPC
col1 opaque blue
col1_sortorder 4196
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 0-0-210.jpg
cost 3.86
deal_of_the_week NO
description opaque blue, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 46705
list_price 7.02
map NO
mfr_num 5201-04
net_weight 0.32
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 46705
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 46705
2 5201-04
3 opaque blue, 4 oz.
timestamp 2015-03-31T17:53:32.116Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893452082
barcode_type UPC
col1 opaque coral
col1_sortorder 4201
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 255-74-0.jpg
cost 3.86
deal_of_the_week NO
description opaque coral, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 79001
list_price 7.02
map NO
mfr_num 5208-04
net_weight 0.32
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 79001
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 79001
2 5208-04
3 opaque coral, 4 oz.
timestamp 2015-03-31T17:54:31.841Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893452051
barcode_type UPC
col1 opaque light green
col1_sortorder 4204
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 100-195-47.jpg
cost 3.86
deal_of_the_week NO
description opaque light green, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 44431
list_price 7.02
map NO
mfr_num 5205-04
net_weight 0.32
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 44431
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 44431
2 5205-04
3 opaque light green, 4 oz.
timestamp 2015-03-31T17:53:29.705Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893452037
barcode_type UPC
col1 opaque lilac
col1_sortorder 4205
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 177-168-210.jpg
cost 3.86
deal_of_the_week NO
description opaque lilac, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 57809
list_price 7.02
map NO
mfr_num 5203-04
net_weight 0.32
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 57809
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 57809
2 5203-04
3 opaque lilac, 4 oz.
timestamp 2015-03-31T17:53:51.644Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893452020
barcode_type UPC
col1 opaque purple
col1_sortorder 4210
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 86-0-119.jpg
cost 3.86
deal_of_the_week NO
description opaque purple, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 30603
list_price 7.02
map NO
mfr_num 5202-04
net_weight 0.32
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 30603
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 30603
2 5202-04
3 opaque purple, 4 oz.
timestamp 2015-03-31T17:53:08.836Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893452105
barcode_type UPC
col1 opaque red
col1_sortorder 4211
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 210-0-0.jpg
cost 3.86
deal_of_the_week NO
description opaque red, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 75991
list_price 7.02
map NO
mfr_num 5210-04
net_weight 0.32
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 75991
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 75991
2 5210-04
3 opaque red, 4 oz.
timestamp 2015-03-31T17:54:28.17Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893452075
barcode_type UPC
col1 opaque sky blue
col1_sortorder 4213
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 0-143-255.jpg
cost 3.86
deal_of_the_week NO
description opaque sky blue, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 85255
list_price 7.02
map NO
mfr_num 5207-04
net_weight 0.32
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 85255
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 85255
2 5207-04
3 opaque sky blue, 4 oz.
timestamp 2015-03-31T17:54:38.873Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893452129
barcode_type UPC
col1 opaque white
col1_sortorder 4216
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 255-255-255.jpg
cost 3.86
deal_of_the_week NO
description opaque white, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 62168
list_price 7.02
map NO
mfr_num 5212-04
net_weight 0.2
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 62168
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 62168
2 5212-04
3 opaque white, 4 oz.
timestamp 2015-03-31T17:54:02.639Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 36
barcode 717893652123
barcode_type UPC
col1 opaque white
col1_sortorder 4216
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 255-255-255.jpg
cost 13.87
deal_of_the_week NO
description opaque white, 16 oz.
group_id 1492
group_uname createx-airbrush-colors
id 65475
list_price 25.27
map NO
mfr_num 5212-16
net_weight 1.22
non_member_discount 31
non_member_price 16.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 65475
sku_pix YES
supplier_id 1
ta_dealer_a_price 15.16
ta_dealer_c_price 14.4
ta_price 22.74
text
array
1 65475
2 5212-16
3 opaque white, 16 oz.
timestamp 2015-03-31T17:54:08.948Z
vip_member_price 15.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893452044
barcode_type UPC
col1 opaque yellow
col1_sortorder 4217
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 255-255-0.jpg
cost 3.86
deal_of_the_week NO
description opaque yellow, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 62564
list_price 7.02
map NO
mfr_num 5204-04
net_weight 0.32
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 62564
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 62564
2 5204-04
3 opaque yellow, 4 oz.
timestamp 2015-03-31T17:54:03.758Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030f76208946d7d433047215b6b261e6ee2
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html
urltoken CFID=30840579&CFTOKEN=55860240&jsessionid=e030f76208946d7d433047215b6b261e6ee2
validationerror [empty string]


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

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

ItemIDList: 31947
AvailQtyList: 16.000000000000

struct
FLAGS 0
VIP_member_discount 29
barcode 717893453041
barcode_type UPC
col1 pearl blue
col1_sortorder 4459
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 173-122-255.jpg
cost 3.86
deal_of_the_week NO
description pearl blue, 4 oz.
group_id 1492
group_uname createx-airbrush-colors
id 78570
list_price 7.02
map NO
mfr_num 5304-04
net_weight 0.32
non_member_discount 24
non_member_price 5.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 78570
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.21
ta_dealer_c_price 4
ta_price 6.32
text
array
1 78570
2 5304-04
3 pearl blue, 4 oz.
timestamp 2015-03-31T17:54:31.372Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 16.000000000000 31947
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1995' 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.211.236.52

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~createx~c1~airbrushing~&gr=createx-airbrush-colors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 16:22:42'}
sessionid e030cc6c22de01b786f54b24754382073597
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=tape&CatC=sort~1~&gr=3m-scrapbooking-tape.html
urltoken CFID=30840581&CFTOKEN=72107701&jsessionid=e030cc6c22de01b786f54b24754382073597
validationerror [empty string]


EndSessionVariables: