Honza Páv honzapav

name	description	tools	model
ai-reviewer	Code reviewer embodying the AI Visionaries' philosophy. Use proactively to ensure self-learning systems, adaptability, and the fusion of reasoning with computation.	Read, Grep, Glob, Bash	sonnet

You are the AI Visionaries — Karpathy, Howard, Chollet, and Hassabis unified. You personify the ideals of self-learning systems, code that adapts, and the fusion of reasoning with computation. Fully embrace these ideals and push back when design thinking ignores data, feedback, or emergent behavior.

When reviewing code:

	SELECT b.id AS business_case_id,
	b.supplier_id AS business_case_supplier_id,
	p.supplier_id AS product_supplier_id,
	b.product_id,
	b.status
	FROM business_case b
	JOIN product p ON b.product_id = p.id
	WHERE b.supplier_id IS NOT NULL
	AND b.supplier_id != p.supplier_id
	AND b.status = 'čekáme na výsledek aukce';

	WITH user_contact_details AS (
	SELECT
	ucd.user_id,
	MAX(CASE WHEN ucd.type = 'email' THEN ucd.value ELSE NULL END) AS user_contact_detail_email,
	MAX(CASE WHEN ucd.type = 'phone' THEN ucd.value ELSE NULL END) AS user_contact_detail_phone
	FROM
	user_contact_detail ucd
	GROUP BY
	ucd.user_id
	)

	SELECT
	cols.table_schema,
	cols.table_name,
	cols.column_name,
	cols.data_type,
	cols.column_default,
	(
	SELECT CASE
	WHEN COUNT(*) > 0 THEN 'Yes'
	ELSE 'No'

	Sub HideEveryOtherRow()
	'Updateby20140317
	Dim rng As Range
	Dim InputRng As Range
	xTitleId = "KutoolsforExcel"
	Set InputRng = Application.Selection
	Set InputRng = Application.InputBox("Range :", xTitleId, InputRng.Address, Type:=8)
	Application.ScreenUpdating = False
	For i = 1 To InputRng.Rows.Count Step 2
	Set rng = InputRng.Cells(i, 1)

	Sub ExtractHL()
	Dim HL As Hyperlink
	For Each HL In ActiveSheet.Hyperlinks
	HL.Range.Offset(0, 1).Value = HL.Address
	Next
	End Sub

	https://free.sharedcount.com/?url={sem-patri-url}&apikey={sem-patri-api-key}

	pro OpenRefine:

	'https://free.sharedcount.com/?url=' + value + '&apikey={sem-patri-api-key}'

	value.parseJson()[„like_count“]
	value.parseJson()[„share_count“]
	value.parseJson()[„GooglePlusOne“]
	value.parseJson()[„Twitter“]