MYSQL : Table 'bellevy.catitemext' doesn't exist RIFERIMENTO :: select max(i.item_price) as max, min(i.item_price) as min from ( select a.item_id from item as a join itemcountry on a.item_id = itemcountry.item_id left join user on user.user_id = a.user_id left join ana on ana.ana_id = user.ana_id left join catitemext on catitemext.catitem_id = a.catitem_id join itemattr as ia1 on ia1.item_id = a.item_id and ia1.attr_id = '22' and (ia1.attrvalue_id = '42' or ia1.itemattr_value = '42') where a.item_temp is null and a.catitem_id IN (8,1007,1018,1019,1020,1023,1024,1025,1027,1028,1029,1030,1031,1032,1150,1166,1169,1171,1008,1034,1035,1036,1037,1038,1039,1040,1041,1042,1164,1152,1154,1155,1156,1157,1158,1159,1160,1161,1162) and a.item_id IN ( select i.item_id from item as i join tblobjects as t on i.item_prod_tblobjects_id = t.objectID left join tblobjects as t1 on t.parentID = t1.objectID left join tblobjects as t2 on t1.parentID = t2.objectID left join tblobjects as t3 on t2.parentID = t3.objectID where t.objectID = 8229 or t1.objectID = 8229 or t2.objectID = 8229 or t3.objectID = 8229 ) and a.catitemstatus_id = '100' and itemcountry.country = 'IT' and a.catitemstatus_id > 1 ) as si join item as i on si.item_id = i.item_id