SmartCJ Support Forum

Code: Select all

# Time: 160602 8:49:22
# User@Host: домен[домен] @ localhost []
# Thread_id: 132 Schema: домен QC_hit: No
# Query_time: 23.345392 Lock_time: 10.951448 Rows_sent: 724 Rows_examined: 4108544
SET timestamp=1464871762;
SELECT gr.name as category_name, gr_data.custom_name as category_custom_name, gr_data.description as category_description, gr.id as category_id, gr_data.group_keywords,
gr_data.group_custom_var1, gr_data.group_custom_var2, gr_data.group_custom_var3, gr_data.status as group_status, gr.parent_id, tmp.*
FROM rot_groups AS gr
JOIN rot_groups_data AS gr_data ON gr_data.group_id = gr.id and gr_data.site_id = '5'

LEFT OUTER JOIN (
SELECT gi.url, g.*, gs.total_shows, gs.total_ctr, gd.alt, gd.description FROM rot_gallery_info AS gi

JOIN rot_galleries AS g ON g.gallery_md5 = gi.gallery_md5 and g.rgroup = 0 and g.sponsor_id = 0 and content_type = '0'

JOIN rot_gallery_stats5 as gs on gs.thumb_id = g.id

JOIN rot_gallery_data5 AS gd ON gd.gallery_md5 = g.gallery_md5

WHERE gi.url != 0 and gi.source_url = '5' ) as tmp ON tmp.url = gr.id
WHERE gr.group_type = 'rotation'

order by total_ctr desc;