am: 29. September 2020, 11:53:08
Zeile 469:
$values_query_raw = "SELECT ptv.*
FROM " . TABLE_PRODUCTS_TAGS_VALUES . " ptv
JOIN " . TABLE_PRODUCTS_TAGS_OPTIONS . " pto
ON pto.options_id = ptv.options_id
AND pto.languages_id = '".(int)$_SESSION['languages_id']."'
WHERE ptv.options_id = '".$_GET['oID']."'
AND ptv.languages_id = '".(int)$_SESSION['languages_id']."'
ORDER BY ptv.sort_order, ptv.values_name";
wofür einen Full Join auf eine Tabelle, wenn man daraus nicht eine Spalte nutzt?
$values_query_raw = "SELECT ptv.*
FROM " . TABLE_PRODUCTS_TAGS_VALUES . " ptv
WHERE ptv.options_id = '".$_GET['oID']."'
AND ptv.languages_id = '".(int)$_SESSION['languages_id']."'
ORDER BY ptv.sort_order, ptv.values_name";
Sollte reichen. Oder überseh ich was?
Linkback: https://www.modified-shop.org/forum/index.php?topic=41361.0