[Jonas]

Ursprungligen postat av PaLL3

Jag körde denna istället;

$result = mysql_query("select itemid from entity_attributes e where(select count(*) from entity_attributes where itemid = e.itemid and attributeid = 280) = 1 and (select count(*) from entity_attributes where itemid = e.itemid and attributeid = 276) = 1");
while($row = mysql_fetch_array($result)) $list .= $row['ItemID'] . ',';
mysql_query("delete from entity_attributes where itemid in ($list)");

Funkade inte heller...

$result = mysql_query("select distinct itemid from entity_attributes e where attributeid= 276 OR attributeid=280");
while($row = mysql_fetch_assoc($result))
$list[] = $row['itemid'];

mysql_query("delete from entity_attributes where itemid in (" . implode(',',$list) . ")");

Ser ingen skillnad i detta mot vad du komplicerat?