Sorting questions

Hi Jotomas,

I checked and found some strange behaviour in SQL query results. I tried to execute query directly in phpMyAdmin and on every refresh it changes the listings order among same package id. I checked on my test site but this not happening there.

I have tested following query.

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID, wp_geodir_gd_ruta_tapes_detail.package_id
FROM wp_posts
LEFT JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_geodir_gd_ruta_tapes_detail
ON (wp_geodir_gd_ruta_tapes_detail.post_id = wp_posts.ID) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1
AND ( wp_term_relationships.term_taxonomy_id IN (688) )
AND wp_posts.post_type = 'gd_ruta_tapes'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'private'
OR wp_posts.post_status = 'gd-expired')
AND wp_posts.post_type = 'gd_ruta_tapes'
GROUP BY wp_posts.ID
ORDER BY wp_geodir_gd_ruta_tapes_detail.package_id desc
LIMIT 0, 18

On /a-taula/ page first 3 listings has package id 35 and rest have 21. So on every refresh it changes order of listings within package_ids.

To fix this i have applied second lever sorting on your site via PHP snippet under Snippet > Listing Sorting.

Now it shows correct listings.

Please check and let us know.

Best Regards,
Kiran

I noticed that you have put the snippet in the network admin dashboard. Is this correct or should it be put in the site admin dashboard?

I have added it to network dashboard to fix sorting on network wide. Both are correct either you can add it to site wide or network wide.

Kiran

I checked on my test site and i can’t replicate there, so it could be server specific. You keep that snippet on site where you see similar issue.

Kiran