Skip to content

Instantly share code, notes, and snippets.

View derkhadim's full-sized avatar
🏠
Working from home

Mouhamadou DER derkhadim

🏠
Working from home
View GitHub Profile
@webchick
webchick / most_wanted
Created September 20, 2017 08:19
Top 50 "most wanted" Drupal 8 contrib modules (by followers in the "contrib_tracker" project)
mysql> SELECT n.nid, n.title, c.count AS followers
-> FROM node n
-> INNER JOIN flag_counts c ON c.entity_id = n.nid
-> INNER JOIN field_data_field_project p ON p.entity_id = n.nid
-> INNER JOIN field_data_field_issue_status s ON s.entity_id = n.nid
-> WHERE p.field_project_target_id = 2573607 /* contrib_tracker */
-> AND s.field_issue_status_value NOT IN (2, 7, 3) /* fixed, closed (fixed), closed (duplicate) */
-> ORDER BY c.count DESC
-> LIMIT 50;
+---------+-----------------------------------------------------------+-----------+
@zthxxx
zthxxx / Activate Office 2019 for macOS VoL.md
Last active June 13, 2024 08:06
crack activate Office on mac with license file
@robhrt7
robhrt7 / MySQL_5-7_macOS.md
Last active February 28, 2024 03:48 — forked from nrollr/MySQL_macOS_Sierra.md
Install MySQL 5.7 on macOS using Homebrew

This is a fork of original gist https://gist.github.com/nrollr/3f57fc15ded7dddddcc4e82fe137b58e, with slight changes on pointing to 5.7 version branch, instead of 8 (latest default of MySQL in Hombrew).

Install MySQL 5.7 on macOS

This procedure explains how to install MySQL using Homebrew on macOS (Sierra 10.12 and up)

Install Homebrew

  • Installing Homebrew is effortless, open Terminal and enter :
    $ /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
  • Note: Homebrew will download and install Command Line Tools for Xcode 8.0 as part of the installation process.
@bradtraversy
bradtraversy / vscode_shortcuts.md
Last active June 14, 2024 04:01
Helpful shortcuts for VSCode

VSCode Shortcuts

List of helpful shortcuts for faster coding

If you have any other helpful shortcuts, feel free to add in the comments of this gist :)

Official List of all commands