2013 - Lost connection to MySQL server during query
select pov.products_options_values_name, p.products_id, ps.products_stock_quantity, pa.options_id, pa.options_values_id, pa.options_values_id, pov.products_options_values_name, pov.products_options_values_color from products p
inner join products_to_categories p2c on p.products_id=p2c.products_id
inner join categories c on p2c.categories_id=c.categories_id and c.categories_status= 1
left join products_attributes pa on pa.products_id=p.products_id
left join products_options po on pa.options_id=po.products_options_id and po.language_id = '4'
left join products_options_values pov on pa.options_values_id = pov.products_options_values_id and pov.language_id = '4'
left join products_stock ps on ps.products_id=p.products_id
left join specials s on p.products_id = s.products_id
left join manufacturers m using(manufacturers_id) inner join products_attributes pa1 on p.products_id=pa1.products_id
inner join products_options po1 on pa1.options_id=po1.products_options_id and po1.language_id = '4'
inner join products_options_values pov1 on pa1.options_values_id = pov1.products_options_values_id and pov1.language_id = '4' where 1=1 and p.products_status = 1 and p2c.categories_id = '33' and c.categories_id = '33' and pa.options_id = "1" and ( ps.products_stock_attributes rlike concat( '(^|,)', pa.options_id,'\-', pa.options_values_id, '($|,*[0-9]*-*[0-9]*)' ) and ps.products_stock_quantity > 0 ) and pa.options_id = "1" group by pov.products_options_values_name order by pov.products_options_values_name asc
[TEP STOP]
2006 - MySQL server has gone away
select count(*) as total from sessions where sesskey = 'cqc0shp3752268na44n8ac9jd0'