{"id":1260,"date":"2013-06-13T13:17:42","date_gmt":"2013-06-13T13:17:42","guid":{"rendered":"https:\/\/www.jose-aguilar.com\/blog\/?p=1260"},"modified":"2019-03-07T11:48:23","modified_gmt":"2019-03-07T11:48:23","slug":"sentencia-not-in-en-sql","status":"publish","type":"post","link":"https:\/\/www.jose-aguilar.com\/blog\/sentencia-not-in-en-sql\/","title":{"rendered":"Sentencia NOT IN en SQL"},"content":{"rendered":"<p>En algunos casos cuando estamos creando un sitio e-commerce por ejemplo y deseamos mostrar productos destacados y nuevos en p\u00e1gina de inicio pudiera darse el caso de que se duplicara alg\u00fan producto que est\u00e9 como destacado y que adem\u00e1s sea nuevo.<\/p>\n<p>En SQL se puede excluir de una consulta varios elementos de la siguiente forma:<\/p>\n<pre>SELECT * FROM products WHERE `id_product` NOT IN (1,2,3,4,7,9)<\/pre>\n<p>La consulta anterior te rotornar\u00eda todos los productos de tu tienda sin incluir los que tengan como id 1,2,3,4,7 0 9.<\/p>\n<p>Con este problema me he visto programando con Oscommerce por ejemplo y su soluci\u00f3n fue:<\/p>\n<p>Los productos destacados los recoger\u00edamos de la siguiente forma:<\/p>\n<pre>$featured_products_query = tep_db_query(\"select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from \" . TABLE_PRODUCTS . \" p left join \" . TABLE_SPECIALS . \" s on p.products_id = s.products_id, \" . TABLE_PRODUCTS_TO_CATEGORIES . \" p2c, \" . TABLE_CATEGORIES . \" c left join \" . TABLE_FEATURED . \" f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '\" . $featured_products_category_id . \"' and p.products_status = '1' and f.status = '1' order by rand() DESC limit \" . MAX_DISPLAY_FEATURED_PRODUCTS);\r\n\r\nwhile ($featured_products = tep_db_fetch_array($featured_products_query)) {\r\n$array_ids_featured[] = $featured_products['products_id'];\r\n\r\n...\r\n\r\n}<\/pre>\n<p>F\u00edjate que estamos guardando en un array los ids de los productos destacados.\u00a0 Y la consulta para visualizar los nuevos productos la har\u00edamos as\u00ed:<\/p>\n<pre>$new_products_query = tep_db_query(\"select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, p.products_price, s.specials_new_products_price from \" . TABLE_PRODUCTS . \" p left join \" . TABLE_SPECIALS . \" s on p.products_id = s.products_id, \" . TABLE_PRODUCTS_DESCRIPTION . \" pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '\" . (int)$languages_id . \"' and p.products_id NOT IN ('\" . (count($array_ids_featured) &gt; 0 ? implode(\",\", $array_ids_featured):0) . \"') order by RAND() limit \" . MAX_DISPLAY_NEW_PRODUCTS);<\/pre>\n<p>Estamos cogiendo todos los productos nuevos que no aparezcan en destacados.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>En algunos casos cuando estamos creando un sitio e-commerce por ejemplo y deseamos mostrar productos destacados y nuevos en p\u00e1gina de inicio pudiera darse el caso de que se duplicara alg\u00fan producto que est\u00e9 como destacado y que adem\u00e1s sea nuevo. En SQL se puede excluir de una consulta varios elementos de la siguiente forma: [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":6016,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-1260","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Sentencia NOT IN en SQL - Jose Aguilar Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sentencia NOT IN en SQL - Jose Aguilar Blog\" \/>\n<meta property=\"og:description\" content=\"En algunos casos cuando estamos creando un sitio e-commerce por ejemplo y deseamos mostrar productos destacados y nuevos en p\u00e1gina de inicio pudiera darse el caso de que se duplicara alg\u00fan producto que est\u00e9 como destacado y que adem\u00e1s sea nuevo. En SQL se puede excluir de una consulta varios elementos de la siguiente forma: [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.jose-aguilar.com\/blog\/sentencia-not-in-en-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Jose Aguilar Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/joseaguilarblog\" \/>\n<meta property=\"article:published_time\" content=\"2013-06-13T13:17:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-03-07T11:48:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/sql.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"225\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jose Aguilar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@JoseAguilarBlog\" \/>\n<meta name=\"twitter:site\" content=\"@JoseAguilarBlog\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jose Aguilar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/sentencia-not-in-en-sql\/\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/sentencia-not-in-en-sql\/\",\"name\":\"Sentencia NOT IN en SQL - Jose Aguilar Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/sentencia-not-in-en-sql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/sentencia-not-in-en-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/sql.jpg\",\"datePublished\":\"2013-06-13T13:17:42+00:00\",\"dateModified\":\"2019-03-07T11:48:23+00:00\",\"author\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/sentencia-not-in-en-sql\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.jose-aguilar.com\/blog\/sentencia-not-in-en-sql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/sentencia-not-in-en-sql\/#primaryimage\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/sql.jpg\",\"contentUrl\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/sql.jpg\",\"width\":300,\"height\":225},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/sentencia-not-in-en-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/www.jose-aguilar.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sentencia NOT IN en SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#website\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/\",\"name\":\"Jose Aguilar Blog\",\"description\":\"Desarrollo Web con PrestaShop, WordPress, PHP, jQuery y Ajax\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.jose-aguilar.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11\",\"name\":\"Jose Aguilar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g\",\"caption\":\"Jose Aguilar\"},\"description\":\"Director ejecutivo y tecnol\u00f3gico en JA Modules. Experto programador PrestaShop y Experto programador WordPress.\",\"sameAs\":[\"https:\/\/plus.google.com\/114357189801512615537\"],\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/author\/josea902\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Sentencia NOT IN en SQL - Jose Aguilar Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"es_ES","og_type":"article","og_title":"Sentencia NOT IN en SQL - Jose Aguilar Blog","og_description":"En algunos casos cuando estamos creando un sitio e-commerce por ejemplo y deseamos mostrar productos destacados y nuevos en p\u00e1gina de inicio pudiera darse el caso de que se duplicara alg\u00fan producto que est\u00e9 como destacado y que adem\u00e1s sea nuevo. En SQL se puede excluir de una consulta varios elementos de la siguiente forma: [&hellip;]","og_url":"https:\/\/www.jose-aguilar.com\/blog\/sentencia-not-in-en-sql\/","og_site_name":"Jose Aguilar Blog","article_publisher":"https:\/\/www.facebook.com\/joseaguilarblog","article_published_time":"2013-06-13T13:17:42+00:00","article_modified_time":"2019-03-07T11:48:23+00:00","og_image":[{"width":300,"height":225,"url":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/sql.jpg","type":"image\/jpeg"}],"author":"Jose Aguilar","twitter_card":"summary_large_image","twitter_creator":"@JoseAguilarBlog","twitter_site":"@JoseAguilarBlog","twitter_misc":{"Escrito por":"Jose Aguilar","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.jose-aguilar.com\/blog\/sentencia-not-in-en-sql\/","url":"https:\/\/www.jose-aguilar.com\/blog\/sentencia-not-in-en-sql\/","name":"Sentencia NOT IN en SQL - Jose Aguilar Blog","isPartOf":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/sentencia-not-in-en-sql\/#primaryimage"},"image":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/sentencia-not-in-en-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/sql.jpg","datePublished":"2013-06-13T13:17:42+00:00","dateModified":"2019-03-07T11:48:23+00:00","author":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11"},"breadcrumb":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/sentencia-not-in-en-sql\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.jose-aguilar.com\/blog\/sentencia-not-in-en-sql\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.jose-aguilar.com\/blog\/sentencia-not-in-en-sql\/#primaryimage","url":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/sql.jpg","contentUrl":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2013\/06\/sql.jpg","width":300,"height":225},{"@type":"BreadcrumbList","@id":"https:\/\/www.jose-aguilar.com\/blog\/sentencia-not-in-en-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.jose-aguilar.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Sentencia NOT IN en SQL"}]},{"@type":"WebSite","@id":"https:\/\/www.jose-aguilar.com\/blog\/#website","url":"https:\/\/www.jose-aguilar.com\/blog\/","name":"Jose Aguilar Blog","description":"Desarrollo Web con PrestaShop, WordPress, PHP, jQuery y Ajax","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.jose-aguilar.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11","name":"Jose Aguilar","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g","caption":"Jose Aguilar"},"description":"Director ejecutivo y tecnol\u00f3gico en JA Modules. Experto programador PrestaShop y Experto programador WordPress.","sameAs":["https:\/\/plus.google.com\/114357189801512615537"],"url":"https:\/\/www.jose-aguilar.com\/blog\/author\/josea902\/"}]}},"_links":{"self":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts\/1260","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/comments?post=1260"}],"version-history":[{"count":0,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts\/1260\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/media\/6016"}],"wp:attachment":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/media?parent=1260"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/categories?post=1260"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/tags?post=1260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}