SELECT vmguld_posts.*,
vmguld_post_attributes.name AS attribute_names,
vmguld_post_attributes.value AS attribute_values,
COUNT(vmguld_comments.id) AS comment_count,
MAX(vmguld_comments.created_at) AS latest_comment
FROM vmguld_posts
LEFT JOIN vmguld_post_attributes ON (vmguld_post_attributes.post_id = vmguld_posts.id)
LEFT JOIN vmguld_comments ON (vmguld_comments.post_id = vmguld_posts.id)
AND (vmguld_comments.status != 'spam')
AND (vmguld_comments.status != 'denied' OR (
(
vmguld_comments.user_id != 0 AND
vmguld_comments.user_id = 0
) OR (
vmguld_comments.id IN (0)
)
))
WHERE (vmguld_posts.feather IN ('text'))
AND (vmguld_posts.status IN ('public') OR vmguld_posts.status LIKE '%{5}%')
AND (vmguld_posts.id = 13)
GROUP BY vmguld_posts.id,
vmguld_post_attributes.name
ORDER BY vmguld_posts.id DESC
Array
(
[:visitor_id] => 0
[:id] => 13
)
#0 /usr/home/web/wse170943/beta/includes/class/SQL.php(201): Query->__construct(Object(SQL), 'SELECT vmguld_p...', Array, false)
#1 /usr/home/web/wse170943/beta/includes/class/SQL.php(238): SQL->query('SELECT __posts....', Array, false)
#2 /usr/home/web/wse170943/beta/includes/class/Model.php(163): SQL->select(Array, Array, Array, 'id DESC', Array, NULL, NULL, Array, Array)
#3 /usr/home/web/wse170943/beta/includes/model/Post.php(72): Model::grab(Object(Post), '13', Array)
#4 /usr/home/web/wse170943/beta/modules/comments/model.Comment.php(301): Post->__construct('13')
#5 [internal function]: Comment->post()
#6 /usr/home/web/wse170943/beta/includes/class/Twig/runtime.php(150): call_user_func(Array)
#7 /usr/home/web/wse170943/beta/includes/class/Twig/api.php(162) : eval()'d code(48): twig_get_attribute(Object(Comment), 'post')
#8 /usr/home/web/wse170943/beta/includes/class/Twig/api.php(78): __TwigTemplate_9f47863d3656728b0f160b57e8d0e311->render(Array)
#9 /usr/home/web/wse170943/beta/includes/class/Twig/api.php(162) : eval()'d code(167): Twig_Template->display(Array)
#10 /usr/home/web/wse170943/beta/includes/class/Twig/api.php(78): __TwigTemplate_c19a24ba4c4f488924cc287729ac8d39->render(Array)
#11 /usr/home/web/wse170943/beta/includes/controller/Main.php(708): Twig_Template->display(Array)
#12 /usr/home/web/wse170943/beta/includes/controller/Main.php(650): MainController->display('pages/tag', Array, 'Posts tagged wi...')
#13 /usr/home/web/wse170943/beta/modules/tags/tags.php(382): MainController->display(Array, Array, 'Posts tagged wi...')
#14 [internal function]: Tags->main_tag(Object(MainController))
#15 /usr/home/web/wse170943/beta/includes/class/Trigger.php(69): call_user_func_array(Array, Array)
#16 [internal function]: Trigger->call('main_tag', Object(MainController))
#17 /usr/home/web/wse170943/beta/includes/class/Trigger.php(45): call_user_func_array(Array, Array)
#18 /usr/home/web/wse170943/beta/includes/class/Route.php(94): Trigger->call(Array, Object(MainController))
#19 /usr/home/web/wse170943/beta/index.php(22): Route->init()
#20 {main}
Log In →
Chyrp 2.0 RC3 © 2008 Alex Suraci