MySQL Forums
Forum List  »  German

Re: MySQL 8
Posted by: Peter Brawley
Date: March 07, 2022 11:38AM

select 
  insertion_id, created, i.prof_id, z.postcode, i.category_id, i.area_id, 
  title, description, is_offer, is_paid, max_distance, i.is_verified, delete_on, 
  p.name as prof_name, email, c.name as category_name, a.name as area_name 
from insertion i 
inner join zip_code z on i.zip_id = z.zip_id 
inner join professor p on i.prof_id = p.prof_id 
inner join insertion_category c on i.category_id = c.category_id 
inner join insertion_area a on i.area_id = a.area_id 
where i.is_verified = true 
  and insertion_id <= (
    select min(insertion_id) 
    from (
      select 0 as insertion_id, '1970-01-01 00:00:00.000000' as created
      union 
      select insertion_id, created from insertion order by insertion_id desc limit 101
    ) -- ALIAS HIER ERFORDERLICH
  ) 
order by i.created desc limit 10 ;



Edited 1 time(s). Last edit at 03/07/2022 11:44AM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
342
March 05, 2022 07:13AM
175
March 05, 2022 09:51AM
185
March 06, 2022 07:01AM
171
March 06, 2022 09:05AM
165
March 07, 2022 03:03AM
Re: MySQL 8
154
March 07, 2022 11:38AM
155
March 08, 2022 04:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.