Google Maps Platform 2024


Please login or register to vote for this query.

(click on this box to dismiss)

TeX Meta

Q&A about the site for users of TeX, LaTeX, ConTeXt, and related typesetting systems

select i.Id, i.CreationDate, i.Title, i.Tags, i.AcceptedAnswerId, i.Score, 
   i.Reputation, i.ViewCount, i.AnswerCount, i.CommentCount, i.ClosedDate,
   i.Link, '' AS Status 

from (

Select Distinct p.Id, p.CreationDate, p.Title, p.Tags, p.AcceptedAnswerId, p.Score, 
   p.ViewCount, p.AnswerCount, p.CommentCount, p.ClosedDate,
   CONCAT('', p.Id) as Link, u.Reputation
From Posts p 
 Inner Join PostTags pt on p.Id = Pt.PostId
 Inner Join Tags t on pt.TagId = t.Id
 Inner Join Users u On p.OwnerUserId = u.Id
 Where t.TagName in ('google-maps-api-3','google-maps', 'google-maps-api', 'google-places-api', 'google-static-maps', 'google-street-view', 'google-geocoding-api', 'google-direction', 'google-distancematrix-api', 'google-maps-android-api-2', 'google-maps-sdk-ios', 'Google-maps-mobile', 'google-maps-embed', 'google-geolocation', 'google-maps-timezone', 'google-elevation-api', 'google-roads-api')
And p.CreationDate >= '2024-03-01'
And p.CreationDate <= '2024-03-07'
And p.PostTypeId = 1  -- Question
And p.ClosedDate is NULL -- Not closed questions

-- ) i; -- All
) i Where i.AnswerCount = 0 -- No answer
And i.Score >= 0
-- ) i Where i.AnswerCount = 0 and i.CommentCount > 0; -- No answer, but comment
-- ) i Where i.Score <= 0; -- Non-positive score
Order by i.Score desc, i.Reputation desc, i.CreationDate desc;

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results