[11:53:57] <wm-bb>	 [telegram] <M> Hi 
[11:53:57] <wm-bb>	 [telegram] <M> Why haven't item timestamp
[11:53:59] <wm-bb>	 [telegram] <M> in each item in  this api ?
[11:54:00] <wm-bb>	 [telegram] <M> 
[11:54:02] <wm-bb>	 [telegram] <M> 
[11:54:03] <wm-bb>	 [telegram] <M> https://en.wikipedia.org/w/api.php?action=query&format=json&list=allpages&apfrom=jungle
[11:55:07] <wm-bb>	 [telegram] <M> I want filter by time
[12:01:40] <wm-bb>	 [telegram] <M> How do this ?
[12:10:42] <wm-bb>	 [telegram] <Thecladis> What timestamp do you expect to see there? (re @M: Hi 
[12:10:42] <wm-bb>	 [telegram] <Thecladis> Why haven't item timestamp
[12:10:44] <wm-bb>	 [telegram] <Thecladis> in each item in  this api ?
[12:10:45] <wm-bb>	 [telegram] <Thecladis> 
[12:10:47] <wm-bb>	 [telegram] <Thecladis> 
[12:10:48] <wm-bb>	 [telegram] <Thecladis> https://en.wikipedia.org/w/api.php?action=query&format=json&list=al...)
[18:32:29] <wm-bb>	 [telegram] <Yas1nazad7890> 🙋‍♀️🙋‍♀️🙋‍♀️
[18:32:31] <wm-bb>	 [telegram] <Yas1nazad7890> 💯The latest project of 2022!💯
[18:32:32] <wm-bb>	 [telegram] <Yas1nazad7890> 
[18:32:34] <wm-bb>	 [telegram] <Yas1nazad7890> 💎EARN FROM 10% UP TO 20% DAILY
[18:32:35] <wm-bb>	 [telegram] <Yas1nazad7890> 💎The longer the project exists, the more insurance!
[18:32:37] <wm-bb>	 [telegram] <Yas1nazad7890> 💎5 LEVELS OF REFERRAL REWARDS: (7%-3%-2%-1%-0,5%)
[18:32:38] <wm-bb>	 [telegram] <Yas1nazad7890> 💎Minimal deposit: 0.1 BNB
[18:32:40] <wm-bb>	 [telegram] <Yas1nazad7890> 
[18:32:41] <wm-bb>	 [telegram] <Yas1nazad7890> 🔥Insurance Tax (sent to the insurance balance): 10% from withdrawal
[18:32:43] <wm-bb>	 [telegram] <Yas1nazad7890> 🔥Automation reinvest: 10% from Withdrawal
[18:32:44] <wm-bb>	 [telegram] <Yas1nazad7890> 
[18:32:46] <wm-bb>	 [telegram] <Yas1nazad7890> AUTO insurance/Reinvest
[18:32:47] <wm-bb>	 [telegram] <Yas1nazad7890> 
[18:32:49] <wm-bb>	 [telegram] <Yas1nazad7890> 🚀🚀Investors can choose to either use Metamask, Trust Wallet or Binance Chain Walle🚀🚀
[18:32:50] <wm-bb>	 [telegram] <Yas1nazad7890> 
[18:32:52] <wm-bb>	 [telegram] <Yas1nazad7890> 🔥🔥🔥  @sjeoYeCGGM8448bot?start=217671
[20:40:21] <wm-bb>	 [telegram] <M> Date time for create page
[20:40:22] <wm-bb>	 [telegram] <M> Like as : 
[20:40:23] <wm-bb>	 [telegram] <M> 2019-09-08 13:45:65 (re @Thecladis: What timestamp do you expect to see there?)
[20:40:55] <wm-bb>	 [telegram] <M> or what is creator page ?
[20:42:27] <wm-bb>	 [telegram] <M> How to get date time and creator page from api ?
[20:44:58] <wm-bb>	 [telegram] <lucaswerkmeister> you can get the earliest revision of a single page with prop=revisions&rvdir=newer (https://en.wikipedia.org/w/api.php?action=query&format=json&prop=revisions&titles=Test&rvlimit=1&rvdir=newer) (API sandbox (https://en.wikipedia.org/wiki/Special:ApiSandbox#action=query&format=json&prop=revisions&titles=Test&rvlimit=1&rvdir=newer))
[20:45:05] <wm-bb>	 [telegram] <lucaswerkmeister> but that’s only allowed for a single page per API request
[20:45:33] <wm-bb>	 [telegram] <lucaswerkmeister> (on the other hand, it’s allowed to get the *newest* revision of several pages at once)
[20:46:31] <wm-bb>	 [telegram] <M> is it possible that i get list all pages with date time and creator? (re @lucaswerkmeister: you can get the earliest revision of a single page with prop=revisions&rvdir=newer (API sandbox))
[20:54:06] <wm-bb>	 [telegram] <M> This api don't get date time of create page and user creator 
[20:54:07] <wm-bb>	 [telegram] <M> 
[20:54:08] <wm-bb>	 [telegram] <M> Only will get revisions of page (re @lucaswerkmeister: you can get the earliest revision of a single page with prop=revisions&rvdir=newer (API sandbox))
[21:07:46] <wm-bb>	 [telegram] <Thecladis> Revision with parent id of 0 is page creation
[21:09:07] <wm-bb>	 [telegram] <M> This is very long 
[21:09:08] <wm-bb>	 [telegram] <M> 
[21:09:10] <wm-bb>	 [telegram] <M> We have 800 page 
[21:09:11] <wm-bb>	 [telegram] <M> Foreach 800 page 
[21:09:13] <wm-bb>	 [telegram] <M> It isn't possible that (re @Thecladis: Revision with parent id of 0 is page creation)
[21:09:49] <wm-bb>	 [telegram] <M> Each page have maybe 300 revisions
[21:10:15] <wm-bb>	 [telegram] <Thecladis> You don't need those 300 revision, you need one single oldest revision
[21:10:43] <wm-bb>	 [telegram] <Thecladis> You can set limit and direction on this one (re @lucaswerkmeister: you can get the earliest revision of a single page with prop=revisions&rvdir=newer (API sandbox))
[21:10:54] <wm-bb>	 [telegram] <Thecladis> (Direction is already set in the example)
[21:11:10] <wm-bb>	 [telegram] <lucaswerkmeister> yes, but only with a single page, if you do it with multiple input titles then you’ll get an error
[21:11:27] <wm-bb>	 [telegram] <lucaswerkmeister> for example (https://en.wikipedia.org/w/api.php?action=query&format=json&prop=revisions&titles=Test|Experiment&rvlimit=1&rvdir=newer)
[21:11:51] <wm-bb>	 [telegram] <M> We should write foreach for 300 revision of every page (re @Thecladis: You don't need those 300 revisions, you need one single oldest revision)
[21:12:07] <wm-bb>	 [telegram] <Thecladis> Why? (re @M: We should write foreach for 300 revision of every page)
[21:12:30] <wm-bb>	 [telegram] <lucaswerkmeister> Quarry might be an option – I’m not sure how, but I think you can write something like “for each of these pages, return the MIN rev_id and corresponding rev_actor etc.”
[21:12:33] <wm-bb>	 [telegram] <lucaswerkmeister> something with window functions maybe
[21:12:40] <wm-bb>	 [telegram] <lucaswerkmeister> if you know enough SQL…
[21:13:05] <wm-bb>	 [telegram] <M> Error (re @lucaswerkmeister: for example)
[21:13:16] <wm-bb>	 [telegram] <lucaswerkmeister> yes, as I said…
[21:13:43] <wm-bb>	 [telegram] <Thecladis> Nah, your link is to api.php main page (re @lucaswerkmeister: yes, as I said…)
[21:14:10] <wm-bb>	 [telegram] <Thecladis> Ah never mind
[21:14:25] <wm-bb>	 [telegram] <Thecladis> It is a weird way telegram labels it
[21:14:39] <wm-bb>	 [telegram] <Thecladis> https://tools-static.wmflabs.org/bridgebot/f8973ece/file_14396.jpg
[21:15:04] <wm-bb>	 [telegram] <lucaswerkmeister> hm, bit confusing by Telegram
[21:15:16] <wm-bb>	 [telegram] <lucaswerkmeister> I can see why they do it but something like `?…` at the end might be nice to indicate they’re not showing the full URl
[21:15:37] <wm-bb>	 [telegram] <Thecladis> Indeed
[21:17:13] <wm-bb>	 [telegram] <Thecladis> Just select * from revision where rev_parentid = 0 group by page_id or something along those lines. Well for practical use likely with join with page to limit by ns (re @lucaswerkmeister: Quarry might be an option – I’m not sure how, but I think you can write something like “for each of these pages, return the MIN ...)
[21:17:36] <wm-bb>	 [telegram] <lucaswerkmeister> oh right, yeah `rev_parentid` is a much better condition than “minimum revid” in that case ^^
[21:17:40] <wm-bb>	 [telegram] <M> Even i see database but there is not date time of create page in table page
[21:17:54] <wm-bb>	 [telegram] <lucaswerkmeister> (also technically revision IDs can be out of order and that should’ve been the minimum revision timestamp I guess)
[21:18:14] <wm-bb>	 [telegram] <lucaswerkmeister> no, that’s why the API link I sent earlier was for the earliest revision of a page (re @M: Even i see database but there is not date time of create page in table page)
[21:18:29] <wm-bb>	 [telegram] <lucaswerkmeister> because that corresponds to the timestamp and author of the page creation
[21:18:50] <wm-bb>	 [telegram] <lucaswerkmeister> that’s not recorded as a property of the page as a whole, only via the page history
[21:19:58] <wm-bb>	 [telegram] <M> Now, how do i get timestamp of create page and creator ?
[21:19:59] <wm-bb>	 [telegram] <M> 
[21:20:01] <wm-bb>	 [telegram] <M> With foreach on revisions ?
[21:20:43] <wm-bb>	 [telegram] <M> programmer in mediawiki should put this in api (re @lucaswerkmeister: no, that’s why the API link I sent earlier was for the earliest revision of a page)
[21:20:54] <wm-bb>	 [telegram] <M> Now, how do i get timestamp of create page and creator ?
[21:20:55] <wm-bb>	 [telegram] <M> 
[21:20:56] <wm-bb>	 [telegram] <M> With foreach on revisions ? (re @lucaswerkmeister: that’s not recorded as a property of the page as a whole, only via the page history)
[21:22:38] <wm-bb>	 [telegram] <M> Please send for me sql 🙏 (re @Thecladis: Just select * from revision where rev_parentid = 0 group by page_id or something along those lines. Well for practical use likel...)
[21:23:28] <wm-bb>	 [telegram] <Ladsgroup> you asked in private as well, I sent it to you, why are you asking here again?