SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    85113, 78852, 6427, 2237, 2236, 2235, 
    2231, 2233, 2232, 6665, 2227, 2230, 
    2228, 42056, 2225, 6642, 2226, 6457, 
    2223, 2222, 2211, 2221, 2220, 2217, 
    2216, 2214, 2213, 2212, 2218, 2219, 
    2194, 2210, 2209, 2208, 2207, 2206, 
    2205, 2204, 2203, 2202, 2201, 2200, 
    2199, 2198, 2197, 2196, 2195, 2193, 
    2192, 2191, 2190, 2189, 2188, 2187, 
    2186, 2185, 2184, 2183, 2182, 2181, 
    2180, 2179, 2178, 2177, 2176, 2175, 
    2174, 2173, 2172, 6881, 6880, 7042, 
    2170, 2169, 2171, 2167, 2168, 14349, 
    14348, 14345
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00080

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_descriptions range PRIMARY,product_id PRIMARY 9 80 Using where

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
2167 Ben Townsend & James TaffBallisticSmalltown RecordsHard HouseHard DanceNRG Ben Townsend & James TaffBallisticSmalltown RecordsHard HouseHard DanceNRG Ben Townsend & James TaffBallisticSmalltown RecordsHard HouseHard DanceNRG
2168 WizardDo You BelieveStereodays RecordingsHard HouseHard DanceNRG WizardDo You BelieveStereodays RecordingsHard HouseHard DanceNRG WizardDo You BelieveStereodays RecordingsHard HouseHard DanceNRG
2169 Northern lads Noo Noo & Nogger team up with the talented James Taff for the launch of brand new label Slingshot Recordings. If you like your hard stuff with big rolling basslines, driving acid lines & twisted hoover synths then this will be right up your street! Noo Noo & Nogger vs James TaffTrashed In PublicSlingshot RecordingsHard HouseHard DanceNRG Noo Noo & Nogger vs James TaffTrashed In PublicSlingshot RecordingsHard HouseHard DanceNRG Noo Noo & Nogger vs James TaffTrashed In PublicSlingshot RecordingsHard HouseHard DanceNRG
2170 Adam MDisco ShitBoca Byrne RemixFireball RecordingsHard HouseHard DanceNRG Adam MDisco ShitBoca Byrne RemixFireball RecordingsHard HouseHard DanceNRG Adam MDisco ShitBoca Byrne RemixFireball RecordingsHard HouseHard DanceNRG
2171 EquinoxGet UpTonka TraxHard HouseHard DanceNRG EquinoxGet UpTonka TraxHard HouseHard DanceNRG EquinoxGet UpTonka TraxHard HouseHard DanceNRG
2172 Curve PusherParticle BoardTurtledog RecordingsHard HouseHard DanceNRG Curve PusherParticle BoardTurtledog RecordingsHard HouseHard DanceNRG Curve PusherParticle BoardTurtledog RecordingsHard HouseHard DanceNRG
2173 Dave OwensChemical Attack 2006Turtledog RecordingsHard HouseHard DanceNRG Dave OwensChemical Attack 2006Turtledog RecordingsHard HouseHard DanceNRG Dave OwensChemical Attack 2006Turtledog RecordingsHard HouseHard DanceNRG
2174 BasewareWoo-a-liciousTurtledog RecordingsHard HouseHard DanceNRG BasewareWoo-a-liciousTurtledog RecordingsHard HouseHard DanceNRG BasewareWoo-a-liciousTurtledog RecordingsHard HouseHard DanceNRG
2175 Dave OwensMaraschinoTurtledog RecordingsHard HouseHard DanceNRG Dave OwensMaraschinoTurtledog RecordingsHard HouseHard DanceNRG Dave OwensMaraschinoTurtledog RecordingsHard HouseHard DanceNRG
2176 BasewareBoomTurtledog RecordingsHard HouseHard DanceNRG BasewareBoomTurtledog RecordingsHard HouseHard DanceNRG BasewareBoomTurtledog RecordingsHard HouseHard DanceNRG
2177 Dave OwensOctane Turtledog RecordingsHard HouseHard DanceNRG Dave OwensOctane Turtledog RecordingsHard HouseHard DanceNRG Dave OwensOctane Turtledog RecordingsHard HouseHard DanceNRG
2178 Curve PusherFluxTurtledog RecordingsHard HouseHard DanceNRG Curve PusherFluxTurtledog RecordingsHard HouseHard DanceNRG Curve PusherFluxTurtledog RecordingsHard HouseHard DanceNRG
2179 D.F.O.ResonanceTurtledog RecordingsHard HouseHard DanceNRG D.F.O.ResonanceTurtledog RecordingsHard HouseHard DanceNRG D.F.O.ResonanceTurtledog RecordingsHard HouseHard DanceNRG
2180 Dave OwensONRTurtledog RecordingsHard HouseHard DanceNRG Dave OwensONRTurtledog RecordingsHard HouseHard DanceNRG Dave OwensONRTurtledog RecordingsHard HouseHard DanceNRG
2181 Captain Tinrib & Dave OwensFishcakeTurtledog RecordingsHard HouseHard DanceNRG Captain Tinrib & Dave OwensFishcakeTurtledog RecordingsHard HouseHard DanceNRG Captain Tinrib & Dave OwensFishcakeTurtledog RecordingsHard HouseHard DanceNRG
2182 Dave OwensEl PasoTurtledog RecordingsHard HouseHard DanceNRG Dave OwensEl PasoTurtledog RecordingsHard HouseHard DanceNRG Dave OwensEl PasoTurtledog RecordingsHard HouseHard DanceNRG
2183 Dave OwensCrisp & DryTurtledog RecordingsHard HouseHard DanceNRG Dave OwensCrisp & DryTurtledog RecordingsHard HouseHard DanceNRG Dave OwensCrisp & DryTurtledog RecordingsHard HouseHard DanceNRG
2184 Dave Owens & Defective AudioMacademiaTurtledog RecordingsHard HouseHard DanceNRG Dave Owens & Defective AudioMacademiaTurtledog RecordingsHard HouseHard DanceNRG Dave Owens & Defective AudioMacademiaTurtledog RecordingsHard HouseHard DanceNRG
2185 Phil CoganHeavy BassDave Owens VIP MixTurtledog RecordingsHard HouseHard DanceNRG Phil CoganHeavy BassDave Owens VIP MixTurtledog RecordingsHard HouseHard DanceNRG Phil CoganHeavy BassDave Owens VIP MixTurtledog RecordingsHard HouseHard DanceNRG
2186 Phil CoganHeavy BassDave Owens RemixTurtledog RecordingsHard HouseHard DanceNRG Phil CoganHeavy BassDave Owens RemixTurtledog RecordingsHard HouseHard DanceNRG Phil CoganHeavy BassDave Owens RemixTurtledog RecordingsHard HouseHard DanceNRG
2187 Curve PusherEchelonTurtledog RecordingsHard HouseHard DanceNRG Curve PusherEchelonTurtledog RecordingsHard HouseHard DanceNRG Curve PusherEchelonTurtledog RecordingsHard HouseHard DanceNRG
2188 Dave OwensCarbonaraTurtledog RecordingsHard HouseHard DanceNRG Dave OwensCarbonaraTurtledog RecordingsHard HouseHard DanceNRG Dave OwensCarbonaraTurtledog RecordingsHard HouseHard DanceNRG
2189 Evo D & MaxwellBlowing EcstacyDave Owens RemixTurtledog RecordingsHard HouseHard DanceNRG Evo D & MaxwellBlowing EcstacyDave Owens RemixTurtledog RecordingsHard HouseHard DanceNRG Evo D & MaxwellBlowing EcstacyDave Owens RemixTurtledog RecordingsHard HouseHard DanceNRG
2190 D.F.O.ResonanceValex RemixTurtledog RecordingsHard HouseHard DanceNRG D.F.O.ResonanceValex RemixTurtledog RecordingsHard HouseHard DanceNRG D.F.O.ResonanceValex RemixTurtledog RecordingsHard HouseHard DanceNRG
2191 Dave OwensFreezer BurnTurtledog RecordingsHard HouseHard DanceNRG Dave OwensFreezer BurnTurtledog RecordingsHard HouseHard DanceNRG Dave OwensFreezer BurnTurtledog RecordingsHard HouseHard DanceNRG
2192 GenkeiHam RadioTurtledog RecordingsHard HouseHard DanceNRG GenkeiHam RadioTurtledog RecordingsHard HouseHard DanceNRG GenkeiHam RadioTurtledog RecordingsHard HouseHard DanceNRG
2193 Dave OwensCinnabonTurtledog RecordingsHard HouseHard DanceNRG Dave OwensCinnabonTurtledog RecordingsHard HouseHard DanceNRG Dave OwensCinnabonTurtledog RecordingsHard HouseHard DanceNRG
2194 FlymoCashew Nut ShuffleCrunchy Peanut Butter Is Gross MixTurtledog RecordingsHard HouseHard DanceNRG FlymoCashew Nut ShuffleCrunchy Peanut Butter Is Gross MixTurtledog RecordingsHard HouseHard DanceNRG FlymoCashew Nut ShuffleCrunchy Peanut Butter Is Gross MixTurtledog RecordingsHard HouseHard DanceNRG
2195 Michael Smith & Dave OwensCaptivateTurtledog RecordingsHard HouseHard DanceNRG Michael Smith & Dave OwensCaptivateTurtledog RecordingsHard HouseHard DanceNRG Michael Smith & Dave OwensCaptivateTurtledog RecordingsHard HouseHard DanceNRG
2196 Dave OwensNandinoTurtledog RecordingsHard HouseHard DanceNRG Dave OwensNandinoTurtledog RecordingsHard HouseHard DanceNRG Dave OwensNandinoTurtledog RecordingsHard HouseHard DanceNRG
2197 Lusty & BonzoFeel GoodCurve Pusher RemixTurtledog RecordingsHard HouseHard DanceNRG Lusty & BonzoFeel GoodCurve Pusher RemixTurtledog RecordingsHard HouseHard DanceNRG Lusty & BonzoFeel GoodCurve Pusher RemixTurtledog RecordingsHard HouseHard DanceNRG
2198 Curve PusherProtocolTurtledog RecordingsHard HouseHard DanceNRG Curve PusherProtocolTurtledog RecordingsHard HouseHard DanceNRG Curve PusherProtocolTurtledog RecordingsHard HouseHard DanceNRG
2199 Doaf C90Turtledog RecordingsHard HouseHard DanceNRG Doaf C90Turtledog RecordingsHard HouseHard DanceNRG Doaf C90Turtledog RecordingsHard HouseHard DanceNRG
2200 Dave OwensBaked Not FriedTurtledog RecordingsHard HouseHard DanceNRG Dave OwensBaked Not FriedTurtledog RecordingsHard HouseHard DanceNRG Dave OwensBaked Not FriedTurtledog RecordingsHard HouseHard DanceNRG
2201 Curve PusherDisco DogTurtledog RecordingsHard HouseHard DanceNRG Curve PusherDisco DogTurtledog RecordingsHard HouseHard DanceNRG Curve PusherDisco DogTurtledog RecordingsHard HouseHard DanceNRG
2202 BasewareInspired By CandiTurtledog RecordingsHard HouseHard DanceNRG BasewareInspired By CandiTurtledog RecordingsHard HouseHard DanceNRG BasewareInspired By CandiTurtledog RecordingsHard HouseHard DanceNRG
2203 BasewareDon't Move YetTurtledog RecordingsHard HouseHard DanceNRG BasewareDon't Move YetTurtledog RecordingsHard HouseHard DanceNRG BasewareDon't Move YetTurtledog RecordingsHard HouseHard DanceNRG
2204 Dave OwensTitanTurtledog RecordingsHard HouseHard DanceNRG Dave OwensTitanTurtledog RecordingsHard HouseHard DanceNRG Dave OwensTitanTurtledog RecordingsHard HouseHard DanceNRG
2205 Dave OwensRobot HooverTurtledog RecordingsHard HouseHard DanceNRG Dave OwensRobot HooverTurtledog RecordingsHard HouseHard DanceNRG Dave OwensRobot HooverTurtledog RecordingsHard HouseHard DanceNRG
2206 Dave OwensBob-B-QTurtledog RecordingsHard HouseHard DanceNRG Dave OwensBob-B-QTurtledog RecordingsHard HouseHard DanceNRG Dave OwensBob-B-QTurtledog RecordingsHard HouseHard DanceNRG
2207 Gazz HuntPussy WhippedCurve Pusher RemixTurtledog RecordingsHard HouseHard DanceNRG Gazz HuntPussy WhippedCurve Pusher RemixTurtledog RecordingsHard HouseHard DanceNRG Gazz HuntPussy WhippedCurve Pusher RemixTurtledog RecordingsHard HouseHard DanceNRG
2208 Dave OwensCherokeeTurtledog RecordingsHard HouseHard DanceNRG Dave OwensCherokeeTurtledog RecordingsHard HouseHard DanceNRG Dave OwensCherokeeTurtledog RecordingsHard HouseHard DanceNRG
2209 Curve PusherEchelonDave Owens RemixTurtledog RecordingsHard HouseHard DanceNRG Curve PusherEchelonDave Owens RemixTurtledog RecordingsHard HouseHard DanceNRG Curve PusherEchelonDave Owens RemixTurtledog RecordingsHard HouseHard DanceNRG
2210 Dave OwensAiTurtledog RecordingsHard HouseHard DanceNRG Dave OwensAiTurtledog RecordingsHard HouseHard DanceNRG Dave OwensAiTurtledog RecordingsHard HouseHard DanceNRG
2211 Digital Mafia & Josh R USlicing BreadBoxed DigitalHard HouseHard DanceNRG Digital Mafia & Josh R USlicing BreadBoxed DigitalHard HouseHard DanceNRG Digital Mafia & Josh R USlicing BreadBoxed DigitalHard HouseHard DanceNRG
2212 Dave CurtisFire DevilCaterpillar TraxHard HouseHard DanceNRG Dave CurtisFire DevilCaterpillar TraxHard HouseHard DanceNRG Dave CurtisFire DevilCaterpillar TraxHard HouseHard DanceNRG
2213 Lee Jeffries & Justin BourneDrop The DimeLT1 & Riggsy's Deathstar MixDeathstar RecordingsHard HouseHard DanceNRG Lee Jeffries & Justin BourneDrop The DimeLT1 & Riggsy's Deathstar MixDeathstar RecordingsHard HouseHard DanceNRG Lee Jeffries & Justin BourneDrop The DimeLT1 & Riggsy's Deathstar MixDeathstar RecordingsHard HouseHard DanceNRG
2214 LT1Tuff TalkDeathstar RecordingsHard HouseHard DanceNRG LT1Tuff TalkDeathstar RecordingsHard HouseHard DanceNRG LT1Tuff TalkDeathstar RecordingsHard HouseHard DanceNRG
2216 Chris SummersMake A WishkRave RecordingsHard HouseHard DanceNRG Chris SummersMake A WishkRave RecordingsHard HouseHard DanceNRG Chris SummersMake A WishkRave RecordingsHard HouseHard DanceNRG
2217 ManikBlack Sun RisingMeltdown RecordsHard HouseHard DanceNRG ManikBlack Sun RisingMeltdown RecordsHard HouseHard DanceNRG ManikBlack Sun RisingMeltdown RecordsHard HouseHard DanceNRG
2218 James TaffStage 4Sublime ParadoxHard HouseHard DanceNRG James TaffStage 4Sublime ParadoxHard HouseHard DanceNRG James TaffStage 4Sublime ParadoxHard HouseHard DanceNRG
2219 BoneIDOL vs Stone & HewittAmnesiaStereodays RecordingsHard HouseHard DanceNRG BoneIDOL vs Stone & HewittAmnesiaStereodays RecordingsHard HouseHard DanceNRG BoneIDOL vs Stone & HewittAmnesiaStereodays RecordingsHard HouseHard DanceNRG
2220 Ben Stevens & Adam MMind BenderFireball RecordingsHard HouseHard DanceNRG Ben Stevens & Adam MMind BenderFireball RecordingsHard HouseHard DanceNRG Ben Stevens & Adam MMind BenderFireball RecordingsHard HouseHard DanceNRG
2221 Gaz GibsonStarlightVicious Circle RecordingsHard HouseHard DanceNRG Gaz GibsonStarlightVicious Circle RecordingsHard HouseHard DanceNRG Gaz GibsonStarlightVicious Circle RecordingsHard HouseHard DanceNRG
2222 Boca & Gary ByrneReady 4 MoreHi Oktane RecordingsHard HouseHard DanceNRG Boca & Gary ByrneReady 4 MoreHi Oktane RecordingsHard HouseHard DanceNRG Boca & Gary ByrneReady 4 MoreHi Oktane RecordingsHard HouseHard DanceNRG
2223 Matt MaraClean Like SheenTitanium TraxHard HouseHard DanceNRG Matt MaraClean Like SheenTitanium TraxHard HouseHard DanceNRG Matt MaraClean Like SheenTitanium TraxHard HouseHard DanceNRG
2225 EncodedThree WayEncoded NRGHard HouseHard DanceNRG EncodedThree WayEncoded NRGHard HouseHard DanceNRG EncodedThree WayEncoded NRGHard HouseHard DanceNRG
2226 Dan DysonTechnoidBoxed DigitalHard HouseHard DanceNRG Dan DysonTechnoidBoxed DigitalHard HouseHard DanceNRG Dan DysonTechnoidBoxed DigitalHard HouseHard DanceNRG
2227 Rookie & ReedyRiseStereodaysHard HouseHard DanceNRG Rookie & ReedyRiseStereodaysHard HouseHard DanceNRG Rookie & ReedyRiseStereodaysHard HouseHard DanceNRG
2228 Dave CurtisFire DevilCosta Pantazis RemixCaterpillar TraxHard HouseHard DanceNRG Dave CurtisFire DevilCosta Pantazis RemixCaterpillar TraxHard HouseHard DanceNRG Dave CurtisFire DevilCosta Pantazis RemixCaterpillar TraxHard HouseHard DanceNRG
2230 Fran DunneBoys On The CouchSmalltown RecordsHard HouseHard DanceNRG Fran DunneBoys On The CouchSmalltown RecordsHard HouseHard DanceNRG Fran DunneBoys On The CouchSmalltown RecordsHard HouseHard DanceNRG
2231 Milz'EQueen Ann's RevengeToolbox ChoonsHard HouseHard DanceNRG Milz'EQueen Ann's RevengeToolbox ChoonsHard HouseHard DanceNRG Milz'EQueen Ann's RevengeToolbox ChoonsHard HouseHard DanceNRG
2232 Rodi Style & James KShake & BakeVicious Circle RecordingsHard HouseHard DanceNRG Rodi Style & James KShake & BakeVicious Circle RecordingsHard HouseHard DanceNRG Rodi Style & James KShake & BakeVicious Circle RecordingsHard HouseHard DanceNRG
2233 Riggsy & LeftyOde To StaceFireball RecordingsHard HouseHard DanceNRG Riggsy & LeftyOde To StaceFireball RecordingsHard HouseHard DanceNRG Riggsy & LeftyOde To StaceFireball RecordingsHard HouseHard DanceNRG
2235 Marky T & Hilz'ESour SensationPure NRGHard HouseHard DanceNRG Marky T & Hilz'ESour SensationPure NRGHard HouseHard DanceNRG Marky T & Hilz'ESour SensationPure NRGHard HouseHard DanceNRG
2236 Karl Davis & Frank FarrellGoodtimesPure NRGHard HouseHard DanceNRG Karl Davis & Frank FarrellGoodtimesPure NRGHard HouseHard DanceNRG Karl Davis & Frank FarrellGoodtimesPure NRGHard HouseHard DanceNRG
2237 Ian FitzpatrickEverything's AlrightTwist TraxHard HouseHard DanceNRG Ian FitzpatrickEverything's AlrightTwist TraxHard HouseHard DanceNRG Ian FitzpatrickEverything's AlrightTwist TraxHard HouseHard DanceNRG
6427 DRD030,Dysonage Recordings,Dan Dyson
6457 DRD029,Dysonage Recordings,Dan Dyson
6642 UDT01,Underdog Trax,PSR,Dark 13
6665 B2T025B,B2T Recordings,Kye Shand,Justin Daniels,Jamie R,Charlie Bosh
6880 RC006,Revolution Corps,Krovax
6881 RC006,Revolution Corps,Krovax
7042 Dan Dyson and Rockin Russ, Filthatronic, Dysonage Recordings, Original Mix, Hard House, Toolbox Digital Download Filthatronic (Original Mix) by Dysonage Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. DRD028,Dysonage Recordings,Dan Dyson and Rockin Russ
14345 1391WNUK,Nukleuz Records,Little Jon,Tim Priestley,Pickup & Rise,Riggsy
14348 1391WNUK,Nukleuz Records,Leon Allen
14349 1391WNUK,Nukleuz Records,Paul Glazby
42056 Ghetto Blaster DJ Serenity Sensual Soundz Hard House Ghetto Blaster DJ Serenity Sensual Soundz Hard House Ghetto Blaster DJ Serenity Sensual Soundz Hard House
78852 TIDYBOYSHDD013D,Hard Drive,Robbie Muir
85113 TIDYD013,Tidy,Robbie Muir