sql - How do I return data from multiple MySQL tables in date order? -


I have another MySQL problem Again, with complex questions I am on my head.

On my website I display the last 5 reviewed games on the Currently homepage. Now, it has been ticking for a while and I have decided to add news on the same page.

However, I want to see the system change is one that shows news entries as well as reviews - shows the last entry that was either posted in the category . Both tables are completely unrelated (news, reviews).

The following columns are what I want to return: 

  news.newsTitle news.newsBody news.postedOn (timestamp) Review.postedOn (timestamp) review.reviewSummary review. OurScore game.gameName game.gameImage

Games table are associated with the review News table.

The current query is: 

  Select News Newspaper, News. Posted, DATE_FORMAT (news posted, '% M% d,% Y'), NewsPosted, game.gameID, DATE_FORMAT (review posted, '% M% D,% Y') GameName, Game Image, Review Review summary, review game out. Include news on the news from our Tire. NewsID = News News Id Join in the game review gameID = review.gameID where game.a.gameid DESC LIMIT 0, 5

by publishing = 'Y' order but display all news items 5 times together

You need to investigate the union - create two questions that match the same number (and equivalent) columns Output, use the union in the result and then according to the results of the top 5.

Using the above, regardless of the latest Top 5, their mix of news / reviews - is it what you mean?

The following should return the desired data: 

  (SELECT news.newsTitle AS title, news.newsBody AS body, DATE_FORMAT (News posted, '% M% D,% Y '), the news was posted, as the screen, the news from the Null AS score in the form of the image) All in the Union (select title name as game.game name, review.reviewSummary AS body, DATE_FORMAT (review.postedOn, '% M% d,% Y') Posted in AS, review.postedOn, game.game Image, image as image. Leave the game from OurScore AS game And join in the game. GameID = review.gameID where Kelkprkashit = 'Y') order by mail add-on Diissi LIMIT 0,5

Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more