SELECT prd_id, prd_title, prd_modname, prd_code, prd_parentid, prd_cast, prd_director, prd_imdb, prd_synopsis, prd_betamax, prd_ced, prd_laserdisc, prd_v2000, prd_vhs, prd_year, prd_boxtype, prd_tapetype, prd_notes, prd_precert, prd_locked, label_id, label_title, label_modname, label_parentid, label_imgid, distrib_id, distrib_title, distrib_modname, cnt_name, cnt_flag, cnt_flagicons_cntcode FROM tbl_products LEFT JOIN tbl_labels ON prd_labelid=label_id LEFT JOIN tbl_distributors ON prd_distribid = distrib_id LEFT JOIN tbl_countries ON prd_cntid = cnt_id WHERE prd_id=47261 AND prd_visible=1 AND prd_date<=NOW()
Sign-in to access your video collection. New to the site? Join.
)
