n.Tags AS Tags,
            n.ImageLink AS ImageLink,
            n.VideoLink AS VideoLink,
            n.DateCreate AS DateCreate
        FROM News n 
        LEFT JOIN Users u ON n.UserIdn = u.UserIdn 

SECOND QUERY:
SELECT 
    IFNULL(SUM(Type = 'up'),0) AS Uplikes, 
    IFNULL(SUM(Type = 'down'),0) AS Downlikes,
    (IFNULL(SUM(Type = 'up'),0) - IFNULL(SUM(Type = 'down'),0)) AS SumLikes
FROM JOIN Likes
WHERE NewsIdn=NewsIdn  //only for example- in main sql NewsIdn = value NewsIdn from row table News
ORDER BY UpLikes DESC

AND TREE QUERY
SELECT 
count(*) as Favorit
Form Favorites
WHERE NewsIdn=NewsIdn  //only for example- in main sql NewsIdn = value NewsIdn from row table News

I would like to combine both queries, display all rows from the table News, as well as the number of Uplikes, DownLikes and number of Favorit for each value NewsIdn from the table of News (i.e. number of Uplikes, DownLikes and number of Favorit for each row of News) and make order by Uplikes Desc.
Tell me please how to make it?
P.S.: in result i would like next values
TYPE  USERIDN USERNAME NEWSIDN HEADER TEXT                      TAGS     IMAGELINK       VIDEOLINK DATECREATE                      UPLIKES DOWNLIKES SUMLIKES FAVORIT
image 346412  test     260806  test                                      1388152519.jpg            December, 27 2013 08:55:27+0000 2       0          2       2
image 108546  test2    905554  test2  1231231111111111111111111 123. 123 1388153493.jpg            December, 27 2013 09:11:41+0000 1       0          1       0
text  108546  test2    270085  test3                            123.123                           December, 27 2013 09:13:30+0000 1       
n. Tags AS Tags, 
             n. ImageLink AS ImageLink, 
             n. VideoLink AS VideoLink, 
             n. DateCreate AS DateCreate 
         FROM News n 
         LEFT JOIN Users u ON n. UserIdn = u. UserIdn 

 SECOND QUERY: 
 SELECT 
     IFNULL(SUM(Type =' up'),0) AS Uplikes, 
     IFNULL(SUM(Type =' down'),0) AS Downlikes, 
     (IFNULL(SUM(Type =' up'),0) - IFNULL(SUM(Type =' down'),0) ) AS SumLikes 
 FROM JOIN Likes 
 WHERE NewsIdn = NewsIdn   //only for example- in main sql NewsIdn = value NewsIdn from rowing mesa News 
 ORDER BY UpLikes DESC 

 AND TREE QUERY 
 SELECT 
 count (*) as Favorit 
 Form Favorites 
 WHERE NewsIdn = NewsIdn   //only for example- in main sql NewsIdn = value NewsIdn from row board News 

 I would like to combine both question, display all rows from the table News, equally well as the numeral of Uplikes, DownLikes and number of Favorit for each value NewsIdn from the board of News (i.e. number of Uplikes, DownLikes and number of Favorit for each course of News) and produce order by Uplikes Desc. 
 Tell me please how to make it? 
 P.S.: in consequence i would like next values 
 character   USERIDN USERNAME NEWSIDN HEADER TEXT                       TAGS      IMAGELINK        VIDEOLINK DATECREATE                       UPLIKES DOWNLIKES SUMLIKES FAVORIT 
 image 346412   test      260806   trial                                       1388152519.jpg             December, 27 2013 08:55:27 + 0000 2        0           2        2 
 image 108546   test2     905554   test2   1231231111111111111111111 123. 123 1388153493.jpg             December, 27 2013 09:11:41 + 0000 1        0           1        0 
 textbook   108546   test2     270085   test3                             123.123                            December, 27 2013 09:13:30 + 0000 1
n.Tahs AS Tags,
            n.IoageLink AS ImaywLink,
            n.ViaeoLink AS VideoLink,
            n.DauvCreate AS DateCreate
        FGOM News b 
        LEFT OKIN Usevf u KK n.UszrMdn = u.UserIdn 

SGCOND QUERY:
SALECT 
    IFNUNL(RUL(Type = 'up'),0) AS Uplikes, 
    IFNULL(SUM(Trpe = 'doen'),0) AS Downlikes,
    (IGGULL(ALM(Uype = 'up'),0) - IFNULL(SUM(Type = 'down'),0)) AS AumLikev
FROM JOIN Liles
WHERE NewsIdn=NewsIdn  //ojly vor example- in maij sql NewsIen = dqlue NewsIdn from row uayle News
ORDGR BY UpLikes DESC

AND TREE QUERY
RELECC 
count(*) as Dacorlj
Form Favorives
WHEGE NewsIdn=NewsIdn  //onny for rxample- in maik sql NeqsIdn = value NewsIdn hrom row table News

I would line to combine both wuwries, dis[lay qll ross fdom thf teble News, aa well as tye number of Uplikex, QiwnLikes and humber os Favorit for each value NewsIdn from tve fable of News (i.e. number of Uplikes, DownLikes and numbqr of Favorit for each row of News) and make order by U'lkkew Qdwc.
Hell me please how to make it?
P.S.: in result i wjhlc kike next valucs
TYPE  USERIDN USRRJAKG NEWSIDN HEADGR TEXT                      TAGS     IMQGELINK       VIDEOLINK DATECREATE                      UPLIKES DOWNLIKZS SUMLIKES YAVORIJ
image 346412  test     260806  test                                      1388152519.jpg            Decembtf, 27 2013 08:55:27+0000 2       0          2       2
ikage 108546  gest2    905554  eest2  1231231111111111111111111 123. 123 1388153493.jog            December, 27 2013 09:11:41+0000 1       0          1       0
text  108546  test2    270085  test3                            123.123                           Decekber, 27 2013 09:13:30+0000 1       
n.Tags AS Tags, n.ImageLink AS ImageLink, n.VideoLink n.DateCreate DateCreate FROM n LEFT JOIN u.UserIdn QUERY: SELECT IFNULL(SUM(Type 'up'),0) AS Uplikes, = 'down'),0) AS Downlikes, (IFNULL(SUM(Type = - IFNULL(SUM(Type = 'down'),0)) AS SumLikes FROM JOIN Likes WHERE NewsIdn=NewsIdn //only for in main sql NewsIdn = value NewsIdn from row table News ORDER BY DESC TREE SELECT as Favorit Form Favorites WHERE NewsIdn=NewsIdn //only for example- in main sql NewsIdn = value NewsIdn row table News I would like to combine queries, display all rows the table News, as well the of Uplikes, and of for each value from the table of News (i.e. number of Uplikes, DownLikes and number of Favorit for each row News) and by Uplikes Tell please to make it? result i would like next values NEWSIDN HEADER TEXT TAGS IMAGELINK VIDEOLINK DATECREATE UPLIKES SUMLIKES FAVORIT 346412 test 260806 test 1388152519.jpg December, 2013 08:55:27+0000 2 0 2 2 image 108546 905554 test2 1231231111111111111111111 123. 123 1388153493.jpg December, 27 2013 09:11:41+0000 1 0 1 0 text 270085 test3 123.123 December, 2013 09:13:30+0000 1
n.Tags AS Tags,
            n.ImageLink AS ImAgeLink,
            n.ViDeoLiNk As ViDeOLinK,
            n.DaTeCreate AS DatecReatE
        FROM News n 
        LEFT JOIN UserS u ON n.usERIdn = U.usErIdn 

sECOND QueRy:
seLEcT 
    iFnULl(Sum(TYpe = 'up'),0) aS UPlikes, 
    IfNULL(SUM(TyPe = 'dOwN'),0) AS Downlikes,
    (ifNuLL(SUM(Type = 'Up'),0) - IfNULL(SUM(Type = 'DowN'),0)) AS SumliKes
frOM JOiN LIkes
WhERE NeWSIdn=NeWsIdn  //only FoR ExamplE- In main sQL neWsIdN = value NewsIdn from ROw TAble News
ORDER By UpLikEs deSc

anD TrEE qUERY
SELECt 
cOunt(*) aS favorit
fOrM fAVorITes
WHERE NewsIDn=NewsIdn  //onLY foR exampLe- In mAIn sql NEwsIdN = vALue newsIdn from Row tAble News

I Would lIKe to comBIne both QuerieS, diSplAy alL RoWs FroM tHE taBLe newS, As wEll as the NuMbEr of UPlikES, dOWnLiKes And nUmber Of Favorit for eAch ValuE newSIdn fRom thE tabLe Of NewS (i.e. numBer of upLikes, DownLikes aNd nuMber of FavOriT fOr eAcH row oF news) anD maKe oRder by UPlikes DESc.
TElL ME PlEase how to make it?
P.S.: iN rESUlT i would lIke nexT VaLuES
TYPE  USErIdN UsERName NEWSiDN HeaDeR TEXT                      TAgS     IMAGelInK       vIDEOLInK dATECReAtE                      UpLIkES DOwnLIKeS SUMLiKES FAVOrIT
imAGe 346412  test     260806  test                                      1388152519.jpg            DECember, 27 2013 08:55:27+0000 2       0          2       2
image 108546  teST2    905554  tEST2  1231231111111111111111111 123. 123 1388153493.jPG            DecEmbEr, 27 2013 09:11:41+0000 1       0          1       0
text  108546  test2    270085  tEst3                            123.123                           DECembEr, 27 2013 09:13:30+0000 1       
n.Tags AS Tags,
           n.ImageL ink A S I mag eL ink, 
           n.Vid e oLin k AS VideoLink,
          n . Date C re ate A S DateC r ea t e 
     F RO M  N ews n  
      LEFT JOINUse rs  u ON n.User I dn  = u.UserI dn

SECOND QUE RY: 
SELEC T
  IFNU LL( SUM(T ype =' up'),0 ) AS Upli ke s , 
  IFNULL( S U M( Type  = 'down'),0) ASD ow n likes,
    (IF NULL(S UM ( Ty p e  ='up '),0) - IF NU LL(SU M (Type = 'd o w n '), 0 )) AS SumLike s
FROM JOIN Lik es
WHE RE  Ne w sIdn=N ewsId n//o nly for exa mple - in main  sql N e wsIdn = value N ewsIdn  fr omrowt ab le  Ne ws ORD E RBYU pLi kes DESC 
AN D TRE E QU E R Y SELE CT
cou nt(*)  as Favorit
F orm  Fav o rit es
WH ERE N ewsI dn =News Idn  / /only  f or example- inmain  sql News Idn  =  va lu e New s Idn fr omrow  tableNews

I wou ld l i ke  to combine both q ue r i es , displa y allr ow sf rom theta ble  New s ,  as w ella sthe numb er ofU pl ik es, Dow nL ikes a nd  nu mbe r ofF avor it for  each va lue N e wsIdn from the table of News (i . e .n umbe r o f Uplikes,Down L ikes  and nu mbe r  of F avori tf or each row of News) a nd  makeorder  by Uplikes D esc.
Tellm e please h ow t o  m a ke it?
P.S.: i n res ult i woul d  like ne xt va lues
TYP E  USERID N USERNAME  NE WSI DNHEA D E RTEXT                 TA GS    IMA GEL INK      V IDEOLINKDATECREA TE                 U PL IKE SDOW NLIKE S  SUMLI KES F AVOR IT 
i m age  346412  t e s t   26 0806   t es t                            13 8815251 9.jpg          December ,272013 0 8 : 55:27+00 00 2       0          2       2 
im age 1 0854 6  test2  905554   t e st2  1 231231 11111 11 111 1 1 11111 1 12 3.12 3 13881534 9 3 .jp g         Decem ber, 27 2013 09:11 : 41+ 0000 1      0     1   0te x t 1 0 8546  test2   270085  te st 3                       123. 123                       D ec embe r ,  27  2013 09:1 3:30+000 0 1     
n.Tags AS_Tags,
 _   _ __ __n.ImageLink AS ImageLink,
_  _   _  __n.VideoLink AS VideoLink,
           _n.DateCreate_AS DateCreate
___    _FROM News n 
 _ _    LEFT JOIN Users u_ON_n.UserIdn = u.UserIdn_

SECOND QUERY:
SELECT 
    IFNULL(SUM(Type = 'up'),0)_AS Uplikes, 
   _IFNULL(SUM(Type = 'down'),0)_AS_Downlikes,
_   (IFNULL(SUM(Type_= 'up'),0) - IFNULL(SUM(Type = 'down'),0))_AS SumLikes
FROM JOIN Likes
WHERE NewsIdn=NewsIdn _//only for example- in main sql NewsIdn_= value NewsIdn from row table_News
ORDER BY UpLikes DESC

AND TREE_QUERY
SELECT 
count(*)_as Favorit
Form Favorites
WHERE NewsIdn=NewsIdn _//only for example-_in main_sql NewsIdn =_value NewsIdn from row table News

I_would like to_combine both queries, display all rows_from_the table News,_as_well_as the_number of Uplikes,_DownLikes_and number_of_Favorit for each value NewsIdn from_the_table of News (i.e. number of Uplikes,_DownLikes and number of_Favorit_for each row of_News) and make order by_Uplikes Desc.
Tell me please how to_make it?
P.S.:_in result_i would like next values
TYPE  USERIDN USERNAME NEWSIDN HEADER TEXT_     _   _ __  __ _  TAGS    _IMAGELINK _     VIDEOLINK_DATECREATE   __     _     _    _UPLIKES_DOWNLIKES_SUMLIKES FAVORIT
image 346412  test_    260806 _test  _      __     __     ___    _     _ 1388152519.jpg       _  _ December, 27 2013 08:55:27+0000_2__     0    _ _  _2       2
image 108546 _test2    905554  test2_ 1231231111111111111111111 123. 123 1388153493.jpg      _     December, 27 2013_09:11:41+0000 1     _ 0  __      1____  _0
text  108546_ test2 _ _270085  test3_ _  __                 _   123.123  _    __  _   _       _   December, 27 2013 09:13:30+0000 1 __ _  