Computing desk
< July 24	<< Jun \| July \| Aug >>	July 26 >

Welcome to the Wikipedia Computing Reference Desk Archives
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages.

July 25

Group by

Hello guys! Have basically such problem with SQL. Will show my problem with an example. I have such table (of course, it is only a small part of it):

ll_from	ll_lang	ll_title
1	ab	lorem
1	az	ipsum
1	bf	foo
2	bab	some
2	baz	random
2	bbf	text
3	bab	some
3	baz	random
3	bbf	text

So I group by them by ll_from column. I want to get those groups, which doesn't have value az in one of ll_lang columns, that is, I would need ll_lang<>"az", which of course doesn't work in where statement. For this example I would like to get such output:

select ll_from, count(ll_lang)
from table
group by ll_from;

ll_from	count(ll_lang)
2	3
3	3

Yes, it is for Wikipedia. In Wikipedia-related terms speaking, I want to get pages (ll_from), which aren't in some language Wikipedia (ll_lang), sorted by number of iw.

I don't know if this is a performant way of doing it but you could try it. Put this after the group by clause:

having ll_from not in (select distinct ll_from from foo where ll_lang = 'az');

91.155.193.199 (talk) 19:54, 25 July 2015 (UTC)[reply]

No, it wasn't working. But I was able to find a correct solution, had to use sub-select in where part :) So thanks fot the hint, @91.155.193.199: --Edgars2007 (talk/contribs) 13:46, 29 July 2015 (UTC)[reply]

Removing the default profile from Chrome

Hi, I updated to the latest version of Chrome yesterday, and would like to remove the default profile, you know the one where your username appears in the top right of the screen. Usually it can be hidden through navigating to chrome://flags/#enable-new-avatar-menu and selecting disabled. But this option no longer works. There is apparently another option to add --disable-new-avatar-menu after the chrome.exe part of the target attribute, but when I tried that just now it took absolutely no notice. I know this thing is billed as an easy way to switch between profiles, but as I'm the only person using my desktop it's completely unnecessary, so I'd rather reclaim the space for open windows. Can anyone help? Thanks in advance, This is Paul (talk) 13:15, 25 July 2015 (UTC)[reply]

ok, I'm now gonna answer my own question, since I just discovered why it wasn't working. It seems that the change only applies to a specific shortcut and not all of them. Having modified the shortcut on my desktop I then opened Chrome from the taskbar, but this shortcut was still unchanged. So I had to delete the one from the taskbar and then add the modified desktop shortcut to the taskbar. The start menu shortcut also needed to be changed separately. Anyway it all works fine now and that irritating profile has gone. Hope this helps anyone else who downloads the latest version of Chrome and doesn't want the new facility. Cheers, This is Paul (talk) 15:12, 25 July 2015 (UTC)[reply]

Crowdlogs

Last month I asked about crowd funding tracking sites, and User:X201 was kind enough to tell me about Crowdlogs, which tracks both KickStarter and Indiegogo, but they stopped working a few days ago, with "Something went wrong." appearing on their front page. Their twitter account doesn't have any recent news and their blog page just says "Error establishing a database connection". Does anyone here know if they are experiencing technical difficulties or if they are shutting down operations?

Kicktraq is still working (though it doesn't track Indiegogo) but Kickspy shut down at the end of March after receiving some heat from Kickstarter (though they say their decision to shut down was completely independent of Kickstarter's displeasure). Are there any Indiegogo tracking sites still in operation? -- ToE 20:34, 25 July 2015 (UTC)[reply]

There is an email address for Crowdlogs on their 'About' page - you might maybe want to ask. SteveBaker (talk) 11:55, 26 July 2015 (UTC)[reply]

I did write to them and never heard back, but now, several weeks later, the site is back online, without any note on their blog or twitter account to explain their absence. From charts it appears that they didn't collect data from 22 July to 5 August, and I'm not sure that they are back to 100% yet, as I can't seem to get them to report on an Indiegogo campaign which started 10 days ago. Welcome back Crowdlogs, and I hope you are quickly back up to full strength. -- ToE 16:04, 19 August 2015 (UTC)[reply]