1030 - Got error 28 from storage engine
select
p.products_fsk18,
p.products_shippingtime,
if(pa.attributes_model IS NULL,p.products_model,pa.attributes_model) AS products_model,
p.products_ean,
pd.products_name,
m.manufacturers_name,
p.products_quantity,
p.products_image,
p.products_weight,
pd.products_short_description,
pd.products_description,
p.products_id,
p.manufacturers_id,
p.products_price,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_discount_allowed,
p.products_tax_class_id,
p.products_sort,
bz.baugruppe,
bz.position
from
products_description pd,
products p
left join products_attributes AS pa ON pa.products_id = p.products_id
left join manufacturers m on p.manufacturers_id = m.manufacturers_id
left join specials s on p.products_id = s.products_id
left join baugruppen_zuordnung bz on p.products_sort = bz.position
left join products_to_vehicles as ptv ON ptv.products_id = p.products_id
where
p.products_status = '1'
and
pd.products_id = p.products_id
and
pd.language_id = '2'
and
(p.products_model IN('2902194','2930088','2920248','110500','2901335','2930527','2940482','2940672','2920249','2920254','2920253','2920252','2920251','2920255','2920256','2920257','2920258','2920259','2920262','2920263','2920264','2920265','2920266','2920267','2920268','2920269','2920270','2920271','2920273','2920274','2920276','2920277','2920278','2920279','2920282','2920284','2920285','2920286','2920287','2920288','2920289','2920290','2920291','2920295','2920297','2950162','2972402','2953930','2901336','4081002','2980585','2920260','2901707','3032040','4010216','4010608','3032286','2956126','4020351','4020377','4020531','4013449','4013458','4013457','4013453','4013452','4013451','4013450','4013455','4013431','4013460','4013476','4013464','4013461','4013471','4013472','4013473','4013474','4013475','4013477','4013478','4013482','4013483','4013485','4013486','4013463','4013467','4080053','4014995','4014997','4015001','4015012','4015015','4015016','4015017','4015018','4015023','4015025','4015037','4015039','4015045','4015049','4015050','4015055','4015063','4015065','4015082','4015087','4015093','4015095','4015098','4015100','4015106','4015111','4015118','4015121','4015123','4015124','4015128','4015131','4015133','4015134','4015140','4015142','4015143','4015144','4015149','4015151','4015154','4015156','4015161','4015162','4015172','4015175','4015177','4015179','4015183','4015184','4015188','4015191','4015192','4015194','4015196','4015199','4015200','4015201','4015204','4015210','4015211','4015212','4015213','4015220','4015224','4015227','4015232','4015234','4015237','4015238','4015242','4015243','4015247','4015249','4015250','4015252','4015253','4015255','4015256','4015263','4015266','4015269','4015272','4015276','4015284','4015285','4015286','4015287','4015288','4015301','4015303','4015309','4015314','4015315','4015316','4015319','4015325','4015327','4015330','4015331','4015332','4015340','4015345','4015347','4015348','4015350','4015352','4015356','4015358','4015360','4015364','4015366','4015368','4015370','4015371','4015375','4015376','4015378','4015380','4015385','4015389','4015391','4015393','4015395','4015397','4015401','4015406','4015411','4015415','4015426','4015428','4015429','4015430','4015431','4015432','4015438','4015443','4015445','4015450','4015451','4015453','4015454','4015455','4015456','4015462','4015464','4015465','4015466','4015468','4015472','4015473','4015476','4015478','4015479','4015480','4015481','4015484','4015485','4015495','4015497','4015498','4015500','4015502','4015505','4015509','4015513','4015514','4015515','4015517','4015523','4080054','4016882','4016883','4016884','4017819','4080378','4080385','4019193','4019194','4019195','4019197','4019198','4019199','4019200','4019201','4021711','4022003','4022308','4022429','2957099','2957100','2957101','2957104','2957111','2957112','2957114','2957115','4023377','4023378','7101132','7101134','7101135','7101149','4081080','2954146','2954149','2954264','2954281','2954356','4081363','7110546','7110547','7110548','7110549','7110550','7110551','7110559','7110562','7113426','7113427','7113428','7113429','7113431','7113433','7113434','7113435','7113438','7113439','7113440','7113432','7115277','7115279','7115280','7115282','7115284','7115285','7115286','7115287','7115288','7115289','7115290','7115291','7115294','7115296','7115297','7115299','7115300','7115301','7115302','7115303','7115304','7115305','4081594','4081749','4081750','4081751','4081753','4081754','4081755','4081756','4081760','4081761','4081762','4081764','4081765','4081767','4081768','4081769','4081770','4081771','4081772','4081773','4082190','4082268','4082582','5005131','5005130','5005088','5005122','5005104','4083389','4093782','4093792','4093796','4093794','4083194','5005082','5005106','5005101','5005120','5005087','5005097','5005076','5005114','5005113','5005083','5005112','5013012','5005078','5005084','5005089','5005090','5005096','5005098','5005102','5005103','5005107','5005108','5005109','5005110','5005116','8500047','8500259','8500988','8500011','4200115','4200116','4200117','4200118','4200119','4200120','4200121','4200122','4200123','4200124','4200125','4200127','4200128','4200129','4200628','4200629','4200669','4200670','4200671','4200677','4200678','4200679','4200724','4200725','4200726','4200737','4200738','4200739','4200740','4200741','4200742','4200743','4200744','5005119','5005121','5005123','5005124','5005125','5005126','5005127','5005128','5005129','VST-8900386','VST-8900398','VST-8900619','VST-8900298','VST-8900435','VST-8900663','VST-8900646','VST-8900621','VST-8900653','VST-8900245','VST-8900421','VST-8900662','VST-8900300','VST-8900684','VST-8900127','VST-8900618','VST-8900485','VST-8900773','VST-8900484','VST-8900186','VST-8900815','VST-8900807','WA-5000189','RV-6000188','SC-7000188','SL-9000188','WA-5000209','RV-6000208','SC-7000208','SL-9000208','WA-5000217','RV-6000216','SC-7000216','SL-9000216','WA-5000307','RV-6000306','SC-7000306','SL-9000306','WA-5000308','RV-6000307','SC-7000307','SL-9000307','WA-5000309','RV-6000308','SC-7000308','SL-9000308','WA-5000310','RV-6000309','SC-7000309','SL-9000309','WA-5000311','RV-6000310','SC-7000310','SL-9000310','WA-5000312','RV-6000311','SC-7000311','SL-9000311','WA-5000327','RV-6000326','SC-7000326','SL-9000326','WA-5000505','RV-6000504','SC-7000504','SL-9000504','WA-5000553','RV-6000552','SC-7000552','SL-9000552','WA-5000629','RV-6000628','SC-7000628','SL-9000628','WA-5000717','RV-6000716','SC-7000716','SL-9000716','WA-5000718','RV-6000717','SC-7000717','SL-9000717','WA-5000771','RV-6000770','SC-7000770','SL-9000770','WA-5000868','RV-6000867','SC-7000867','SL-9000867','WA-5000876','RV-6000875','SC-7000875','SL-9000875','WA-5000877','RV-6000876','SC-7000876','SL-9000876','WA-5000888','RV-6000887','SC-7000887','SL-9000887','WA-5000975','RV-6000975','SC-7000975','SL-9000975','WA-5000990','RV-6000990','SC-7000990','SL-9000990','4087172','4300796','4300851','4300865','4300871','4300879','4300899','4300912','4300926','4300936','4300952','4300961','4301003','4301013','4301082','4301332','8700277','4200726') OR pa.attributes_model IN('2902194','2930088','2920248','110500','2901335','2930527','2940482','2940672','2920249','2920254','2920253','2920252','2920251','2920255','2920256','2920257','2920258','2920259','2920262','2920263','2920264','2920265','2920266','2920267','2920268','2920269','2920270','2920271','2920273','2920274','2920276','2920277','2920278','2920279','2920282','2920284','2920285','2920286','2920287','2920288','2920289','2920290','2920291','2920295','2920297','2950162','2972402','2953930','2901336','4081002','2980585','2920260','2901707','3032040','4010216','4010608','3032286','2956126','4020351','4020377','4020531','4013449','4013458','4013457','4013453','4013452','4013451','4013450','4013455','4013431','4013460','4013476','4013464','4013461','4013471','4013472','4013473','4013474','4013475','4013477','4013478','4013482','4013483','4013485','4013486','4013463','4013467','4080053','4014995','4014997','4015001','4015012','4015015','4015016','4015017','4015018','4015023','4015025','4015037','4015039','4015045','4015049','4015050','4015055','4015063','4015065','4015082','4015087','4015093','4015095','4015098','4015100','4015106','4015111','4015118','4015121','4015123','4015124','4015128','4015131','4015133','4015134','4015140','4015142','4015143','4015144','4015149','4015151','4015154','4015156','4015161','4015162','4015172','4015175','4015177','4015179','4015183','4015184','4015188','4015191','4015192','4015194','4015196','4015199','4015200','4015201','4015204','4015210','4015211','4015212','4015213','4015220','4015224','4015227','4015232','4015234','4015237','4015238','4015242','4015243','4015247','4015249','4015250','4015252','4015253','4015255','4015256','4015263','4015266','4015269','4015272','4015276','4015284','4015285','4015286','4015287','4015288','4015301','4015303','4015309','4015314','4015315','4015316','4015319','4015325','4015327','4015330','4015331','4015332','4015340','4015345','4015347','4015348','4015350','4015352','4015356','4015358','4015360','4015364','4015366','4015368','4015370','4015371','4015375','4015376','4015378','4015380','4015385','4015389','4015391','4015393','4015395','4015397','4015401','4015406','4015411','4015415','4015426','4015428','4015429','4015430','4015431','4015432','4015438','4015443','4015445','4015450','4015451','4015453','4015454','4015455','4015456','4015462','4015464','4015465','4015466','4015468','4015472','4015473','4015476','4015478','4015479','4015480','4015481','4015484','4015485','4015495','4015497','4015498','4015500','4015502','4015505','4015509','4015513','4015514','4015515','4015517','4015523','4080054','4016882','4016883','4016884','4017819','4080378','4080385','4019193','4019194','4019195','4019197','4019198','4019199','4019200','4019201','4021711','4022003','4022308','4022429','2957099','2957100','2957101','2957104','2957111','2957112','2957114','2957115','4023377','4023378','7101132','7101134','7101135','7101149','4081080','2954146','2954149','2954264','2954281','2954356','4081363','7110546','7110547','7110548','7110549','7110550','7110551','7110559','7110562','7113426','7113427','7113428','7113429','7113431','7113433','7113434','7113435','7113438','7113439','7113440','7113432','7115277','7115279','7115280','7115282','7115284','7115285','7115286','7115287','7115288','7115289','7115290','7115291','7115294','7115296','7115297','7115299','7115300','7115301','7115302','7115303','7115304','7115305','4081594','4081749','4081750','4081751','4081753','4081754','4081755','4081756','4081760','4081761','4081762','4081764','4081765','4081767','4081768','4081769','4081770','4081771','4081772','4081773','4082190','4082268','4082582','5005131','5005130','5005088','5005122','5005104','4083389','4093782','4093792','4093796','4093794','4083194','5005082','5005106','5005101','5005120','5005087','5005097','5005076','5005114','5005113','5005083','5005112','5013012','5005078','5005084','5005089','5005090','5005096','5005098','5005102','5005103','5005107','5005108','5005109','5005110','5005116','8500047','8500259','8500988','8500011','4200115','4200116','4200117','4200118','4200119','4200120','4200121','4200122','4200123','4200124','4200125','4200127','4200128','4200129','4200628','4200629','4200669','4200670','4200671','4200677','4200678','4200679','4200724','4200725','4200726','4200737','4200738','4200739','4200740','4200741','4200742','4200743','4200744','5005119','5005121','5005123','5005124','5005125','5005126','5005127','5005128','5005129','VST-8900386','VST-8900398','VST-8900619','VST-8900298','VST-8900435','VST-8900663','VST-8900646','VST-8900621','VST-8900653','VST-8900245','VST-8900421','VST-8900662','VST-8900300','VST-8900684','VST-8900127','VST-8900618','VST-8900485','VST-8900773','VST-8900484','VST-8900186','VST-8900815','VST-8900807','WA-5000189','RV-6000188','SC-7000188','SL-9000188','WA-5000209','RV-6000208','SC-7000208','SL-9000208','WA-5000217','RV-6000216','SC-7000216','SL-9000216','WA-5000307','RV-6000306','SC-7000306','SL-9000306','WA-5000308','RV-6000307','SC-7000307','SL-9000307','WA-5000309','RV-6000308','SC-7000308','SL-9000308','WA-5000310','RV-6000309','SC-7000309','SL-9000309','WA-5000311','RV-6000310','SC-7000310','SL-9000310','WA-5000312','RV-6000311','SC-7000311','SL-9000311','WA-5000327','RV-6000326','SC-7000326','SL-9000326','WA-5000505','RV-6000504','SC-7000504','SL-9000504','WA-5000553','RV-6000552','SC-7000552','SL-9000552','WA-5000629','RV-6000628','SC-7000628','SL-9000628','WA-5000717','RV-6000716','SC-7000716','SL-9000716','WA-5000718','RV-6000717','SC-7000717','SL-9000717','WA-5000771','RV-6000770','SC-7000770','SL-9000770','WA-5000868','RV-6000867','SC-7000867','SL-9000867','WA-5000876','RV-6000875','SC-7000875','SL-9000875','WA-5000877','RV-6000876','SC-7000876','SL-9000876','WA-5000888','RV-6000887','SC-7000887','SL-9000887','WA-5000975','RV-6000975','SC-7000975','SL-9000975','WA-5000990','RV-6000990','SC-7000990','SL-9000990','4087172','4300796','4300851','4300865','4300871','4300879','4300899','4300912','4300926','4300936','4300952','4300961','4301003','4301013','4301082','4301332','8700277','4200726'))
AND ptv.vehicle_id = '379206'
GROUP BY
p.products_model
ORDER BY
bz.baugruppe
[XT SQL Error]
