mysql - How to union different multiple selects in one query? -



mysql - How to union different multiple selects in one query? -

is possible combine tables in 1 or maybe 2 queries?

i tried utilize union need access each row in query.

and biggest problem me sort of order by.

for illustration need print first query rows in 1 div, sec query rows in div , on..

(select link rellink, date reldate, title reltitle torrent moderate = 1 order date desc limit 0,12), (select torrent torlink1, date tordate1, title tortitle1 torrents moderate = 1 , genre = 1 order date desc limit 10), (select date tordate2, torrent torlink2, title tortitle2 torrents moderate = 1 , genre = 2 order date desc limit 10), (select link newslink1, date newsdate1, title newstitle1 news moderate = 1 order date desc limit 0,10), (select link newslink2, date newsdate2, title newstitle2 news moderate = 1 order date desc limit 10,10);

yes, it's possible ask. need union all between queries. need utilize same aliases columns in each of items you're unioning together.

here's job you. didn't repeat subqueries

select link, date, title ( select link link, date date, title title torrent moderate = 1 order date desc limit 0,12 union select torrent link, date date, title title torrents moderate = 1 , genre = 1 order date desc limit 10 union select torrent link, date date, title title torrents moderate = 1 , genre = 2 order date desc limit 10 union /* etc etc */ ) query order date desc

notice how columns made conform each other using same aliases?

if want these items deduplicated, utilize union rather union all. it's little slower because of deduplication process, you're handling dozens of rows that's not problem.

mysql

Comments

Post a Comment

Popular posts from this blog

c - Compilation of a code: unkown type name string -

c - Compilation of a code: unkown type name string - i have next lines of code compiler says following: "unknown type name 'string'" both in declaration , definition of function. can tell me what's wrong? thanks. #include <stdio.h> #include <stdlib.h> #include <string.h> void frecognizeclient(string *actualclient) there no string type in c. need utilize array so: char array[10]; then can pass in function: void frecognizeclient(char *actualclient); c arrays string compilation
Read more

java - Bypassing "final local variable defined in an enclosing type" -

java - Bypassing "final local variable defined in an enclosing type" - i'm writing programme , i'm getting "the final local variable asd cannot assigned, since it's defined in enclosing type". i provide illustration not code produces error aswell. have arraylist utilize later (if define within button can't utilize later on), outside of button, pressing button should give values arraylist. in illustration "create new arraylist" cause same problem. button btn = new button("asd"); final arraylist asd = new arraylist(); btn.setonaction(new eventhandler<actionevent>() { public void handle(final actionevent event) { asd = new arraylist(); //here's error.. } }); clear arraylist , add together values. java javafx
Read more

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) -

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) - hello have problem hibernate , jackson. have 2 pojos @entity @table(name = "users") public class user implements serializable { static final long serialversionuid = 4235637833262722256l; @id @generatedvalue private int id; @column(name = "creation_date") private date creationdate; @column(name = "first_name") private string firstname; @column(name = "last_name") private string lastname; @version @column(name = "version") private int version; @column(name = "e_mail") private string email; @column(name = "enabled") private boolean enabled; @column(name = "login") private string login; @column(name = "password") private string password; @jsonmanagedreference("role") @onetomany(mappedby = "user", cascade = cascadetype.all,fetch = fetchtyp...
Read more