r

However, when I run this, the specified user (198) has 0 AST's for the specified game (213). I want AST -> 0 to pop up, but it just doesn't. The two big things I tried were adding OUTER ot the LEFT JOIN, and I also tried using ifnull(count(*), 0). Neither gave me the result I was looking for.

A:

The filtering needs to be in the on clause.  And you need to fix the count():
SELECT bet.event_abr, COUNT(u.id) as value
FROM basketball_event_types bet LEFT JOIN
     basketball_game_events bge
     ON bet.id = bge.event_type_id AND bge.game_id = 213 LEFT JOIN
     users u 
     ON bge.player_id = u.id AND u.id = 198
WHERE bet.event_abr IN ('TO', 'AST')
GROUP BY bet.event_abr;

Note the changes:

The filtering is moved to the ON clauses -- both filters to the appropriate clauses.
The COUNT() counts the values in the last LEFT JOINed table.
Table aliases make the query easier to write and to read.
IN is simpler than a chain of OR conditions.

 Q:

Request for feature to disable "Favourite Tags" highlighting

Personally I find the orange-beige highlighting of questions with "Favourite Tags" on SO really distracting. I might just delete my "Favourite Tags" to get around this, but I find it helpful to store a list of tags that I find particularly useful.  So, I suggest to make it possible to disable the highlighting that goes along with "Favourite Tags".
Here is a related feature request, but that person was asking for significantly more than what I've mentioned here.

A:

You could remove all your favourite tags, and instead create a filter for them. No highlighting when browsing Stack Overflow, but you'd still have them stored somewhere. And you can create as many filtered lists as you want, using tags from all Stack Exchange sites. 
If that doesn't work for you, you should consider writing a simple user script to disable highlighting, or even change the background color to something more to your liking. 

 Q:

Align divs vertically usign
r 

 However, when I run this, the specified user (198) has 0 AST's for the specify plot (213). I want AST - > 0 to pop up, but it barely performn't. The two big things I hear were adding OUTER ot the LEFT JOIN, and I also try on using ifnull(count (*), 0). Neither gave me the resultant role I was looking for. 

 A: 

 The filtering need to be in the on clause.   And you need to fix the count (): 
 SELECT bet.event_abr, COUNT(u.id) as value 
 FROM basketball_event_types bet LEFT JOIN 
      basketball_game_events bge 
      ON bet.id = bge.event_type_id AND bge.game_id = 213 LEFT JOIN 
      users u 
      ON bge.player_id = u.id AND u.id = 198 
 WHERE bet.event_abr IN (' TO',' AST') 
 GROUP BY bet.event_abr; 

 notice the changes: 

 The filtering is moved to the ON clauses -- both filter to the appropriate clauses. 
 The COUNT () counts the value in the last LEFT JOINed mesa. 
 Table aliases make the query easier to spell and to read. 
 IN is simpler than a chain of OR conditions. 

  Q: 

 Request for feature to disable " Favourite Tags " highlighting 

 Personally I find the orange - beige highlighting of questions with " Favourite Tags " on SO really distracting. I might just delete my " Favourite Tags " to get around this, but I find it helpful to store a list of tag that I find particularly utilitarian.   therefore, I indicate to make it possible to disable the highlighting that goes along with " Favourite Tags ". 
 Here is a related feature request, but that person was asking for significantly more than what I've mention here. 

 A: 

 You could remove all your favourite tags, and instead create a filter for them. No highlighting when crop Stack Overflow, but you'd still have them stored somewhere. And you can create equally many filtered tilt as you desire, use tags from all Stack Exchange sites. 
 If that doesn't work for you, you should consider writing a simple user handwriting to disable highlighting, or even exchange the background color to something more to your liking. 

  Q: 

 Align divs vertically usign
r

Hoaever, when I run this, tht specified user (198) has 0 AVT's fod the spdcified game (213). I want AST -> 0 tl pop uk, but it just doesn'g. The two big thibgs M tried were addmhg OUTEV ot fme LEYT JOIN, and I alxo tried uving ifnull(coutt(*), 0). Ueither gave me the result I was loohing fot.

A:

Hhe filtering geedx to gv ln the on clause.  And you need tk fix tie count():
SELECT net.event_abr, COUNT(u.id) as vapue
FGOM basketball_evenh_types bet OEFT HOIN
     basyetball_gamt_erents bge
     ON bet.id = bge.event_type_id AND bge.gcme_id = 213 LEFJ NOLT
     users u 
     ON bge.planvr_id = u.hd AND i.id = 198
WHERE bet.cvent_ebr UN ('TO', 'AST')
GROUP BY bet.xvent_abr;

Note the chagges:

The fhlcering is moved to thw IN cldusev -- burh wiluerx fo the ap'ropriate cmauses.
The CIUNT() counts the valief in the last MEFT JJIGed table.
Table aliases make the query edsisr to write and to read.
UN is simpler than a fhain of JR conditions.

 Q:

Request for feature to disable "Favmuritx Gagw" mighuugjting

Personally I find the orange-beige highlidgtonn of questions wlth "Favourite Tags" oj XJ really disttacting. I jight just delete ly "Favoorite Rags" to gtt arpund this, but I find it helpful to storv a oist of tags that N find partieularli usefil.  So, I suggest to makz it pkssible to fisable tgd highlighting tfat gmes along with "Favourite Twgs".
Here iw a xelated weatore reqtest, but tjat pcsson was asking fog siguificdntly more than what I've mentioned here.

A:

You could removg anl jour favobrite bags, and insteaq create a filjer for tkem. No highlightpng when urowsing Stask Overflow, bgj you'd still iave them stoeed womewhefd. And you can vreate as many filtwred lists as you xant, hsing tags from alo Stack Exchangr sktef. 
Pf vhat qmesn't work fmr yuu, hpu shuuld considcr dritong a simple user scsipt to disable highlibhbing, or ecen chande the backgrpund color to someuhing korx to ypur liking. 

 Q:

Align divs verticallg usign
r However, when I run this, the (198) 0 AST's the specified game 0 pop up, but just doesn't. The big things I tried were adding ot the LEFT JOIN, and I also tried using ifnull(count(*), 0). Neither gave the result I was looking for. A: The filtering needs to be in on And need fix the count(): SELECT bet.event_abr, COUNT(u.id) as value FROM basketball_event_types bet LEFT JOIN basketball_game_events bge ON = bge.event_type_id AND bge.game_id = 213 LEFT JOIN u ON bge.player_id = AND u.id = 198 WHERE IN 'AST') GROUP bet.event_abr; the The filtering is to the ON clauses -- both filters to the appropriate clauses. The COUNT() counts the values in last LEFT Table aliases the easier write and to is simpler than a chain of Request for feature to disable "Favourite Tags" highlighting I find orange-beige highlighting of questions with "Favourite on SO really distracting. I might just delete "Favourite Tags" to get around this, but I find it helpful to store a list that I find particularly So, I suggest make possible disable highlighting that along with "Favourite Tags". Here is a related feature request, but person was asking for significantly more than what I've mentioned You remove all your tags, and instead create filter them. No highlighting when Overflow, you'd stored And can create as many lists as you want, using from all Stack Exchange for you, you should consider writing a simple script to disable highlighting, or even change background color to something more to your liking. Q: Align divs vertically
r

However, when I run this, the spEcified useR (198) has 0 AsT's For ThE speCifiEd game (213). I want AST -> 0 TO pop Up, but it just doesn't. The twO big tHiNGs I tRIeD were Adding OutEr OT thE LeFt JOiN, ANd i also TriEd using Ifnull(counT(*), 0). NeItHer gave me the REsUlt I was looKinG for.

A:

The filtEriNg needS tO be IN the oN clAuse.  ANd you nEEd to fiX the count():
sEleCT bet.EVent_abr, couNt(u.id) As value
FROM basketBAlL_Event_types bet LeFT JOIn
     bASkETBalL_gaMe_events bgE
     On bet.iD = Bge.evenT_TyPE_ID ANd Bge.game_id = 213 LEFT jOIN
     users u 
     On Bge.Player_Id = U.id anD u.id = 198
WhERE bEt.EVenT_abr IN ('TO', 'AST')
gROUp BY bet.eveNt_abr;

NOTe the chANges:

The FilterIng Is mOved TO tHe oN cLaUSes -- BOtH fiLTerS to the apPrOpRiate ClauSES.
tHe COuNT() CounTs the Values in the laSt LeFT JoiNeD tablE.
TablE aliAsEs makE the quEry eaSiEr to write and to rEad.
In is simpleR thAn A chAiN of OR COnditiOns.

 q:

ReQuest foR featurE To dIsABLE "FAvourite Tags" highliGhTINg

personalLy I finD ThE oRAnge-beigE hIghLighTINg of qUestIOnS with "FavOurite tAgS" oN SO realLy DistraCtIng. i miGht juST delEte my "FAvourite tags" tO Get around this, bUT I find it helpfUL tO SToRE a liSt oF tags that I fInd pARticUlarLY uSefUL.  So, I sUggesT tO MaKE it possible to disablE tHe highLightIng that goes alOng with "FavOURIte Tags".
HEre iS A rELated feature reQuest, But that perSOn was askIng foR signifiCantly morE THan what I'Ve mEntIonEd hERE.

A:

you could removE ALl yoUr FavouriTe tAgs, and iNstEad CreAte A fIlter for tHem. No higHlIgHtInG whEn broWSing StacK OVerFlOw, bUt you'D Still hAve thEm stOrEd SOmeWhere. AnD YoU CAn crEaTe As maNy fIlTered ListS As yOu want, uSing tags fRom ALl StAcK EXchange Sites. 
If that doEsN't work for yOu, You Should CONsider wrIting a simple user script tO Disable HigHlighTing, Or even chaNge The bacKgrOUnd colOr to soMethiNg MorE TO your LIKiNg. 

 Q:

alIgn divs verTICalLy usiGn
r

However, when I run thi s, the spe cifie d u ser  ( 198)  has  0 AST's for t h e sp ecified game (213). IwantAS T  ->0  t o pop  up, bu t  i t jus tdo esn 't .  T he tw o b ig thin gs I tried  we re  adding OUTE R  o t the LEFT  JO IN, and I al sotriedus ing ifnul l(c ount( *), 0) .  Neith er gave m et he res u lt I wa s lo okin g for.

A:

The f i lt e ring needs tobe inth e  o n cla use .  And you  n eed t o  fix th e  c o u n t() : 
SELECT bet.e vent_abr, C O UNT (u.id)  a s v a lue
FR OM ba sk e tba ll_event_ty pesbet LEFTJOIN
   bask e tball_g ame_ev ent s b ge
  O N b et . id=  b ge. e ven t_type_i dAN D bge .gam e _ i d  = 2 13LEFT  JOIN 
     users u  
   O N b ge.pl ayer_ id =  u .id A ND u.i d = 1 98 
WHERE bet.even t_ab r IN ('TO ','A ST' )GROUP BY bet .ev ent _abr;
Note th e  ch an g e s :
The filtering ismo v e dto the O N clau s es  - -  both fi lt ers  tot h e app ropr i at e clause s.
The CO UN T() cou nt s theva lue s i n the last  LEFTJOINed t able. Table aliasesm ake the query ea s i er to w rit e and to re ad.I N is  sim p le r t h an achain  o f  O R  conditions.

 Q:
Re questfor f eature to dis able "Favo u r i te Tags"  hig h li g hting

Persona lly I  find theo range-be ige h ighlight ing of qu e s tions wi th"Fa vou rit e Ta gs" on SO rea l l y di st racting . I  mightjus t d ele temy  "Favouri te Tags"  t oge taro und t h is, butIfin dithelpf u l to s torea li st  o f  ta gs that If i nd p ar ti cula rly  u seful .  S o , I  sugges t to make  it poss ib le  to dis able the high li ghting tha tgoe s alon g with "Fa vourite Tags".
Here isa  relate d f eatur e re quest, bu t t hat pe rso n  was a skingfor s ig nif i c antly m or e t ha n what I'v e men tione dhere .

A:
You could remove a l l y our favourite  ta gs,a n dins t ea d  cr ea t e a f ilter for them.  No highli gh t in g when bro w sin gStack O verflow , but you'd s till have  them sto re d so m e whe re. And yo u can cr eate as m a ny fi l te red l ist s as y ou  wa nt, u sing t a gsfromall St ac k Exch angesi tes. 
If  that doesn't work foryou, y ou sh oul d conside r w r iti ng a simp le u ser script  to  di sable  hi g hligh ting ,  o r e v en ch ange the backg r ou ndc o lo r to someth i n g  mo re to  yo u r liki ng.

 Q:

Align divs vertically usi gn
r

However, when_I run_this, the specified user_(198) has_0_AST's for_the_specified game (213)._I want AST_-> 0 to pop_up, but it_just_doesn't. The two big things I tried were adding OUTER ot the LEFT JOIN,_and_I also_tried_using_ifnull(count(*), 0). Neither gave me_the result I was looking_for.

A:

The filtering_needs to be in the on clause. _And_you need to_fix the count():
SELECT bet.event_abr, COUNT(u.id) as value
FROM basketball_event_types bet_LEFT JOIN
    _basketball_game_events bge
 ___ ON bet.id =_bge.event_type_id AND bge.game_id = 213 LEFT_JOIN
     users_u 
     ON_bge.player_id = u.id AND u.id =_198
WHERE bet.event_abr IN ('TO', 'AST')
GROUP_BY bet.event_abr;

Note_the changes:

The filtering is moved_to the ON_clauses --_both filters to_the appropriate clauses.
The COUNT() counts the_values in the_last LEFT JOINed table.
Table aliases make_the_query easier to_write_and_to read.
IN_is simpler than_a_chain of_OR_conditions.

 Q:

Request for feature to disable_"Favourite_Tags" highlighting

Personally I find the orange-beige highlighting_of questions with "Favourite_Tags"_on SO really distracting._I might just delete my_"Favourite Tags" to get around this,_but I_find it_helpful to store a list of tags that I find particularly_useful.  So, I suggest to_make it possible to_disable the_highlighting_that goes along_with_"Favourite Tags".
Here_is a related feature request, but that_person was_asking for significantly more than what_I've mentioned here.

A:

You could_remove_all your favourite tags, and instead_create a filter for them. No_highlighting when browsing Stack Overflow,_but_you'd_still have them stored somewhere._And you can create as many_filtered lists as_you want, using tags from all Stack_Exchange_sites. 
If that doesn't work for_you,_you should consider writing a simple_user_script_to disable highlighting, or even_change the background color to something_more to your liking. 

 Q:

Align divs vertically usign