Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>If you are using MySQL, then use <code>limit</code> and <code>offset</code>:</p> <pre><code>limit 10, 9999999 </code></pre> <p>This starts at the 10th record and continues to the end of the data (or to 9999999 rows, technically).</p> <p>You are ordering by <code>p.id desc</code>, so this will remove the 10 rows with the highest id.</p> <p>To really do what you seem want (remove the 10 with the lowest id), use a subquery and then sort again after the subquery:</p> <pre><code>select t.* from (&lt;most of your query here&gt; order by p.id asc limit 10, 999999 ) t order by id desc </code></pre> <p>To remove the rows with the <em>highest</em> id, just add the <code>limit</code> statement:</p> <pre><code> $query = 'SELECT p.*,c.name as name_category,t.name as name_type,cy.name as name_country,s.name as name_state,l.name as name_locality,l.alias as locality_alias,pf.name as name_profile, ' . ' CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(":", p.id, p.alias) ELSE p.id END as Pslug,' . ' CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as Cslug,' . ' CASE WHEN CHAR_LENGTH(cy.alias) THEN CONCAT_WS(":", cy.id, cy.alias) ELSE cy.id END as CYslug,' . ' CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END as Sslug,' . ' CASE WHEN CHAR_LENGTH(l.alias) THEN CONCAT_WS(":", l.id, l.alias) ELSE l.id END as Lslug, ' . ' CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(":", t.id, t.alias) ELSE t.id END as Tslug ' . ' FROM #__properties_products AS p ' . ' LEFT JOIN #__properties_country AS cy ON cy.id = p.cyid ' . ' LEFT JOIN #__properties_state AS s ON s.id = p.sid ' . ' LEFT JOIN #__properties_locality AS l ON l.id = p.lid ' . ' LEFT JOIN #__properties_profiles AS pf ON pf.mid = p.agent_id ' . ' LEFT JOIN #__properties_category AS c ON c.id = p.cid ' . ' LEFT JOIN #__properties_type AS t ON t.id = p.type ' . ' WHERE p.published = 1 ' .' ORDER BY p.id desc limit 10, 999999' ; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POLimit query results to total results minus 10 results
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USGordon Linoff
    1. USGordon Linoff
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POLimit query results to total results minus 10 results
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COhello, thanks a lot, I want to remove the rows with the highest id.. the last row that have been published... so should i use your code? can you help me and write the full query because i am not a coder? please....
      singulars
      1. PO
      1. USol30cean0
    2. COand yes I use MYSQL
      singulars
      1. PO
      1. USol30cean0
    3. COSOLVED THANK YOU!!! is there anyplace where I can give u karma or something??
      singulars
      1. PO
      1. USol30cean0
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload