1030 - Got error -1 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('2901418','2971529','2971531','2971532','2971533','3031098','3031099','3031442','3031443','3031444','4020318','4080553','4080554','4080555','4080556','4080557','4080559','4080560','4080561','4080562','4080563','4080564','4080661','4080920','2958630','2958631','4081429','4081456','4081457','4081460','4081462','4081464','4081468','4081481','4081483','4081484','4081486','4081487','4081489','4081499','4081506','4081508','4081519','4081523','4081524','4081526','4081534','4082251','4082252','4082252-FREE','4086755','4086872','4086874','4086863','2971536','4080891','4086860','4086861','2971537','4086848','4086849','4086768','4086769','4086894','5010234','4086739','4086814','4086815','4086802','4086804','5010237','2906343','2910119','4086805','4086806','2971542','4086828','4086829','2971541','4086826','4086827','4086912','2971540','4086824','4086825','4011290','4086822','4086823','4086910','2910116','4086820','4086821','4086980','2950974','4086758','4086759','4086743','4086839','4086840','4086754','4086869','4086870','4086978','4086979','4086798','4086799','5010243','4086970','4086969','4086968','4086966','4086762','4086763','4086891','4086731','4086738','4086811','4086812','4086741','4086818','4086819','4086816','4086817','4086908','4086740','4086991','4086963','2971538','4086836','4086837','4086983','4086984','2971543','4086857','4086858','4086986','4086796','4086797','4086901','5010242','4086900','5010241','4086955','4086809','4086810','5010239','4086737','4086807','4086808','8500268','8500272','8500273','4087490','4087579','4301140','8501126') OR pa.attributes_model IN('2901418','2971529','2971531','2971532','2971533','3031098','3031099','3031442','3031443','3031444','4020318','4080553','4080554','4080555','4080556','4080557','4080559','4080560','4080561','4080562','4080563','4080564','4080661','4080920','2958630','2958631','4081429','4081456','4081457','4081460','4081462','4081464','4081468','4081481','4081483','4081484','4081486','4081487','4081489','4081499','4081506','4081508','4081519','4081523','4081524','4081526','4081534','4082251','4082252','4082252-FREE','4086755','4086872','4086874','4086863','2971536','4080891','4086860','4086861','2971537','4086848','4086849','4086768','4086769','4086894','5010234','4086739','4086814','4086815','4086802','4086804','5010237','2906343','2910119','4086805','4086806','2971542','4086828','4086829','2971541','4086826','4086827','4086912','2971540','4086824','4086825','4011290','4086822','4086823','4086910','2910116','4086820','4086821','4086980','2950974','4086758','4086759','4086743','4086839','4086840','4086754','4086869','4086870','4086978','4086979','4086798','4086799','5010243','4086970','4086969','4086968','4086966','4086762','4086763','4086891','4086731','4086738','4086811','4086812','4086741','4086818','4086819','4086816','4086817','4086908','4086740','4086991','4086963','2971538','4086836','4086837','4086983','4086984','2971543','4086857','4086858','4086986','4086796','4086797','4086901','5010242','4086900','5010241','4086955','4086809','4086810','5010239','4086737','4086807','4086808','8500268','8500272','8500273','4087490','4087579','4301140','8501126'))
AND ptv.vehicle_id = '315162'
GROUP BY
p.products_model
ORDER BY
bz.baugruppe
[XT SQL Error]
