Added
false
266
0
Active/Web Listing Count By Category
select category
, ISNULL((Select Count(ListingID) From Listing Where ListingCategory.CategoryID = Listing.CategoryID And Active = 1 and WebListing = 1),0) As ListingCount
from ListingCategory
order by ListingCount Desc
2017-08-01T13:28:17
2017-08-01T13:28:17
jon.massy
Profile_View
true
0
false
Unchanged
false
0
0
false
Daily
1
1
false
2017-08-01T00:00:00-05:00
2017-08-01T00:00:00-05:00
false
false
0
Unchanged
false
0
0
1900-01-01T00:00:00
1900-01-01T00:00:00
0
false
0
false
1900-01-01T00:00:00
1900-01-01T00:00:00
0
0
false
false
false
0
Unchanged
false
0
0
1900-01-01T00:00:00
1900-01-01T00:00:00
0
false
0
false
1900-01-01T00:00:00
1900-01-01T00:00:00
0
0
false
false
Added
false
Profile_View
ProfileAddress_BillingAddress1
Billing Address 1
System.String
300
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2017-08-01T00:00:00-05:00
0
0
Ascending
AndJoin
1