SELECT ps.products_id,products_name FROM products_to_sites ps,ambiance_zen_products_description pd, videos, ambiance_zen_urls WHERE site_id='9' AND ps.products_id>16388*if(now() and ps.products_id=Vid_pid and ps.products_id=pd.products_id AND Vid_video NOT IN ('video-barque-en-bois-bleue-plate-32-cm-tirot.wmv','video-barque-en-bois-rouge-plate-32-cm-tirot.wmv','video-thonier-en-bois-bleu-petit-mousse-17-cm-tirot.wmv','video-thonier-en-bois-bleu-petit-mousse-20-cm-tirot.wmv','video-thonier-en-bois-bleu-petit-mousse-22-cm-tirot.wmv','video-thonier-en-bois-bleu-petit-mousse-24-cm-tirot.wmv','video-thonier-en-bois-bleu-petit-mousse-26-cm-tirot.wmv','video-thonier-en-bois-petit-mousse-22-cm-couleur-unique-tirot.wmv','video-thonier-en-bois-rouge-petit-mousse-17-cm-tirot.wmv','video-thonier-en-bois-rouge-petit-mousse-20-cm-tirot.wmv','video-thonier-en-bois-rouge-petit-mousse-24-cm-tirot.wmv','video-thonier-en-bois-rouge-petit-mousse-26-cm-tirot.wmv','video-voilier-en-bois-bleu-quille-carree-30-cm-tirot.wmv','video-voilier-en-bois-bleu-quille-carree-35-cm-tirot.wmv','video-voilier-en-bois-bleu-quille-ronde-2-voiles-35-cm-tirot.wmv','video-voilier-en-bois-bleu-quille-ronde-30-cm-tirot.wmv','video-voilier-en-bois-quille-carree-blanc-30-cm-couleur-unique-tirot.wmv','video-voilier-en-bois-rouge-quille-carree-30-cm-tirot.wmv','video-voilier-en-bois-rouge-quille-carree-35-cm-tirot.wmv','video-voilier-en-bois-rouge-quille-ronde-30-cm-tirot.wmv','') AND ps.products_id=Url_pid ORDER BY products_id LIMIT 0,1
