Open nathanhornby opened 11 years ago
SELECT SQL_CACHEe.id,e.section_id, e.author_id, UNIX_TIMESTAMP(e.creation_date) AScreation_date, UNIX_TIMESTAMP(e.modification_date) ASmodification_dateFROMsym_entriesASeLEFT OUTER JOINsym_entries_data_93ASedON (e.id=ed.entry_id) WHERE 1 ANDe.section_id= '18' ORDER BYed.valueasc LIMIT 0, 1
SELECT SQL_CACHE
.id,
.section_id, e.
, UNIX_TIMESTAMP(e.
) AS
FROM
AS
LEFT OUTER JOIN
ON (
.
=
) WHERE 1 AND
= '18' ORDER BY
asc LIMIT 0, 1
When trying to navigate to the section with this field.
This is using the development branch of the extension.
SELECT SQL_CACHE
e.id,
e.section_id, e.
author_id, UNIX_TIMESTAMP(e.
creation_date) AS
creation_date, UNIX_TIMESTAMP(e.
modification_date) AS
modification_dateFROM
sym_entriesAS
eLEFT OUTER JOIN
sym_entries_data_93AS
edON (
e.
id=
ed.
entry_id) WHERE 1 AND
e.
section_id= '18' ORDER BY
ed.
valueasc LIMIT 0, 1
When trying to navigate to the section with this field.
This is using the development branch of the extension.