I love Seblod! And it makes me feel like a noob from time to time...
So hoping you'll tolerate a noobish question.
I created a simple search and for some reason the Select Query is shown above the search form and results, like so -- why? is there a switch for this? is it contagious?
BTW, I checked
- the templates (just using the standard seblod_table template for a list) AND
- there is no module showing the SQL query, AND
- SQL Select statement is still rendered with a NEW menu item, AND
- The SQL Select statement as NO style, or class, or ID, else I'd just use CSS to hide it.
Hmmm.... this appears to be generated by default from some component function, no?
thx -- Dano
SELECT t0.id AS pid,t0.pk AS pk,t0.pkb AS pkb,t0.parent_id AS parent,t0.author_id AS author,t0.cck AS cck,t0.storage_location AS loc,tt.id AS type_id,tt.alias AS type_alias
FROM `#__cck_core` AS t0
LEFT JOIN `#__cck_store_form_applicants` AS t1 ON t1.id = t0.pk
LEFT JOIN `#__content` AS t2 ON t2.id = t0.pk
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
WHERE t2.state = 1
AND t2.access IN (1,1,2,3)
AND ( t2.publish_up = '0000-00-00 00:00:00' OR t2.publish_up <= '2017-02-26 01:52' )
AND ( t2.publish_down = '0000-00-00 00:00:00' OR t2.publish_down >= '2017-02-26 01:52' )
AND t0.cck = 'applicants'
AND t1.position LIKE '%Processor%'
ORDER BY t2.created DESC
LIMIT 25