אין לך הרשאה לראות קוד זה.
אתה נדרש להכניס שם משתמש וסיסמה
|
|
|
SELECT a.id , a.title, a.sectionid , a.catid , a.created as created, created_by, a.created_by_alias, a.hits, a.images,round( v.rating_sum / v.rating_count ) AS rating, v.rating_count
FROM #__content AS a
JOIN #__users AS c ON c.id = a.created_by
JOIN #__sections AS d ON d.id = a.sectionid
JOIN #__categories AS e ON e.id = a.catid
LEFT JOIN #__content_rating AS v ON a.id = v.content_id
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 (88) )
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
|
|
|
