Φάρμακα
select `categories_data`.*, t11.value as num11, t12.value as num12, t13.value as num13, t22.value as num22, t14.value as num14, t45.value as num45, t16.value as num16, t15.value as num15, t17.value as num17 from `categories_data` left join `categories_data_int` as t11 on (categories_data.id = t11.parent_id and t11.`field_id` = 11) left join `categories_data_varchar` as t12 on (categories_data.id = t12.parent_id and t12.`field_id` = 12) left join `categories_data_varchar` as t13 on (categories_data.id = t13.parent_id and t13.`field_id` = 13) left join `categories_data_varchar` as t22 on (categories_data.id = t22.parent_id and t22.`field_id` = 22) left join `categories_data_float` as t14 on (categories_data.id = t14.parent_id and t14.`field_id` = 14) left join `categories_data_varchar` as t45 on (categories_data.id = t45.parent_id and t45.`field_id` = 45) left join `categories_data_float` as t16 on (categories_data.id = t16.parent_id and t16.`field_id` = 16) left join `categories_data_float` as t15 on (categories_data.id = t15.parent_id and t15.`field_id` = 15) left join `categories_data_varchar` as t17 on (categories_data.id = t17.parent_id and t17.`field_id` = 17), `catalog_categories_data` where `categories_data`.`parent_id` = 2 and `catalog_categories_data`.`category_id`=2 and `catalog_categories_data`.`data_id` = `categories_data`.`id` order by num12 LIMIT -20,20 [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-20,20' at line 1]select `categories_data`.*, t11.value as num11, t12.value as num12, t13.value as num13, t22.value as num22, t14.value as num14, t45.value as num45, t16.value as num16, t15.value as num15, t17.value as num17 from `categories_data` left join `categories_data_int` as t11 on (categories_data.id = t11.parent_id and t11.`field_id` = 11) left join `categories_data_varchar` as t12 on (categories_data.id = t12.parent_id and t12.`field_id` = 12) left join `categories_data_varchar` as t13 on (categories_data.id = t13.parent_id and t13.`field_id` = 13) left join `categories_data_varchar` as t22 on (categories_data.id = t22.parent_id and t22.`field_id` = 22) left join `categories_data_float` as t14 on (categories_data.id = t14.parent_id and t14.`field_id` = 14) left join `categories_data_varchar` as t45 on (categories_data.id = t45.parent_id and t45.`field_id` = 45) left join `categories_data_float` as t16 on (categories_data.id = t16.parent_id and t16.`field_id` = 16) left join `categories_data_float` as t15 on (categories_data.id = t15.parent_id and t15.`field_id` = 15) left join `categories_data_varchar` as t17 on (categories_data.id = t17.parent_id and t17.`field_id` = 17), `catalog_categories_data` where `categories_data`.`parent_id` = 2 and `catalog_categories_data`.`category_id`=2 and `catalog_categories_data`.`data_id` = `categories_data`.`id` order by num12 LIMIT -20,20 [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-20,20' at line 1]
DB Error: syntax error