SELECT DISTINCT it.item_id, it.item_title, it.item_rating_moder, it.item_rating_users, it.item_favour, it.item_descr, it.item_meta_keywords, it.item_meta_descr, it.item_submit_date, it.item_display_ext, it.link_url, it.link_target, it.link_jumps_from, it.link_jumps_to, it.link_rating_pr, it.link_rating_cy, it.ext_text1, it.ext_text2, it.ext_text3, it.link_favicon_url, it.link_favicon_mime, it.item_type, it.item_com_count FROM cncat4_items it USE INDEX (submit_date) WHERE it.item_status=1 ORDER BY item_favour DESC, item_submit_date DESC, item_insert_date DESC LIMIT 3080, 20;
SELECT DISTINCT it.item_id, it.item_title, it.item_rating_moder, it.item_rating_users, it.item_favour, it.item_descr, it.item_meta_keywords, it.item_meta_descr, it.item_submit_date, it.item_display_ext, it.link_url, it.link_target, it.link_jumps_from, it.link_jumps_to, it.link_rating_pr, it.link_rating_cy, it.ext_text1, it.ext_text2, it.ext_text3, it.link_favicon_url, it.link_favicon_mime, it.item_type, it.item_com_count FROM cncat4_itemcat ic LEFT JOIN cncat4_items it USE INDEX (rating_users) on ic.item_id=it.item_id WHERE it.item_status=1 AND ic.cat_id=178 ORDER BY item_favour_neg, item_rating_users_neg, item_title LIMIT 40, 20;
SELECT DISTINCT it.item_id, it.item_title, it.item_rating_moder, it.item_rating_users, it.item_favour, it.item_descr, it.item_meta_keywords, it.item_meta_descr, it.item_submit_date, it.item_display_ext, it.link_url, it.link_target, it.link_jumps_from, it.link_jumps_to, it.link_rating_pr, it.link_rating_cy, it.ext_text1, it.ext_text2, it.ext_text3, it.link_favicon_url, it.link_favicon_mime, it.item_type, it.item_com_count FROM cncat4_items it USE INDEX (title) WHERE it.item_status=1 AND it.item_type = 0 ORDER BY item_favour_neg, item_title LIMIT 960, 20;
SELECT DISTINCT it.item_id, it.item_title, it.item_rating_moder, it.item_rating_users, it.item_favour, it.item_descr, it.item_meta_keywords, it.item_meta_descr, it.item_submit_date, it.item_display_ext, it.link_url, it.link_target, it.link_jumps_from, it.link_jumps_to, it.link_rating_pr, it.link_rating_cy, it.ext_text1, it.ext_text2, it.ext_text3, it.link_favicon_url, it.link_favicon_mime, it.item_type, it.item_com_count FROM cncat4_items it USE INDEX (rating_moder) WHERE it.item_status=1 ORDER BY item_favour_neg, item_rating_moder_neg, item_title LIMIT 560, 20;
SELECT DISTINCT it.item_id, it.item_title, it.item_rating_moder, it.item_rating_users, it.item_favour, it.item_descr, it.item_meta_keywords, it.item_meta_descr, it.item_submit_date, it.item_display_ext, it.link_url, it.link_target, it.link_jumps_from, it.link_jumps_to, it.link_rating_pr, it.link_rating_cy, it.ext_text1, it.ext_text2, it.ext_text3, it.link_favicon_url, it.link_favicon_mime, it.item_type, it.item_com_count FROM cncat4_items it USE INDEX (rating_cy) WHERE it.item_status=1 AND it.item_type = 1 ORDER BY item_favour_neg, link_rating_cy_neg, item_title LIMIT 0, 20;
SELECT DISTINCT it.item_id, it.item_title, it.item_rating_moder, it.item_rating_users, it.item_favour, it.item_descr, it.item_meta_keywords, it.item_meta_descr, it.item_submit_date, it.item_display_ext, it.link_url, it.link_target, it.link_jumps_from, it.link_jumps_to, it.link_rating_pr, it.link_rating_cy, it.ext_text1, it.ext_text2, it.ext_text3, it.link_favicon_url, it.link_favicon_mime, it.item_type, it.item_com_count FROM cncat4_itemcat ic LEFT JOIN cncat4_items it USE INDEX (title) on ic.item_id=it.item_id WHERE it.item_status=1 AND ic.cat_id in (90,243,242,245,244) ORDER BY item_favour_neg, item_title LIMIT 180, 20;
SELECT DISTINCT it.item_id, it.item_title, it.item_rating_moder, it.item_rating_users, it.item_favour, it.item_descr, it.item_meta_keywords, it.item_meta_descr, it.item_submit_date, it.item_display_ext, it.link_url, it.link_target, it.link_jumps_from, it.link_jumps_to, it.link_rating_pr, it.link_rating_cy, it.ext_text1, it.ext_text2, it.ext_text3, it.link_favicon_url, it.link_favicon_mime, it.item_type, it.item_com_count FROM cncat4_items it USE INDEX (submit_date) WHERE it.item_status=1 AND it.item_type = 1 ORDER BY item_favour DESC, item_submit_date DESC, item_insert_date DESC LIMIT 0, 20;
SELECT DISTINCT it.item_id, it.item_title, it.item_rating_moder, it.item_rating_users, it.item_favour, it.item_descr, it.item_meta_keywords, it.item_meta_descr, it.item_submit_date, it.item_display_ext, it.link_url, it.link_target, it.link_jumps_from, it.link_jumps_to, it.link_rating_pr, it.link_rating_cy, it.ext_text1, it.ext_text2, it.ext_text3, it.link_favicon_url, it.link_favicon_mime, it.item_type, it.item_com_count FROM cncat4_items it USE INDEX (rating_moder) WHERE it.item_status=1 AND it.item_type = 0 ORDER BY item_favour_neg, item_rating_moder_neg, item_title LIMIT 2200, 20;
SELECT DISTINCT it.item_id, it.item_title, it.item_rating_moder, it.item_rating_users, it.item_favour, it.item_descr, it.item_meta_keywords, it.item_meta_descr, it.item_submit_date, it.item_display_ext, it.link_url, it.link_target, it.link_jumps_from, it.link_jumps_to, it.link_rating_pr, it.link_rating_cy, it.ext_text1, it.ext_text2, it.ext_text3, it.link_favicon_url, it.link_favicon_mime, it.item_type, it.item_com_count FROM cncat4_itemcat ic LEFT JOIN cncat4_items it USE INDEX (title) on ic.item_id=it.item_id WHERE it.item_status=1 AND it.item_type = 0 AND ic.cat_id=153 ORDER BY item_favour_neg, item_title LIMIT 20, 20;
SELECT DISTINCT it.item_id, it.item_title, it.item_rating_moder, it.item_rating_users, it.item_favour, it.item_descr, it.item_meta_keywords, it.item_meta_descr, it.item_submit_date, it.item_display_ext, it.link_url, it.link_target, it.link_jumps_from, it.link_jumps_to, it.link_rating_pr, it.link_rating_cy, it.ext_text1, it.ext_text2, it.ext_text3, it.link_favicon_url, it.link_favicon_mime, it.item_type, it.item_com_count FROM cncat4_itemcat ic LEFT JOIN cncat4_items it USE INDEX (rating_cy) on ic.item_id=it.item_id WHERE it.item_status=1 AND it.item_type = 0 AND ic.cat_id in (112,194,195,196,197,198,199) ORDER BY item_favour_neg, link_rating_cy_neg, item_title LIMIT 80, 20;