Product: Sagitta Brutalis 1080 (PN S3480-GTX-1080-2697-128)
Software: Hashcat v3.00-beta-145-g069634a, Nvidia driver 367.18
Accelerator: 8x Nvidia GTX 1080 Founders Edition
rhoerr
/ create_aggregated_eav_views.sql
Last active
May 15, 2025 15:11
MySQL views to aggregate Magento 2 EAV data -- requires MySQL 5.7+ or equivalent
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * Create aggregated SQL views for default EAV entity types in Magento: | |
| * - dev_category | |
| * - dev_product | |
| * - dev_customer | |
| * - dev_address | |
| * | |
| * Each view has the primary entity table, plus associated EAV values (eav_int, eav_text, etc). | |
| * This is meant as a development tool to quickly see or select scoped data for a given entity. | |
| * Do not use these for any runtime code, and be careful about how many rows you fetch at once. |