Gallery
SELECT img.img_id,
img.img_lg_filename,
img.img_sm_filename,
img.img_sm_w,
img.img_sm_h,
img.img_lg_w,
img.img_lg_h,
img.img_alt,
img.img_keywords,
img.img_price,
img.img_featured_x,
img.img_description ,
imgcat.ic_id,
imgcat.cat_id,
imgcat.img_pos_id FROM pv_images img
JOIN pv_imagecat imgcat ON (img.img_id = imgcat.img_id AND imgcat.cat_id = "4") WHERE 1 ORDER BY img_pos_id
