|
|
|
SELECT a.id , a.title, a.sectionid , a.catid , a.created as created
FROM #__content AS a
LEFT JOIN #__users AS c ON c.id = a.created_by
LEFT JOIN #__sections AS d ON d.id = a.sectionid
LEFT JOIN #__categories AS e ON e.id = a.catid
WHERE (a.state = '1')
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= NOW())
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= NOW())
AND (d.published = '1')
AND (e.published = '1')
AND ((a.created_by_alias IN ('אסתר שניאורסן')) OR
((a.created_by_alias = '' ) AND ( c.name IN ('אסתר שניאורסן'))) )
AND a.access <= '0'
ORDER BY created DESC
LIMIT 0, 5
The parameters you have activated
do not correspond with any content items.
Please reconfigure your parameters
|
SELECT a.id , a.title, a.sectionid , a.catid , a.created as created, created_by, a.created_by_alias
FROM #__content AS a
LEFT JOIN #__users AS c ON c.id = a.created_by
LEFT JOIN #__sections AS d ON d.id = a.sectionid
LEFT JOIN #__categories AS e ON e.id = a.catid
WHERE (a.state = '1')
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= NOW())
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= NOW())
AND (d.published = '1')
AND (e.published = '1')
AND (a.catid IN (96) )
AND a.access <= '0'
ORDER BY created DESC
LIMIT 0, 5
The parameters you have activated
do not correspond with any content items.
Please reconfigure your parameters
|
|
|
