Знайдено 2 товари
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='214' AND visible=1 MySQL server has gone awaySELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='214' AND visible=1 MySQL server has gone awaySELECT s1.*, p1.id as prid, p1.currency_id, p1.currency_price, p1.currency_price2, p1.discval, p1.price, p1.price2, p1.price3, p1.price4, p1.availiable_now, p1.bonus
FROM dst_cat_item_models s1
LEFT JOIN dst_cat_price p1 ON s1.item_id=p1.item_id AND s1.id=p1.subm_id
WHERE s1.item_id='214'
ORDER BY s1.sort_num, s1.modelMySQL server has gone away
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='230' AND visible=1 MySQL server has gone awaySELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='230' AND visible=1 MySQL server has gone awaySELECT s1.*, p1.id as prid, p1.currency_id, p1.currency_price, p1.currency_price2, p1.discval, p1.price, p1.price2, p1.price3, p1.price4, p1.availiable_now, p1.bonus
FROM dst_cat_item_models s1
LEFT JOIN dst_cat_price p1 ON s1.item_id=p1.item_id AND s1.id=p1.subm_id
WHERE s1.item_id='230'
ORDER BY s1.sort_num, s1.modelMySQL server has gone away