DOC, STY: in code documentation and styling for readablility
Compare changes
+ 28
− 12
@@ -34,30 +34,31 @@ DELIMITER //
@@ -81,6 +82,10 @@ POV_LABEL: BEGIN
@@ -229,6 +234,8 @@ POV_LABEL: BEGIN
@@ -243,6 +250,7 @@ POV_LABEL: BEGIN
@@ -259,6 +267,7 @@ POV_LABEL: BEGIN
@@ -299,7 +308,14 @@ POV_LABEL: BEGIN
SET @stmtPOVkeepTblStr = CONCAT('INSERT IGNORE INTO `', keepTabl, '` (id) SELECT DISTINCT entity_id AS id FROM ', data, ' as data', IF(propertiesTable IS NULL, '', CONCAT(' WHERE EXISTS (Select 1 from `', propertiesTable, '` AS prop WHERE prop.id = data.property_id AND (prop.id2=data.entity_id OR prop.id2=0))')));