Databases
StackOverflow2013
Postsdbo
POLimit query results to total results minus 10 results
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POLimit query results to total results minus 10 results
    primarykey
    data
    text
    <p>guys I cant figure this out.. I red a lot but no luck...</p> <p>I have the following query, and I need to limit it in order to show the total results minus a specific number os results, let's say 10.</p> <p>I mean, if the query would return 1000 total results, I want it to return 990, and the last 10 results need to be excluded.</p> <p>Is this possible?</p> <p>see the query call:</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 ' ; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USa_horse_with_no_name
    1. USol30cean0
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POLimit query results to total results minus 10 results
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POLimit query results to total results minus 10 results
      1. This table or related slice is empty.
      1. VTDownMod
    1. COWhat is the purpose of this? What requirement are you attempting to meet? What have you tried so far that hasn't worked? Is there a reason you can't do this in your code instead of the query?
      singulars
      1. POLimit query results to total results minus 10 results
      1. USJeff
    2. COCould you create view and then run select on that view?
      singulars
      1. POLimit query results to total results minus 10 results
      1. USMarcin Pietraszek
    3. COhello, the purpose is the following. this query creates a xml view that is used by real estate portals to index my properties for sale, but there is a big problem, they crawl very often my site and they are crawled by google very more often than my site, so when i search for a property or original content of my own site, in google those portals are always shown in SERP before than my site, and i think google thinks that my originalmcontent is their original content. by reducing the xml of 10 properties they will index only properties that google has already indexed in my site, got my BIG prob?
      singulars
      1. POLimit query results to total results minus 10 results
      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