)
When you click on links to various merchants on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network.
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=23258 AND prd_visible=1 AND prd_date<=NOW()
