SELECT 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 a365_cat_item_models s1
LEFT JOIN a365_cat_price p1 ON s1.item_id=p1.item_id AND s1.id=p1.subm_id
WHERE s1.item_id='296310'
ORDER BY s1.sort_num, s1.modelMySQL server has gone away
SELECT count(*) as totcomments FROM a365_cat_item_comment WHERE prod_id='293245' AND visible=1 MySQL server has gone awaySELECT avg(rate) as avgrate FROM a365_cat_item_comment WHERE prod_id='293245' 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 a365_cat_item_models s1
LEFT JOIN a365_cat_price p1 ON s1.item_id=p1.item_id AND s1.id=p1.subm_id
WHERE s1.item_id='293245'
ORDER BY s1.sort_num, s1.modelMySQL server has gone away
SELECT count(*) as totcomments FROM a365_cat_item_comment WHERE prod_id='293246' AND visible=1 MySQL server has gone awaySELECT avg(rate) as avgrate FROM a365_cat_item_comment WHERE prod_id='293246' 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 a365_cat_item_models s1
LEFT JOIN a365_cat_price p1 ON s1.item_id=p1.item_id AND s1.id=p1.subm_id
WHERE s1.item_id='293246'
ORDER BY s1.sort_num, s1.modelMySQL server has gone away
SELECT count(*) as totcomments FROM a365_cat_item_comment WHERE prod_id='293247' AND visible=1 MySQL server has gone awaySELECT avg(rate) as avgrate FROM a365_cat_item_comment WHERE prod_id='293247' 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 a365_cat_item_models s1
LEFT JOIN a365_cat_price p1 ON s1.item_id=p1.item_id AND s1.id=p1.subm_id
WHERE s1.item_id='293247'
ORDER BY s1.sort_num, s1.modelMySQL server has gone away
SELECT count(*) as totcomments FROM a365_cat_item_comment WHERE prod_id='320671' AND visible=1 MySQL server has gone awaySELECT avg(rate) as avgrate FROM a365_cat_item_comment WHERE prod_id='320671' 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 a365_cat_item_models s1
LEFT JOIN a365_cat_price p1 ON s1.item_id=p1.item_id AND s1.id=p1.subm_id
WHERE s1.item_id='320671'
ORDER BY s1.sort_num, s1.modelMySQL server has gone away
SELECT count(*) as totcomments FROM a365_cat_item_comment WHERE prod_id='321188' AND visible=1 MySQL server has gone awaySELECT avg(rate) as avgrate FROM a365_cat_item_comment WHERE prod_id='321188' 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 a365_cat_item_models s1
LEFT JOIN a365_cat_price p1 ON s1.item_id=p1.item_id AND s1.id=p1.subm_id
WHERE s1.item_id='321188'
ORDER BY s1.sort_num, s1.modelMySQL server has gone away
SELECT count(*) as totcomments FROM a365_cat_item_comment WHERE prod_id='320954' AND visible=1 MySQL server has gone awaySELECT avg(rate) as avgrate FROM a365_cat_item_comment WHERE prod_id='320954' 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 a365_cat_item_models s1
LEFT JOIN a365_cat_price p1 ON s1.item_id=p1.item_id AND s1.id=p1.subm_id
WHERE s1.item_id='320954'
ORDER BY s1.sort_num, s1.modelMySQL server has gone away
SELECT count(*) as totcomments FROM a365_cat_item_comment WHERE prod_id='299478' AND visible=1 MySQL server has gone awaySELECT avg(rate) as avgrate FROM a365_cat_item_comment WHERE prod_id='299478' 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 a365_cat_item_models s1
LEFT JOIN a365_cat_price p1 ON s1.item_id=p1.item_id AND s1.id=p1.subm_id
WHERE s1.item_id='299478'
ORDER BY s1.sort_num, s1.modelMySQL server has gone away