SELECT object_id, thread_id, type, object_type, company_id FROM cscart_discussion WHERE 1 AND object_id = 194 AND object_type = 'C' AND cscart_discussion.company_id = 1
SELECT thread_id, type, object_type, object_id FROM cscart_discussion WHERE thread_id = 253 AND cscart_discussion.company_id = 1
SELECT AVG (dr.rating_value) FROM cscart_discussion_rating AS dr LEFT JOIN cscart_discussion_posts AS dp ON dp.post_id = dr.post_id LEFT JOIN cscart_discussion AS d ON d.thread_id = dp.thread_id WHERE d.object_id = 194 AND d.object_type = 'C' AND type IN ( 'B', 'R' ) AND d.company_id = 1 AND dp.status = 'A' AND dr.rating_value > 0
SELECT cscart_discussion_rating.* FROM cscart_discussion_rating LEFT JOIN cscart_discussion_posts ON cscart_discussion_posts.post_id = cscart_discussion_rating.post_id WHERE 1 AND cscart_discussion_rating.thread_id = 253 AND cscart_discussion_posts.status = 'A' ORDER BY cscart_discussion_rating.rating_value DESC
SELECT a1.description FROM cscart_alt_statuses a LEFT JOIN cscart_alt_statuses_descriptions a1 ON a.status_id=a1.status_id WHERE a.lower_limit <=14 AND a.product_id = 29857 AND a1.lang_code='es' ORDER BY a.lower_limit DESC LIMIT 1
SELECT a1.description FROM cscart_alt_statuses a LEFT JOIN cscart_alt_statuses_descriptions a1 ON a.status_id=a1.status_id WHERE a.lower_limit <=10 AND a.product_id = 30180 AND a1.lang_code='es' ORDER BY a.lower_limit DESC LIMIT 1
SELECT a1.description FROM cscart_alt_statuses a LEFT JOIN cscart_alt_statuses_descriptions a1 ON a.status_id=a1.status_id WHERE a.lower_limit <=9 AND a.product_id = 30340 AND a1.lang_code='es' ORDER BY a.lower_limit DESC LIMIT 1
SELECT a1.description FROM cscart_alt_statuses a LEFT JOIN cscart_alt_statuses_descriptions a1 ON a.status_id=a1.status_id WHERE a.lower_limit <=13 AND a.product_id = 30319 AND a1.lang_code='es' ORDER BY a.lower_limit DESC LIMIT 1
SELECT a1.description FROM cscart_alt_statuses a LEFT JOIN cscart_alt_statuses_descriptions a1 ON a.status_id=a1.status_id WHERE a.lower_limit <=8 AND a.product_id = 29796 AND a1.lang_code='es' ORDER BY a.lower_limit DESC LIMIT 1
SELECT a1.description FROM cscart_alt_statuses a LEFT JOIN cscart_alt_statuses_descriptions a1 ON a.status_id=a1.status_id WHERE a.lower_limit <=1 AND a.product_id = 30338 AND a1.lang_code='es' ORDER BY a.lower_limit DESC LIMIT 1
SELECT a1.description FROM cscart_alt_statuses a LEFT JOIN cscart_alt_statuses_descriptions a1 ON a.status_id=a1.status_id WHERE a.lower_limit <=7 AND a.product_id = 30097 AND a1.lang_code='es' ORDER BY a.lower_limit DESC LIMIT 1
SELECT a1.description FROM cscart_alt_statuses a LEFT JOIN cscart_alt_statuses_descriptions a1 ON a.status_id=a1.status_id WHERE a.lower_limit <=7 AND a.product_id = 30266 AND a1.lang_code='es' ORDER BY a.lower_limit DESC LIMIT 1