ERROR:
QUERY:
SELECT c.blog, c1.id as cid,a.id, a.add_date, a.show_date,a.location, a.thumb,a.article_hash, a.right_thumb, a.title, a.alt_title, a.short, a.extra_narrow, a.extra_wide, a.show_date,c1.name as pub_name,c1.sef as pub_sef,a.author,a.short,c.name as cat_name,c.sef as cat_sef,(
SELECT SUM(aw.view) FROM vs_article_view aw WHERE aw.date>0 AND aw.type='0' AND aw.aid=a.id AND aw.date>=1744125173
) as view,COUNT(DISTINCT cm.id) as comment
FROM vs_article a
LEFT JOIN vs_category_article ca ON a.id=ca.aid
LEFT JOIN vs_category c ON ca.cid=c.id AND a.status=c.status
LEFT JOIN vs_comments cm ON cm.aid=a.id AND cm.is_spec='0' AND cm.status IN('1','2')
INNER JOIN vs_category_article ca1 ON a.id=ca1.aid
INNER JOIN vs_category c1 ON ca1.cid=c1.id AND c1.pid='1'
WHERE c.pid='2' AND c.status='1' AND show_date<=UNIX_TIMESTAMP()
GROUP BY a.id
ORDER BY view DESC
LIMIT 5 ERROR:
QUERY:
SELECT c.blog, c1.id as cid,a.id, a.add_date, a.show_date,a.location, a.thumb,a.article_hash, a.right_thumb, a.title, a.alt_title, a.short, a.extra_narrow, a.extra_wide, a.show_date,c1.name as pub_name,c1.sef as pub_sef,a.author,a.short,c.name as cat_name,c.sef as cat_sef,(
SELECT SUM(aw.view) FROM vs_article_view aw WHERE aw.date>0 AND aw.type='0' AND aw.aid=a.id AND aw.date>=1744125174
) as view,COUNT(DISTINCT cm.id) as comment
FROM vs_article a
LEFT JOIN vs_category_article ca ON a.id=ca.aid
LEFT JOIN vs_category c ON ca.cid=c.id AND a.status=c.status
LEFT JOIN vs_comments cm ON cm.aid=a.id AND cm.is_spec='0' AND cm.status IN('1','2')
INNER JOIN vs_category_article ca1 ON a.id=ca1.aid
INNER JOIN vs_category c1 ON ca1.cid=c1.id AND c1.pid='1'
WHERE c.pid='2' AND c.status='1' AND show_date<=UNIX_TIMESTAMP() AND a.editors_choise='1'
GROUP BY a.id
ORDER BY c1.ordering DESC,a.ordering ASC
LIMIT 3 ERROR:
QUERY:
SELECT a.location,a.title,a.short,a.show_date,a.start_date,a.end_date,c.name as cat_name,c.sef as cat_sef,a.id,a.thumb FROM vs_article a
INNER JOIN vs_category_article ca ON ca.aid=a.id
INNER JOIN vs_category c1 ON c1.id=ca.cid
INNER JOIN vs_theme_category tc ON tc.aid=c1.id
INNER JOIN vs_category c ON c.id=tc.cid
WHERE c1.pid='8' AND c.status='1' AND a.art_type='1' AND ( (a.start_date>=1746648000) OR ( (a.end_date IS NOT NULL AND a.end_date!=0) AND a.end_date>1746561600) ) AND a.status='1'
GROUP BY a.id
ORDER BY a.start_date
LIMIT 10
ERROR:
QUERY:
SELECT c.blog, c1.id as cid,a.id, a.add_date, a.show_date,a.location, a.thumb,a.article_hash, a.right_thumb, a.title, a.alt_title, a.short, a.extra_narrow, a.extra_wide, a.show_date,c1.name as pub_name,c1.sef as pub_sef,a.author,a.short,c.name as cat_name,c.sef as cat_sef,(
SELECT SUM(aw.view) FROM vs_article_view aw WHERE aw.date>0 AND aw.type='0' AND aw.aid=a.id AND aw.date>=1744125174
) as view,COUNT(DISTINCT cm.id) as comment
FROM vs_article a
LEFT JOIN vs_category_article ca ON a.id=ca.aid
LEFT JOIN vs_category c ON ca.cid=c.id AND a.status=c.status
LEFT JOIN vs_comments cm ON cm.aid=a.id AND cm.is_spec='0' AND cm.status IN('1','2')
INNER JOIN vs_category_article ca1 ON a.id=ca1.aid
INNER JOIN vs_category c1 ON ca1.cid=c1.id AND c1.pid='1'
WHERE c.pid='2' AND c.status='1' AND show_date<=UNIX_TIMESTAMP()
GROUP BY a.id
ORDER BY view DESC
LIMIT 5 ERROR:
QUERY:
SELECT c.blog, c1.id as cid,a.id, a.add_date, a.show_date,a.location, a.thumb,a.article_hash, a.right_thumb, a.title, a.alt_title, a.short, a.extra_narrow, a.extra_wide, a.show_date,c1.name as pub_name,c1.sef as pub_sef,a.author,a.short,c.name as cat_name,c.sef as cat_sef,(
SELECT SUM(aw.view) FROM vs_article_view aw WHERE aw.date>0 AND aw.type='0' AND aw.aid=a.id AND aw.date>=1744125174
) as view,COUNT(DISTINCT cm.id) as comment
FROM vs_article a
LEFT JOIN vs_category_article ca ON a.id=ca.aid
LEFT JOIN vs_category c ON ca.cid=c.id AND a.status=c.status
LEFT JOIN vs_comments cm ON cm.aid=a.id AND cm.is_spec='0' AND cm.status IN('1','2')
INNER JOIN vs_category_article ca1 ON a.id=ca1.aid
INNER JOIN vs_category c1 ON ca1.cid=c1.id AND c1.pid='1'
WHERE c.pid='2' AND c.status='1' AND show_date<=UNIX_TIMESTAMP() AND a.editors_choise='1'
GROUP BY a.id
ORDER BY c1.ordering DESC,a.ordering ASC
LIMIT 3 ERROR:
QUERY:
SELECT id, address, footer_address, latitude, longitude, fax, mail,phone FROM vs_contact LIMIT 1 ERROR:
QUERY:
SELECT m.*,
a.title as title_1,g.name as title_3,v.name as title_4,a.article_hash,
a.show_date as show_date_1,a.start_date,a.end_date,g.show_date as show_date_3,v.show_date as show_date_4,
a.short as short_1,g.short as short_3,v.short as short_4,
a.author as author_1,g.author as author_3,v.author as author_4,
c.sef,c.name,c.short
FROM vs_bx_slider m
LEFT JOIN vs_article a ON a.id=m.link
LEFT JOIN vs_video v ON v.id=m.link
LEFT JOIN vs_gallery g ON g.id=m.link
LEFT JOIN vs_category c ON c.id=m.cid
WHERE m.status='1' AND m.type='0'
ORDER BY ordering DESC
Society - page - 1 - Visions of Azerbaijan Magazine
