SELECT product_id FROM oc_product WHERE model like '%CXPNTURTLESPATTERNWATERCOLOR' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNTURTLESPATTERNWATERCOLOR' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNTURTLESPATTERNWATERCOLOR' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNTURTLESPATTERNWATERCOLOR' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNTURTLELINESONBLACK' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNTURTLELINESONBLACK' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNTURTLELINESONBLACK' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNTURTLELINESONBLACK' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNTURTLEUNDERWATER' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNTURTLEUNDERWATER' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNTURTLEUNDERWATER' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNTURTLEUNDERWATER' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNTURTLEAZTECWATERCOLOR' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNTURTLEAZTECWATERCOLOR' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNTURTLEAZTECWATERCOLOR' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNTURTLEAZTECWATERCOLOR' AND status=1SELECT product_id FROM oc_product WHERE model like '%TEMPGLASS' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'TEMPGLASS' AND status=1SELECT product_id FROM oc_product WHERE model like '%TEMPGLASS' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'TEMPGLASS' AND status=1SELECT product_id FROM oc_product WHERE model like '%LACETNOIR' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'LACETNOIR' AND status=1SELECT product_id FROM oc_product WHERE model like '%LACETNOIR' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'LACETNOIR' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER1824' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER1824' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER1824' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER1824' AND status=1SELECT product_id FROM oc_product WHERE model like '%TEMPPRIVACY' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'TEMPPRIVACY' AND status=1SELECT product_id FROM oc_product WHERE model like '%TEMPPRIVACY' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'TEMPPRIVACY' AND status=1SELECT product_id FROM oc_product WHERE model like '%GELTRANSPA' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'GELTRANSPA' AND status=1SELECT product_id FROM oc_product WHERE model like '%GELTRANSPA' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'GELTRANSPA' AND status=1SELECT product_id FROM oc_product WHERE model like '%FILMMAT' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'FILMMAT' AND status=1SELECT product_id FROM oc_product WHERE model like '%FILMMAT' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'FILMMAT' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNZENTIGER' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNZENTIGER' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNZENTIGER' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNZENTIGER' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNWHITETIGERBLUEEYE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNWHITETIGERBLUEEYE' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNWHITETIGERBLUEEYE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNWHITETIGERBLUEEYE' AND status=1SELECT product_id FROM oc_product WHERE model like '%PLASMATNOIR' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'PLASMATNOIR' AND status=1SELECT product_id FROM oc_product WHERE model like '%PLASMATNOIR' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'PLASMATNOIR' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNINCREDIBLELION' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNINCREDIBLELION' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNINCREDIBLELION' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNINCREDIBLELION' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNFLOWERFIELDART' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNFLOWERFIELDART' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNFLOWERFIELDART' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNFLOWERFIELDART' AND status=1SELECT product_id FROM oc_product WHERE model like '%CLEARVIEWBLEUCLAIR' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CLEARVIEWBLEUCLAIR' AND status=1SELECT product_id FROM oc_product WHERE model like '%CLEARVIEWBLEUCLAIR' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CLEARVIEWBLEUCLAIR' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNCARBONBASIC' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNCARBONBASIC' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNCARBONBASIC' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNCARBONBASIC' AND status=1SELECT product_id FROM oc_product WHERE model like '%TRANSFLOWERBLANC' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'TRANSFLOWERBLANC' AND status=1SELECT product_id FROM oc_product WHERE model like '%TRANSFLOWERBLANC' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'TRANSFLOWERBLANC' AND status=1SELECT product_id FROM oc_product WHERE model like '%WATERCASENOIR' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'WATERCASENOIR' AND status=1SELECT product_id FROM oc_product WHERE model like '%WATERCASENOIR' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'WATERCASENOIR' AND status=1SELECT product_id FROM oc_product WHERE model like '%FILMNORMAL' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'FILMNORMAL' AND status=1SELECT product_id FROM oc_product WHERE model like '%FILMNORMAL' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'FILMNORMAL' AND status=1SELECT product_id FROM oc_product WHERE model like '%360NOIRROUGE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = '360NOIRROUGE' AND status=1SELECT product_id FROM oc_product WHERE model like '%360NOIRROUGE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = '360NOIRROUGE' AND status=1SELECT product_id FROM oc_product WHERE model like '%360NOIR' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = '360NOIR' AND status=1SELECT product_id FROM oc_product WHERE model like '%360NOIR' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = '360NOIR' AND status=1SELECT product_id FROM oc_product WHERE model like '%RANDOM' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'RANDOM' AND status=1SELECT product_id FROM oc_product WHERE model like '%RANDOM' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'RANDOM' AND status=1SELECT product_id FROM oc_product WHERE model like '%FLIP2EN1BRUN' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'FLIP2EN1BRUN' AND status=1SELECT product_id FROM oc_product WHERE model like '%FLIP2EN1BRUN' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'FLIP2EN1BRUN' AND status=1SELECT product_id FROM oc_product WHERE model like '%FILMMIROIR' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'FILMMIROIR' AND status=1SELECT product_id FROM oc_product WHERE model like '%FILMMIROIR' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'FILMMIROIR' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNVINTAGEFLAGSWISS' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNVINTAGEFLAGSWISS' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNVINTAGEFLAGSWISS' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNVINTAGEFLAGSWISS' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNVINTAGEARTFLOWERS' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNVINTAGEARTFLOWERS' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNVINTAGEARTFLOWERS' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNVINTAGEARTFLOWERS' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNVASEBLACK' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNVASEBLACK' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNVASEBLACK' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNVASEBLACK' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNVALENTINE22ROSE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNVALENTINE22ROSE' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNVALENTINE22ROSE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNVALENTINE22ROSE' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNVALENTINE22MANYPINKHEARTS' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNVALENTINE22MANYPINKHEARTS' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNVALENTINE22MANYPINKHEARTS' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNVALENTINE22MANYPINKHEARTS' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNVALENTINE22BLACKSMOKE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNVALENTINE22BLACKSMOKE' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNVALENTINE22BLACKSMOKE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNVALENTINE22BLACKSMOKE' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNTRAVEL01' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNTRAVEL01' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNTRAVEL01' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNTRAVEL01' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNTOUTTRAVAILMERITESABIERE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNTOUTTRAVAILMERITESABIERE' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNTOUTTRAVAILMERITESABIERE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNTOUTTRAVAILMERITESABIERE' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNTIGERBLUERED' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNTIGERBLUERED' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNTIGERBLUERED' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNTIGERBLUERED' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUNSANDMOONS' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUNSANDMOONS' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUNSANDMOONS' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUNSANDMOONS' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER202118' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER202118' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER202118' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER202118' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER202116' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER202116' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER202116' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER202116' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER202115' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER202115' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER202115' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER202115' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER202112' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER202112' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER202112' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER202112' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER202107' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER202107' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER202107' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER202107' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER202106' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER202106' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER202106' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER202106' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER202101' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER202101' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER202101' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER202101' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER20COLLAGE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER20COLLAGE' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER20COLLAGE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER20COLLAGE' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER2015' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER2015' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER2015' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER2015' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER1819' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER1819' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSUMMER1819' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSUMMER1819' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSPRING1912' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSPRING1912' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSPRING1912' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSPRING1912' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSPLASHPAINT' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSPLASHPAINT' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSPLASHPAINT' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSPLASHPAINT' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSPACEVECTOR' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSPACEVECTOR' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSPACEVECTOR' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSPACEVECTOR' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSPACEDOODLE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSPACEDOODLE' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSPACEDOODLE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSPACEDOODLE' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSMILE05' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSMILE05' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSMILE05' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSMILE05' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSKULLSANDFLOWERS' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSKULLSANDFLOWERS' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSKULLSANDFLOWERS' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSKULLSANDFLOWERS' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSHIMMERINGORANGE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSHIMMERINGORANGE' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSHIMMERINGORANGE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSHIMMERINGORANGE' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSEAFOAMBLUE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSEAFOAMBLUE' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSEAFOAMBLUE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSEAFOAMBLUE' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSALNIKOVA05' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSALNIKOVA05' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNSALNIKOVA05' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNSALNIKOVA05' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNROARINGTIGER' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNROARINGTIGER' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNROARINGTIGER' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNROARINGTIGER' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNREDBLUECATGLASSES' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNREDBLUECATGLASSES' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNREDBLUECATGLASSES' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNREDBLUECATGLASSES' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNQSAFODA1' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNQSAFODA1' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNQSAFODA1' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNQSAFODA1' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNPURPLESKYWOLF' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNPURPLESKYWOLF' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNPURPLESKYWOLF' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNPURPLESKYWOLF' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNPURPLEPINKPINEAPPLE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNPURPLEPINKPINEAPPLE' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNPURPLEPINKPINEAPPLE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNPURPLEPINKPINEAPPLE' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNPRINCESSEENBASKET' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNPRINCESSEENBASKET' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNPRINCESSEENBASKET' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNPRINCESSEENBASKET' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNPINKFLAMINGOSPATTERN' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNPINKFLAMINGOSPATTERN' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNPINKFLAMINGOSPATTERN' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNPINKFLAMINGOSPATTERN' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNPAPILLONSBLEU' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNPAPILLONSBLEU' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNPAPILLONSBLEU' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNPAPILLONSBLEU' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNPALMTREESGOLDSTRIPES' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNPALMTREESGOLDSTRIPES' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNPALMTREESGOLDSTRIPES' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNPALMTREESGOLDSTRIPES' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNOCEANWAVES' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNOCEANWAVES' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNOCEANWAVES' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNOCEANWAVES' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNMOONFLOWERS' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNMOONFLOWERS' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNMOONFLOWERS' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNMOONFLOWERS' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNMONSTERAPLANT' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNMONSTERAPLANT' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNMONSTERAPLANT' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNMONSTERAPLANT' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNMONKEYPOPART' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNMONKEYPOPART' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNMONKEYPOPART' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNMONKEYPOPART' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNMOM1903' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNMOM1903' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNMOM1903' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNMOM1903' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNMIXEDCARTOONS' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNMIXEDCARTOONS' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNMIXEDCARTOONS' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNMIXEDCARTOONS' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNMEOW23' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNMEOW23' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNMEOW23' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNMEOW23' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNMAX2021WORLDCHAMPION' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNMAX2021WORLDCHAMPION' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNMAX2021WORLDCHAMPION' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNMAX2021WORLDCHAMPION' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNMARILYNBUBBLE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNMARILYNBUBBLE' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNMARILYNBUBBLE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNMARILYNBUBBLE' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNMARBLEROSEGOLD' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNMARBLEROSEGOLD' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNMARBLEROSEGOLD' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNMARBLEROSEGOLD' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNMARBLE04' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNMARBLE04' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNMARBLE04' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNMARBLE04' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNLIPSBULLET' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNLIPSBULLET' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNLIPSBULLET' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNLIPSBULLET' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNLIONLOOKINGUPNOIR' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNLIONLOOKINGUPNOIR' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNLIONLOOKINGUPNOIR' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNLIONLOOKINGUPNOIR' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNTRUCGLOBALEMENTBATSLESCOUILLES' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNTRUCGLOBALEMENTBATSLESCOUILLES' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNTRUCGLOBALEMENTBATSLESCOUILLES' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNTRUCGLOBALEMENTBATSLESCOUILLES' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNJOYFULHEARTS' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNJOYFULHEARTS' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNJOYFULHEARTS' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNJOYFULHEARTS' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNILOVEYOUMOM' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNILOVEYOUMOM' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNILOVEYOUMOM' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNILOVEYOUMOM' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNGIRLIAMAWOMAN' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNGIRLIAMAWOMAN' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNGIRLIAMAWOMAN' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNGIRLIAMAWOMAN' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNHELLOSEPT1119' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNHELLOSEPT1119' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNHELLOSEPT1119' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNHELLOSEPT1119' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNHALLOWEEN21WITCHCAT' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNHALLOWEEN21WITCHCAT' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNHALLOWEEN21WITCHCAT' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNHALLOWEEN21WITCHCAT' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNHALLOWEEN2021' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNHALLOWEEN2021' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNHALLOWEEN2021' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNHALLOWEEN2021' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNHALLOWEEN1909' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNHALLOWEEN1909' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNHALLOWEEN1909' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNHALLOWEEN1909' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNHALLOWEEN1819' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNHALLOWEEN1819' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNHALLOWEEN1819' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNHALLOWEEN1819' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNHALLOWEEN1715' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNHALLOWEEN1715' AND status=1SELECT product_id FROM oc_product WHERE model like '%CXPNHALLOWEEN1715' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'CXPNHALLOWEEN1715' AND status=1 iPhone 5/5s / SE (2016)

Hello Autumn ! -30% sur TOUT le site avec le code AUTUMN22 -

Livraison gratuite et rapide

Paiement sécurisé et sur facture

Service client gratuit 0800 808 800

iPhone 5/5s / SE (2016)

iPhone 5/5s / SE (2016)

Découvrez toutes nos coques et accessoires pour iPhone 5/5s / SE (2016) à des prix compétitifs et livrés gratuitement chez vous en quelques jours depuis notre stock en Suisse.

Trier par
Filtres
Filtres
  • Trier
      Trier
    • Popularité
    • Nouveautés
    • Prix croissant
    • Prix décroissant
    • Mieux notés
  • Couleur
      Couleur
    • Noir
    • Gris
    • Blanc
    • Bleu
    • Vert
    • Rouge
    • Rose
    • Violet
    • Brun
    • Multicolore
    • Transparent
  • Matière
      Matière
    • Plastique
    • Silicone (TPU)
    • Cuir synthétique
  • Prix
      Prix
      CHF
      CHF
    • Promos uniquement

155 produits

1 à 100 sur 155 (2 pages)